ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
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
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.