ORA-600 [kkmupsViewDestFro_4] On MERGE (Doc ID 2096662.1)

Last updated on JANUARY 13, 2016

Applies to:

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

Symptoms

ORA-00600[kkmupsViewDestFro_4], [0], [76949] occurs on MERGE statement like:

----- Current SQL Statement for this session (sql_id=b6yanty2pxtaa) -----
MERGE INTO LRM_ALLOC_T ALLOC USING GAPLRMADM.TSGRT_SKU_GRP_RNK_V LRM ON (ALLOC.SKU_STYLE = LPAD(LRM.PRD_NBR,9,0) AND ALLOC.SKU_SIZE = LRM.SZ_CD AND ALLOC.STORE_ID = LRM.STR_NBR AND ALLOC.STATUS IN ('new','roll_over')) WHEN MATCHED THEN UPDATE SET ALLOC.GRP_PRTY_ID = LRM.GRP_PRTY_ID, ALLOC.SKU_PPK_RNK_ID = LRM.SKU_PPK_RNK_ID, ALLOC.LST_UPDT_USR_ID = 'RANKING', LST_UPDT_DTTM = CURRENT_TIMESTAMP, ALLOC.DIVISION = SUBSTR(LRM.MDSE_DIV_CLS_SLS_TXT, 0, 2), ALLOC.MDSE_CORP_ID = LRM.CORP_ID, ALLOC.MDSE_CO_ID = LRM.MDSE_CO_ID, ALLOC.MDSE_DEPT_ID = SUBSTR(LRM.MDSE_DIV_CLS_SLS_TXT, 0, 3), ALLOC.MDSE_CLS_ID = SUBSTR(LRM.MDSE_DIV_CLS_SLS_TXT, 4, 2), ALLOC.MDSE_SCLS_ID = SUBSTR(LRM.MDSE_DIV_CLS_SLS_TXT, 6, 2), ALLOC.MDSE_SEASON_CD = LRM.SEAS_CD

Call stack may include:

kkmupsviewdestfro kkmupd kkmups opiprsdml opiprsdmlcb kkqcttcalo kkqctdrvit apadrv

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