ORA-00600 [15212] on the Alert Log File using APPS.FND_GLOBAL (Doc ID 1676006.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Select fails with ORA-600 [15212] and ORA-600 [kxspoac: zero bct].

In alert.log:

Wed Apr 02 06:52:07 2014
Errors in file /ybq81/usr6/mtncerpldb/diag/rdbms/mtncerpl/mtncerpl/trace/mtncerpl_ora_19071452.trc  (incident=863954):
ORA-00600: internal error code, arguments: [15212], [0x110A2C7C8], [0], [3712430340], [0x70000013D946088], [0x000000000], [], [], [], [], [], []
Incident details in: /ybq81/usr6/mtncerpldb/diag/rdbms/mtncerpl/mtncerpl/incident/incdir_863954/mtncerpl_ora_19071452_i863954.trc
Wed Apr 02 06:52:50 2014
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /ybq81/usr6/mtncerpldb/diag/rdbms/mtncerpl/mtncerpl/trace/mtncerpl_ora_19071452.trc  (incident=863955):
ORA-00600: internal error code, arguments: [kxspoac: zero bct], [0x110A2C7C8], [], [], [], [], [], [], [], [], [], []
Incident details in: /ybq81/usr6/mtncerpldb/diag/rdbms/mtncerpl/mtncerpl/incident/incdir_863955/mtncerpl_ora_19071452_i863955.trc



Incident file for ORA-600 [15212]:

ORA-00600: internal error code, arguments: [15212], [0x110A2C7C8], [0], [3712430340], [0x70000013D946088], [0x000000000], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=6r3dzarfnfc84) -----
select name
                          from hr_operating_units
                          where organization_id = :v_org_id
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
7000001f9d96700       810  package body APPS.FND_GLOBAL
7000001fad3c968      3944  package body APPS.FND_PROFILE
7000001fad3c968      4125  package body APPS.FND_PROFILE
7000001f9d96700      2218  package body APPS.FND_GLOBAL
7000001f9d96700      2546  package body APPS.FND_GLOBAL
7000001f9d96700      2698  package body APPS.FND_GLOBAL
7000001f9d96700      2636  package body APPS.FND_GLOBAL
7000001f798dbf0         1  anonymous block


Stack trace:

kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM
pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real ssthrdmain main



Incident file for ORA-600 [kxspoac: zero bct]:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
*** MODULE NAME:(e::bes:oracle.apps.icx.security.session.created) 2014-04-02 07:01:10.561
ORA-00600: internal error code, arguments: [kxspoac: zero bct], [0x110A2C7C8], [], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=6r3dzarfnfc84) -----
select name
                          from hr_operating_units
                          where organization_id = :v_org_id
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
7000001f9d96700       810  package body APPS.FND_GLOBAL
7000001fad3c968      3944  package body APPS.FND_PROFILE
7000001fad3c968      4125  package body APPS.FND_PROFILE
7000001f9d96700      2218  package body APPS.FND_GLOBAL
7000001f9d96700      2546  package body APPS.FND_GLOBAL
7000001f9d96700      2698  package body APPS.FND_GLOBAL
7000001fa697cd0       994  package body APPS.FND_SESSION_MANAGEMENT
7000001fa697cd0      1299  package body APPS.FND_SESSION_MANAGEMENT
7000001f9cab648       433  package body APPS.FND_AOLJ_UTIL
70000019ed1f170         1  anonymous block


Stack trace:

kxspoac opibnd0 opibnd opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM
pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino
opiodr opidrv sou2o opimai_real ssthrdmain main start

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms