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

MOSC Banner

R12.1.3 : 2 invalid objects after applying patch 19659562

edited Apr 24, 2015 8:50AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered ✓

hello


We found taht after applying patch 19659562 2 objects became invalid.
SQL> r
  1* select owner,object_name,object_type from dba_objects where status!='VALID'

OWNER      OBJECT_NAME                         OBJECT_TYPE
---------- ----------------------------------- -------------------
APPS       IEM_EMAIL_PROC_PVT                  PACKAGE BODY
APPS       OZF_UTILITY_PVT                     PACKAGE BODY

We tried to compile them with adadmin with no success. Trying to compile them by hand raised this errors.
SQL> alter package IEM_EMAIL_PROC_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY IEM_EMAIL_PROC_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7055/10  PL/SQL: Statement ignored

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