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

MOSC Banner

Invalid objects after upgrade

edited Jul 10, 2013 6:01PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered
Hi,
Apps 12.1.3

AP_WEB_ARCHIVE_PURGE_ER
AP_CCE_BANK_UPGRADE

Asked to provide the following

select text from dba_source
where name like '%AP_WEB_ARCHIVE_PURGE_ER%'
and line = 2;

run the same for AP_CCE_BANK_UPGRADE as well.

alter package AP_WEB_ARCHIVE_PURGE_ER compile;

alter package AP_CCE_BANK_UPGRADE compile;



If the object compiles with warnings, use either of the following to see the errors that caused the warnings:
- show errors
OR
- select * from user_errors where name = '<OBJECT_NAME>';

If files are not synchronized with object in database please recreate the package using the files from the
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