ADOP Cleanup Reports ORA-04045: errors during recompilation/revalidation of APPS.HXT_HOUR_DEDUCTION_RULES_WHO
(Doc ID 2099811.1)
Last updated on SEPTEMBER 01, 2024
Applies to:
Oracle Time and Labor - Version 12.2.3 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
ADOP cleanup reports following error at ad.plsql.ad_zd_sys.drop_covered_object.
[EVENT] Calling cleanup in STANDARD mode...
[EVENT] Log: @ADZDSHOWLOG.sql "2016/01/01 01:01:01"
[ERROR] ORA-04045: errors during recompilation/revalidation of APPS.HXT_HOUR_DEDUCTION_RULES_WHO
ORA-04023: Object HXT.HXT_HOUR_DEDUCTION_RULES
[ERROR] Failed to execute SQL statement :
declare
begin
ad_zd_log.message('ad.bin.adop','WARNING','');
exception
when others then
raise_application_error(-20001,'Error while calling ad_zd_log.message(ad.bin.adop,WARNING,).' || sqlerrm);
end;
[ERROR] Error Message :
[ERROR] *** Error occurred while calling ad_zd_log. Please check log file for the details. ***
[EVENT] Log: @ADZDSHOWLOG.sql "2016/01/01 01:01:01"
[ERROR] ORA-04045: errors during recompilation/revalidation of APPS.HXT_HOUR_DEDUCTION_RULES_WHO
ORA-04023: Object HXT.HXT_HOUR_DEDUCTION_RULES
[ERROR] Failed to execute SQL statement :
declare
begin
ad_zd_log.message('ad.bin.adop','WARNING','');
exception
when others then
raise_application_error(-20001,'Error while calling ad_zd_log.message(ad.bin.adop,WARNING,).' || sqlerrm);
end;
[ERROR] Error Message :
[ERROR] *** Error occurred while calling ad_zd_log. Please check log file for the details. ***
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Run ADOP Cleanup phase.
- Error is printed in the log.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |