Patch 6678700: 12.1.1 : Upgrade Patch - Causes Invalid CZ Objects.
Hi,
Invalid CZ packages after R12
Problem Description
---------------------------------------------------
Standard Oracle packages such as CZ_BOM_SYNCH, CZ_IMP_SINGLE & CZ_UIOPERATIONS_PUB are invalid in 33u after Rel 12 (R 12.1.3). When DBA team recompiled, it gives the below error.
SQL> alter package CZ_BOM_SYNCH compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY CZ_BOM_SYNCH:
LINE/COL ERROR
-------- -----------------------------------------------------------------
588/26 PL/SQL: Item ignored
588/26 PLS-00201: identifier 'CZ_EXV_APC_PROPERTIES.DATABASE_COLUMN' must be declared
589/26 PL/SQL: Item ignored
589/26 PLS-00201: identifier 'CZ_EXV_APC_PROPERTIES.ATTR_GROUP_ID' must be declared
Invalid CZ packages after R12
Problem Description
---------------------------------------------------
Standard Oracle packages such as CZ_BOM_SYNCH, CZ_IMP_SINGLE & CZ_UIOPERATIONS_PUB are invalid in 33u after Rel 12 (R 12.1.3). When DBA team recompiled, it gives the below error.
SQL> alter package CZ_BOM_SYNCH compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY CZ_BOM_SYNCH:
LINE/COL ERROR
-------- -----------------------------------------------------------------
588/26 PL/SQL: Item ignored
588/26 PLS-00201: identifier 'CZ_EXV_APC_PROPERTIES.DATABASE_COLUMN' must be declared
589/26 PL/SQL: Item ignored
589/26 PLS-00201: identifier 'CZ_EXV_APC_PROPERTIES.ATTR_GROUP_ID' must be declared
Tagged:
0