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.


About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also


Updating OS in Oracle RAC

Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post …

Leave a Reply