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

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.

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

How to clean FND_NODES table in Oracle Applications

How to clean FND_NODES table in Oracle Applications Note: Remember That All the Latest Cloning …

Leave a Reply