R12: Invalid Xla Objects After Upgrade from 11i To R12 - Unable To Compile (Doc ID 1238973.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Purchasing - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Jul-2013***

Symptoms


On R12, Subledger Accounting

When attempting to compile the packages, the following error occurs:

ERROR
-----------------------
SQL> alter package XLA_00200_AAD_S_000008_PKG compile body ;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XLA_00200_AAD_S_000008_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
163694/1 PL/SQL: Statement ignored
163694/4 PLS-00201: identifier 'HEADER_CUR' must be declared
163695/1 PL/SQL: Statement ignored
163695/4 PLS-00201: identifier 'LINE_CUR' must be declared
163697/1 PL/SQL: Statement ignored
163697/2 PLS-00201: identifier 'HEADER_CUR' must be declared
2

163710/1 PL/SQL: Statement ignored
163710/2 PLS-00201: identifier 'LINE_CUR' must be declared

STEPS
-----------------------
SQL> alter package XLA_00200_AAD_S_000008_PKG compile body ;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XLA_00200_AAD_S_000008_PKG:


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