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


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.


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

About oracle.solutions

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply

Skip to toolbar