Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch :13345756 :Linux x86-64:12.1.3:resulted in invalid objects :PA_BUDGET_CORE and PA_BUDGET_CHEC

edited Jan 8, 2013 9:21PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
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;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center