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

MOSC Banner

13783723:R12.AP.B : AP Rel 12.1 : Invalid objects after patch applied

edited Sep 3, 2012 6:38PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered ✓

(Created on behalf of Customer)


Below objects have become invalid after applying the patch 13783723:R12.AP.B

   SQL> select OBJECT_NAME,OBJECT_TYPE,OWNER,LAST_DDL_TIME from dba_objects where status ='INVALID' ;

   OBJECT_NAME                                OBJECT_TYPE     OWNER  LAST_DDL_TIME
   ------------------------------ ------------------------------ ------------------------- ---------------
   PSA_AP_BC_PVT                            PACKAGE BODY APPS      29-AUG-12
   XLA_00200_AAD_S_000012_PKG PACKAGE BODY APPS      29-AUG-12
   AP_ACCTG_DATA_FIX_PKG           PACKAGE BODY APPS      29-AUG-12

   SQL> alter package apps.PSA_AP_BC_PVT compile body;
        Warning: Package Body altered with compilation errors.

   SQL> show err
        Errors for PACKAGE BODY APPS.PSA_AP_BC_PVT:

   LINE/COL ERROR

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