1 Reply Latest reply: Apr 20, 2013 1:19 AM by Hussein Sawwan-Oracle RSS

    Error Applying HR Global driver after 12.1.3 upgrade

    322407
      Hello All

      I upgraded EBS from 12.0.6 to 12.1.3 and now trying to run post install task of applying HR Global driver hrglobal.drv using adpatch and just got error

      BEGIN hr_legislation.install; END;

      *
      ERROR at line 1:
      ORA-04063: package body "APPS.DT_API" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "APPS.DT_API"
      ORA-06512: at "APPS.FF_GLOBALS_F_OVN", line 16
      ORA-04088: error during execution of trigger 'APPS.FF_GLOBALS_F_OVN'
      ORA-06512: at "APPS.FF_DATA_DICT", line 4825
      ORA-06512: at "APPS.FF_DATA_DICT", line 4912
      ORA-06512: at "APPS.HR_LEGISLATION", line 6458
      ORA-06512: at "APPS.HR_LEGISLATION", line 7623
      ORA-06512: at line 1

      I then checked the APPS.DT_API package body and its INVALID, I tried to compile but no luck.


      SQL> alter package dt_api compile body;

      Warning: Package Body altered with compilation errors.

      SQL> show errors;
      Errors for PACKAGE BODY DT_API:

      LINE/COL ERROR
      -------- -----------------------------------------------------------------
      160/5 PL/SQL: Statement ignored
      161/34 PLS-00306: wrong number or types of arguments in call to
      'DATE_TO_CHARDATE'

      1003/5 PL/SQL: Statement ignored
      1005/8 PLS-00306: wrong number or types of arguments in call to
      'DATE_TO_CHARDATE'

      1014/5 PL/SQL: Statement ignored
      1016/8 PLS-00306: wrong number or types of arguments in call to
      'DATE_TO_CHARDATE'

      2800/5 PL/SQL: Statement ignored
      2801/34 PLS-00306: wrong number or types of arguments in call to
      'DATE_TO_CHARDATE'



      Any help?.

      Regards
      Amit