6 Replies Latest reply on Oct 2, 2015 9:36 PM by Jigga_Drs

    Patch 18681921 : ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors

    Jigga_Drs

      After application of patch 18681921 the error below is experienced when executing @$AP_TOP/patch/115/sql/ap_func_curr_inv_with_base_amt_sel.sql.

       

      ERROR at line 1:

      ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors

      ORA-06508: PL/SQL: could not find program unit being called:

      "APPS.AP_ACCTG_DATA_FIX_PKG"

      ORA-06512: at line 283

      ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors

      ORA-06508: PL/SQL: could not find program unit being called:

      "APPS.AP_ACCTG_DATA_FIX_PKG"


      Show error shows up


      PACKAGE BODY APPS.AP_ACCTG_DATA_FIX_PKG

      On line:  305

      PLS-00323: subprogram or cursor 'UNDO_ACCTG_ENTRIES' is declared in a package specification and must be defined in the package body

       

      Please advise as i had gotten the same error in test and researched and implemented Patch 19586537:R12.AP.B and issue resolved however the same is not happening in our LIVE environment.