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

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
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 ODS.MEMBER M,
  ODS.CLAIM_DETAIL CD,
  ODS.CLAIM_HEADER CH,
  ODS.PROVIDER 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 ('ME','MG','MA','MB')

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