Patch Application Error: After applying FIN_PF.G, Getting Compilation Error on ARP_STAX_<Org_id> Package

(Doc ID 369009.1)

Last updated on SEPTEMBER 25, 2017

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