Custom SCD fails with ORA-00927: Missing Equal Sign (Doc ID 2792913.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Symptoms

Customer facing ORA Error while configuring User Defined (Custom) SCDs.

Error in SCD task logs:

Merge Query for SCD processing is : MERGE /*+enable_parallel_dml append parallel(8)*/ INTO DIM_PARTY USING (SELECT DECODE(S.SCD_ROW_TYPE_ID,1,NULL,M.ROW_ID) ROW_ID,M.V_PARTY_ID ,M.SCD_ROW_TYPE_ID FROM (SELECT /*+parallel(8)*/ DIM_PARTY.ROWID ROW_ID,STG_PARTY_MASTER_MANUAL.V_PARTY_ID,CASE WHEN (DIM_PARTY.ROWID IS NULL) THEN 1 END AS SCD_ROW_TYPE_ID FROM STG_PARTY_MASTER_MANUAL LEFT JOIN DIM_PARTY ON (DIM_PARTY.V_PARTY_ID = STG_PARTY_MASTER_MANUAL.V_PARTY_ID ))M JOIN (SELECT 1 AS SCD_ROW_TYPE_ID FROM DUAL UNION ALL SELECT 2 AS SCD_ROW_TYPE_ID FROM DUAL UNION ALL SELECT 3 AS SCD_ROW_TYPE_ID FROM DUAL) S ON(S.SCD_ROW_TYPE_ID=M.SCD_ROW_TYPE_ID or (M.SCD_ROW_TYPE_ID=2 AND S.SCD_ROW_TYPE_ID=1)))B ON(DIM_PARTY.ROWID = B.ROW_ID) WHEN MATCHED THEN UPDATE SET WHEN NOT MATCHED THEN INSERT (V_PARTY_ID ) VALUES ( B.V_PARTY_ID)

Error Msg :-> ORA-00927: missing equal sign

Steps to Reproduce :

1) Login to OFSAA COnfig schema.

2) Create a new SCD with source stage table and the target dimension in SYS_TBL_MASTER

3) Create the source column mappings to target columns in SYS_STG_JOIN_MASTER table.

4) Execute SCD in batch.

Cause

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