ADOP Cleanup Reports ORA-04045: errors during recompilation/revalidation of APPS.HXT_HOUR_DEDUCTION_RULES_WHO (Doc ID 2099811.1)

Last updated on JUNE 25, 2017

Applies to:

Oracle Time and Labor - Version 12.2.3 and later
Information 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. ***

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Run ADOP Cleanup phase.
  2.  Error is printed in the log.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms