Patch Application Error: After applying FIN_PF.G, Getting Compilation Error on ARP_STAX_<Org_id> Package (Doc ID 369009.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.