3 Replies Latest reply on Nov 22, 2017 2:04 AM by Beauty_and_dBest

    Invalid Apps package

    Beauty_and_dBest

      EBS R12.1.3

      11gR1

      OL6

       

       

      Our developer is doing some testing related Auto-printing of Checks.

      But she encountered invalid package which caused forms to get error below

       

      ORA-04063: package body "APPS.AP_INVOICES_UTILITY_PKG" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AP_INVOICES_UTILITY_PKG"
      ORA-06512: at "APPS.AP_INVOICES_PKG", line 2213

      --------------------------------------------------------------
      FRM-40502: ORACLE error: unable to read list of values.

      image.png

       

      She asked me to recompile invalid objects in our 12.1.3 instance.

      I recompile it using ADADMIN but still it is invalid 

       

      I tried to manually recompile it using below:

       

      SQL>  alter package AP_INVOICES_UTILITY_PKG compile body;

       

      Warning: Package Body altered with compilation errors.

       

      SQL> show errors

      Errors for PACKAGE BODY AP_INVOICES_UTILITY_PKG:

       

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      4019/3   PL/SQL: Statement ignored

      4019/3   PLS-00306: wrong number or types of arguments in call to

               'AP_CHECK_GDF_VALID'

       

      SQL>

       

       

      Please help how to make in valid.

       

       

      Kind regards,

      jc