EBS R12 set the problems and solutions for collecting Matelink

EBS R12 set the problems and solutions for collecting Matelink

1) Tax is empty when create a tax jurisdiction

Oracle E-Business Tax – Version: 12.0.2
Information in this document applies to any platform.

Goal

Q1: Created a new Tax Regime, Tax and Tax Status in E-Business Tax.
Now want to create a Tax Jurisdiction that can be linked up to a Rate so that I can complete the configuration.
When I go to select the Tax value on the "Create Tax Jurisdiction" page, nothing is listed in the LOV.
As a result, cannot complete the Tax Jurisdiction configuration.
What am I missing?

Q2: For the Taxes that got migrated as part of the upgrade from 11.5.9 to R12, tax jurisdiction values does not exist. Is this intended?

Solution

A1: Check your tax setup.  Have you defined geography type? If not,  you will be not be able to tie the geography based setting of tax jurisdictions, without first defining this.

A2: Yes, this is correct, this is the intended functionality. Please see comment from development in Bug 5713854:
"Only for migrated records, we cannot derive jurisdiction for a tax. So only for migrated records, system allows tax definition without having associated jurisdictions."

2)Geography Name is empty when create a tax juristiction

Oracle Project Costing – Version: 12.0 to 12.1
This problem can occur on any platform.

Symptoms

In  a fresh release 12 environment, when creating  a new jurisdiction, the Geography values (state, province, city, etc) cannot be found in the list of values (LOV).  No records are retured or in some cases only some are returned.

Changes

Geography hierarchy was defined for a new country from scratch

Cause

The Geography start dates were set to be 30-Dec-2008 but the Tax and Jurisdictions were being defined with back dated dates of 01-Jan-2000.  Since the geographies were not active on that earlier date they did not show up in the list of values. 

Solution

Resolution for this was to change the start date of the tax and jurisdiction to be on or after the start date of the geography values.

3)Receivable Activities
Error: Please define a party tax profile for operating unit &ORG_ID

Oracle Receivables – Version: 12.0 to 12.0
This problem can occur on any platform.
ARXSUMRT.fmb

Symptoms

Unable to setup Receivables Activities. When attempt to navigate to
form.

Navigator drop-down > Setup, Receivable, Receivable Activities
Error: Please define a party tax profile for operating unit &ORG_ID

Cause

The issue is caused by the following setup:
Did not setup Operating Unit owning Tax Content Profile

This issue is described in Bug 5899659 – RECEIVABLES ACTIVITY ERROR PLEASE DEFINE PARTY TAX PROFILE FOR &ORDID

Solution

To implement the solution, please execute the following steps:

1. Go into the responsibility: Tax Managers

2. Navigate to Parties -> Party Tax -> Profiles

3. Party Type: Operating Unit Owning Tax Content
Party Name: populate your Operating Unit Name

You should have a result to this query.
If you do not make sure you create a Party Tax Profile for your operating Unit of the
Type: First Party Legal Entity.

4. Verify the each component of location address associated with your organization is valid

5. Retest the issue.

6. Migrate the solution as appropriate to other environments

4)Unable to create a party tax profile for a newly defined operating unit

Oracle E-Business Tax – Version: 12.0 to 12.1
This problem can occur on any platform.

Symptoms

After setting up a new operating unit, the operating unit can be selected in the party tax profile form within EB Tax but a profile cannot be created as the create button is not displayed.

Changes

Occurs when a new operating unit is defined

Cause

This occurs when the location address associated to the new operating unit is defined incorrectly.  The sql used to select operating units in EBTax validates that the country code is correct.  Unfortunately the Locations form allows a user to enter the country code free-form thus if a user enters "United States" instead of US the operating unit will not be displayed.

Solution

– To implement the solution, please execute the following steps::
1. Go into the responsibility: Receivables Manager

2. Navigate to Setup > System > Organizations > Locations

3. Query the Location that you have defined for the new operating unit

4. Open the address and change the country from to use the proper 2 digit abreviation Save

5. Return to tax manager and verify that you can now set the party tax profile

5）Unable to See the Legal Entity List of Value in the Bank Account Owner Field

Oracle Cash Management – Version: 12.0 to 12.0
This problem can occur on any platform.
AccountOwnerUsePG 120.8

Symptoms

Unable to create a new bank account in release 12 in Cash Management.  The list of value in the Bank account Owner does not bring the information of the Legal Entities that have been created.

Cause

This is not a bug, it is a setup issue. Cash Management responsibility must be assigned the Legal Entities that you want to grant the access to all bank accounts.

Solution

Please do the following to assign Legal Entities to the Cash Management responsibility :

1. Log in as Sysadmin.
2. Go to the User Management Responsibility.
3. Path: Roles & Role Inheritance
4. In the Type field select Roles and Responsibilities
5. Wait until a new field appears, you will see the category field, please select Miscellaneous
6. In the Application select ‘Cash Management’ and click on GO button.
7. Search your Cash Management responsibility or role that you are using to create your bank account.
8. Click on the update icon.
9. A new window will be displayed, please click in the Security wizard button.
10. For CE UMX Security wizard click on the Run Wizard.
11. In this window you should add the legal entities that you want to grant the access to all the
bank accounts within a legal entity and choose the privilages that you want to assign to this role on the
bank accounts such as: USE, MAINTENANCE and BANK ACCOUNT TRANSFERS.
12. Save and apply the changes and then verify in Cash management responsibility if you now are
able to see that legal entity in the bank account creation form.

6）ARXSUDRC: Cannot Open Receipt Class Form – FRM-40735, ORA-6502

Oracle Receivables – Version: 12.0.5
This problem can occur on any platform.

Symptoms

When attempting to enter the Receipt Classes form, the following error occurs.

de>FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06502 de>

The issue can be reproduced at will with the following steps:

1. Log into application and select Receivables responsibility
2. NAV:Setup->Receipts->Receipt Classes

Due to this issue, users cannot complete the setup

Cause

Replicate Seed Data has not been executed. Running Replicate Seed Data process will create the seed data for the new Operating Unit

Solution

To implement the solution, please execute the following steps:

1. Connect to the application with System Administrator responsibility
2. Run concurrent program ‘Replicate Seed Data’

7)Receivable Activities screen when opened throws error ORA-01422: exact fetch returns more than requested number of rows.

Oracle Receivables – Version: 12.0 to 12.0.6
This problem can occur on any platform.
Receivables Activities Form.

Symptoms

Symptoms:

When opening the Receivable Activities screen it triggers.

ORA-01422: exact fetch returns more than requested number of rows.

Cause

The cause of the issue is invalid / incorrect data in .
Found that there were duplicate records for the ORG_ID with set_of_books_id = -1.

Solution

Execute the below scripts in the TEST INSTANCE and retest the issue before migrating the changes to PRODUCTION.

create table AR_SYSTEM_PARAMETERS_ALL_bckup_82
as select * from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = <&enter_org_id for operating_unit>;

delete from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = <&enter_org_id for operating_unit>;
COMMIT;

After executing the scripts, log out of ORACLE Applications and log in again so that the parameters get affected.
Click on Receivables Responsibility and Navigate to Set up -> Receipts -> Receivables Activities and retest the issue.