My Oracle Support Banner

Ora-600 [Kkqsexpandeventgroups:!Hpf] / (Doc ID 1152940.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Symptoms


On production database 10.2.0.4 the following error has been seen to occur, for the SQL detailed below:

ERROR
-------------
ORA-00600: internal error code, arguments: [kkqsExpandEventGroups:!hpf], [], [], [], [], [], [], []
is coming when this SQL statement is executed:


SELECT DISTINCT
  M.MEM_NUM,
  CD.SVC_DT,
  CD.CLM_STATUS_CD STATUS,
  P.PRV_NUM,
  P.PRV_LST_NAM ||' '|| P.PRV_FIRST_NAM PRV_NAM,
  CD.ALWD_AMT,
  CD.CLM_AMT
FROM TSTSCHEMA.TEST1 M,
  TSTSCHEMA.TEST2 CD,
  TSTSCHEMA.TEST3 CH,
  TSTSCHEMA.TEST4 P
WHERE M.MEM_SK = CD.MEM_SK
  AND CD.CLM_HDR_SK = CH.CLM_HDR_SK
  AND P.PRV_SK = CD.PRV_SK
  AND CD.RVRSL_POINTER = 0
  AND CH.FORM_TYP = 'U'
  AND CD.CLM_PD_DT BETWEEN '01-JAN-2009' AND '31-DEC-2009'
  AND CD.PLACE_OF_SVC IN ('1','21')
  AND CD.PRDCT_CATEGORY_CD IN ('AB','BC','CD','DE')

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.