Patch :13345756 :Linux x86-64:12.1.3:resulted in invalid objects :PA_BUDGET_CORE and PA_BUDGET_CHEC
Hi,
After applying patch :13345756 , the following objects are invalid.
OBJECT_NAME OBJECT_T OWNER
------------------------------ -------- ----------
PA_BUDGET_CORE PACKAGE APPS
BODY
PA_BUDGET_CHECK_PVT PACKAGE APPS
BODY
while manually compiling these encounters errors are below:
SQL> alter package PA_BUDGET_CORE compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_BUDGET_CORE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
799/7 PL/SQL: SQL Statement ignored
799/45 PL/SQL: ORA-00904: "PA_TRX_IMPORT"."GET_PROJECT_END_DATE":
invalid identifier
799/59 PLS-00302: component 'GET_PROJECT_END_DATE' must be declared
SQL>
SQL>
SQL> alter package PA_BUDGET_CHECK_PVT compile body;
After applying patch :13345756 , the following objects are invalid.
OBJECT_NAME OBJECT_T OWNER
------------------------------ -------- ----------
PA_BUDGET_CORE PACKAGE APPS
BODY
PA_BUDGET_CHECK_PVT PACKAGE APPS
BODY
while manually compiling these encounters errors are below:
SQL> alter package PA_BUDGET_CORE compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_BUDGET_CORE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
799/7 PL/SQL: SQL Statement ignored
799/45 PL/SQL: ORA-00904: "PA_TRX_IMPORT"."GET_PROJECT_END_DATE":
invalid identifier
799/59 PLS-00302: component 'GET_PROJECT_END_DATE' must be declared
SQL>
SQL>
SQL> alter package PA_BUDGET_CHECK_PVT compile body;
Tagged:
0