Invalid objects after upgrade
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
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:
0