ORA-00600 15456 AP_WEB_CUST_DFLEX_PKG PLS-00907 APPS.AP_WEB_DB_EXPTEMPLATE_PKG

Sat Sep  2 16:14:26 2006
Errors in file /u01/app/oracle/admin/OSID/udump/osid_ora_12302.trc:
ORA-00600: internal error code, arguments: [15456], [AP_WEB_CUST_DFLEX_PKG], [9]
, [5], [describe phase fails], [], [], []
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit APPS.AP_WEB_DB_EXPTEMPLATE_PKG (referenced by APPS.AP_WEB_DFLEX_PKG)
Sat Sep  2 16:14:26 2006


RESEARCH:
-------------------------- 



Start time for file is: Sat Sep 02 2006 16:14:20

package /u02/app/applmgr/11.5/ap/11.5.0/patch/115/sql/apwdfcfs.pls

Line 23: Changed as follows:
-------------------------------------------------------------
CREATE OR REPLACE PACKAGE AP_WEB_CUST_DFLEX_PKG AS
-------------------------------------------------------------
CREATE OR REPLACE PACKAGE AP_WEB_CUST_DFLEX_PKG AUTHID CURRENT_USER AS
-------------------------------------------------------------


AD Worker error:
ORA-00600: internal error code, arguments: [15456], [AP_WEB_CUST_DFLEX_PKG], [9], [5], [describe phase fails], [], [], []
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit APPS.AP_WEB_DB_EXPTEMPLATE_PKG (referenced by APPS.AP_WEB_DFLEX_PKG)

Failed to execute statement. Statement is

CREATE OR REPLACE PACKAGE AP_WEB_CUST_DFLEX_PKG AUTHID CURRENT_USER AS ...

AD Worker error:
ORA-00600: internal error code, arguments: [15456], [AP_WEB_CUST_DFLEX_PKG], [9], [5], [describe phase fails], [], [], []
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit APPS.AP_WEB_DB_EXPTEMPLATE_PKG (referenced by APPS.AP_WEB_DFLEX_PKG)
Unable to process file in PACKAGE mode.

Converting file for Invoker's Rights.
  Source file: /u02/app/applmgr/11.5/ap/11.5.0/patch/115/sql/apwdfcfs.pls
  Dest   file: /u02/app/applmgr/11.5/admin/OSID/out/p011invok.sql


Line 23: Changed as follows:
-------------------------------------------------------------
CREATE OR REPLACE PACKAGE AP_WEB_CUST_DFLEX_PKG AS
-------------------------------------------------------------
CREATE OR REPLACE PACKAGE AP_WEB_CUST_DFLEX_PKG AUTHID CURRENT_USER AS
-------------------------------------------------------------


sqlplus -s APPS/***** @/u02/app/applmgr/11.5/admin/OSID/out/p011invok.sql

Warning: Package created with compilation errors.


Commit complete.



Time when worker completed job: Sat Sep 02 2006 16:14:31


CONCLUSION:

On the second pass adworker was able to compile the PKG with "with compilation errors."
we'll have to check if the PKG compiles after the patch is completed.

ORA-600 [15456] is a NON CORRUPTIVE, process failure error raised by PL/SQL COMPILER
the operation should be retried again.

Here's the STATUS after the patch was done:

07:30:27 SYSTEM@OSID:gen3> alter package apps.AP_WEB_CUST_DFLEX_PKG compile
07:30:30   2  ;

Package altered.

07:30:49 SYSTEM@OSID:gen3> alter package apps.AP_WEB_CUST_DFLEX_PKG compile body;

Package body altered.

Closing the issue.