Wednesday, August 5, 2015

AP_ACCTG_DATA_FIX_PKG Package Compilation Fails With Error

Issue:

ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors

SQL> select owner,object_name ,object_type,status from dba_objects where object_name like 'AP%' and status='INVALID';

OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------------------------------------------------------
APPS AP_ACCTG_DATA_FIX_PKG PACKAGE BODY INVALID

After applying GDF patch 11787050:R12.AP.B or any other patch requiring undo accounting, running the script "ap_undo_acctg.sql" throws the below error:

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:

Download 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).

Check if the AP_ACCTG_DATA_FIX_PKG is now valid.

No comments:

Post a Comment