Error 'Return: 936 - ORA-00936: missing expression' on Transaction Management Process SCC_SL_SMSET After Bundle #51/PI11 (Doc ID 2472938.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

After applying CS 9.0 Bundle 51 or 9.2 PI11, the Transaction Management Process (SCC_SL_SMSET) is failing with the following error:

Stmt #: 1723  Error Position: 514  Return: 936 - ORA-00936: missing expression
Failed SQL stmt: INSERT INTO PS_SCC_SLSM1_TMP1 (PROCESS_INSTANCE, SCC_TEMP_ID, EMPLID, SCC_STG_STATUS, SCC_MULT_EMPLIDS) SELECT MAX(CANDS.PROCESS_INSTANCE), MAX(CANDS.SCC_TEMP_ID), MAX(PS_PERSON.EMPLID), MAX('UE'), MAX('N') FROM PS_SCC_SLSM4_TMP1 CANDS, PS_PERSON, PS_SCC_STG_CONSTIT,  PS_NAMES, PS_SCC_STG_NAMES, PS_PERS_NID, PS_SCC_STG_NID WHERE PS_PERSON.EMPLID = PS_NAMES.EMPLID AND PS_SCC_STG_NAMES.SCC_TEMP_ID = CANDS.SCC_TEMP_ID AND PS_SCC_STG_CONSTIT.SCC_TEMP_ID = CANDS.SCC_TEMP_ID AND CANDS.PROCESS_INSTANCE = 6521854 AND  AND  AND PS_PERSON.EMPLID = PS_PERS_NID.EMPLID AND PS_SCC_STG_NID.SCC_TEMP_ID = CANDS.SCC_TEMP_ID AND PS_SCC_STG_CONSTIT.SCC_TEMP_ID = CANDS.SCC_TEMP_ID AND CANDS.PROCESS_INSTANCE = 6521854 AND PS_PERS_NID.NATIONAL_ID = PS_SCC_STG_NID.NATIONAL_ID AND PS_PERS_NID.NATIONAL_ID <> ' ' AND PS_SCC_STG_NID.NATIONAL_ID <> ' ' AND CANDS.PROCESS_INSTANCE = 6521854 AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_SLSM3_TMP1 T3 WHERE T3.PROCESS_INSTANCE = 6521854 AND T3.SCC_TEMP_ID = CANDS.SCC_TEMP_ID ) GROUP BY CANDS.SCC_TEMP_ID , PS_PERSON.EMPLID

Process 6521854 ABENDED at Step SCC_SL_SMSET.DynRule.Step01 (SQL) -- RC = 936

Steps:

1. Navigate to Student Recruiting > Prospect/Admission Data Mgmt > Transaction Management Process.

2. Run the process SCC_SL_SMSET and it will error.

Changes

In Bundle 51, a new process, SCC_SL_SMSET, replaces the older processes SAD_SL_SMP and SCC_SL_SMP for search/match/post transaction processing via component SCC_SL_SMP. SCC_SL_SMSET also replaces jobs SADEIPSL and SCCEIPSL because it also publishes active messages directly. 

Cause

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