ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors

ERROR

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 38

When trying to compile “APPS.AP_ACCTG_DATA_FIX_PKG”, following errors are shown:

AP_ACCTG_DATA_FIX_PKG PLS-00394: wrong number of values in the INTO list of a FETCH statement

 

SOLUTION

STEP 1.

Download and review the readme and pre-requisites for Patch 11772495:R12.AP.B (to fix the package apacpayb.pls) and Patch.12582979:R12.AP.B (to upgrade the version of apgdfalb.pls).

STEP 2.  Ensure that you have taken a backup of your system before applying  the recommended patch. 

STEP 3.  Apply the patch in a test environment. 

STEP 4.  Confirm the following file versions:

ap patch/115/sql apacpayb.pls 120.12.12010000.28
ap patch/115/sql apacpays.pls 120.6.12010000.10 
ap patch/115/sql apgdfalb.pls 120.1.12010000.39 
ap patch/115/sql apgdfals.pls 120.1.12010000.13

Use the Below command like the following: 

strings -a $XX_TOP/filename |grep ‘$Header’ 

STEP 5. Check if the AP_ACCTG_DATA_FIX_PKG is now valid and retest running the script.

STEP 6.  Migrate the solution as appropriate to other environments.