Patch Application Error: After applying FIN_PF.G, Getting Compilation Error on ARP_STAX_<Org_id> Package
(Doc ID 369009.1)
Last updated on AUGUST 10, 2020
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |