ORA-04045 errors during recompilation/revalidation of APPS.HXT_HOUR_DEDUCTION_RULES_WHO
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. ***
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
Run ADOP Cleanup phase.
Error is printed in the log.
SOLUTION
1. Run the command below to compile the trigger.
alter trigger APPS.HXT_HOUR_DEDUCTION_RULES_WHO compile;
2. Run the query below and make sure the status is Enabled.
select owner, trigger_name, status
from dba_triggers
where trigger_name = 'HXT_HOUR_DEDUCTION_RULES_WHO';
Expected result:
OWNER TRIGGER_NAME STATUS
---------- ------------------------------ ---------
APPS HXT_HOUR_DEDUCTION_RULES_WHO ENABLED
APPS HXT_HOUR_DEDUCTION_RULES_WHO ENABLED
3. Run the query below and make sure the status is valid.
select owner,object_name, object_type,status
from dba_objects
where object_name = 'HXT_HOUR_DEDUCTION_RULES_WHO';
Expected result:
OWNER OBJECT_NAME OBJECT_TYPE STATUS
----- ------------------------------ ----------- -------
APPS HXT_HOUR_DEDUCTION_RULES_WHO TRIGGER VALID
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.