EBS R12设置 问题及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, theoperating unit can be selected in the party tax profile form within EB Tax buta 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 unitis defined incorrectly. The sql used to select operating units in EBTax validates that the country code is correct. Unfortunately theLocations 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 abreviationSave

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 isa setup issue. Cash Management responsibility mustbe 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. Clickon theupdate icon.
9. A new window will be displayed, please click in the Security wizard button.
10. For CE UMX Security wizard clickon 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 choosethe privilagesthat 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.
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06502

　　
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 <ar_system_parameters_all>.
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.