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

MOSC Banner

Trying to Correct All Invalid Objects and AP_WEB_ARCHIVE_PURGE_ER Package Body is Invalid

edited Mar 25, 2013 7:46AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered
Hi,
Object  AP_WEB_ARCHIVE_PURGE_ER is invalid in production(CEN01) and we are in process of making zero invalid.

SQL> select line,text from user_errors where name='AP_WEB_ARCHIVE_PURGE_ER';

    LINE
----------
TEXT
--------------------------------------------------------------------------------
     200
PL/SQL: ORA-00947: not enough values

     200
PL/SQL: SQL Statement ignored


But spec is in valid state when we see from dba_objects and only body is invalid.

Thanks
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