My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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


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:


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:




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

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