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