XLA Invalids After Upgrade From 11i To Release 12 (Doc ID 1302349.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

APPS XLA_00222_AAD_S_000007_PKG cannot be compiled due to the following errors:

68132/1 PL/SQL: Statement ignored
68132/4 PLS-00201: identifier 'HEADER_CUR' must be declared
68133/1 PL/SQL: Statement ignored
68133/4 PLS-00201: identifier 'LINE_CUR' must be declared
68135/1 PL/SQL: Statement ignored
68135/22 PLS-00201: identifier 'HEADER_CUR' must be declared
68148/1 PL/SQL: Statement ignored
68148/20 PLS-00201: identifier 'LINE_CUR' must be declared
72825/1 PL/SQL: Statement ignored
72825/4 PLS-00201: identifier 'HEADER_CUR' must be declared
72826/1 PL/SQL: Statement ignored


Please note these packages are dynamically created, so the name might differ. The naming is as follows:

XLA_<application_id_<S/C>_<hash_id>_pkg

where applications_id = 222 (receivables)
S/C = if it is a seeded or a custom SLAM
hash_id = this is the product_hash_id, basically it tells us which product_rule_code the package is attached to.  You can also run this query:

Select PRODUCT_RULE_CODE,
           PRODUCT_RULE_HASH_ID
from xla_product_rules_b
where application_id = <application_id>;

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