Last updated on AUGUST 24, 2016
Applies to:
Oracle Receivables - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]Information in this document applies to any platform.
Symptoms
A dynamic package is created for every ORG_ID in your instance. The package name format is ARP_STAX_<ORG_ID>.
For example if you had an Operating Unit with ORG_ID = 121, then a package named ARP_STAX_121 would be created.
After applying FIN_PF.G, you note that ARP_STAX_<ORG_ID> is invalid. The error is as follows:
SQL> ALTER PACKAGE APPS.ARP_STAX_121 COMPILE BODY;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY APPS.ARP_STAX_121:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1867/7 PL/SQL: Statement ignored
1885/13 PL/SQL: SQL Statement ignored
1885/18 PLS-00201: identifier 'C_TAX_EXEMPT' must be declared
1886/13 PL/SQL: SQL Statement ignored
1886/19 PLS-00201: identifier 'C_TAX_EXEMPT' must be declared
1887/13 PL/SQL: Statement ignored
1887/16 PLS-00201: identifier 'C_TAX_EXEMPT' must be declared
1892/13 PL/SQL: SQL Statement ignored
1892/19 PLS-00201: identifier 'C_TAX_EXEMPT' must be declared
1894/16 PLS-00201: identifier 'E_RESOURCE_BUSY' must be declared
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms