12.1.3: Invalid FA_MASSADD_CREATE_PKG
Hi :Welcome to the new EBS Patching community.
This thread will address your following question -
After applying set of patches (14273383, 14208483 & 14284509) in non-production, we noticed that one of the objects were became invalid and details are below.
APPS FA_MASSADD_CREATE_PKG PACKAGE BODY
We tried to compile manually and we got following error.
Errors for PACKAGE BODY APPS.FA_MASSADD_CREATE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
602/7 PL/SQL: SQL Statement ignored
608/13 PL/SQL: ORA-00904:
"FA_CACHE_PKG"."FAZCBC_RECORD"."ALLOW_UNALLOCATED_LINES_FLAG":
invalid identifier
608/40 PLS-00302: component 'ALLOW_UNALLOCATED_LINES_FLAG' must be
declared
Please let us know how to validate the object.
This thread will address your following question -
After applying set of patches (14273383, 14208483 & 14284509) in non-production, we noticed that one of the objects were became invalid and details are below.
APPS FA_MASSADD_CREATE_PKG PACKAGE BODY
We tried to compile manually and we got following error.
Errors for PACKAGE BODY APPS.FA_MASSADD_CREATE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
602/7 PL/SQL: SQL Statement ignored
608/13 PL/SQL: ORA-00904:
"FA_CACHE_PKG"."FAZCBC_RECORD"."ALLOW_UNALLOCATED_LINES_FLAG":
invalid identifier
608/40 PLS-00302: component 'ALLOW_UNALLOCATED_LINES_FLAG' must be
declared
Please let us know how to validate the object.
Tagged:
0