CS Batch: CUST Like Tables Are Not Compatible With FCC_ZCS_ Like Tables (Doc ID 2867494.1)

Last updated on JUNE 27, 2023

Applies to:

Symptoms

Having customer name greater than 150 character and while running the Customer Screening Batch the process is failing for all the customers whose full name is longer than 150 characters.

Steps to reproduce:
Step1: Login to CS Application
Step2: Run the CS batch with the customer names having greater than 150 Charecters
Step3: Check the fcc_dm_error_details table

Expected result: CS alerts should be created for the names which has greater than 150 Charecters

Actual result: Getting error in fcc_dm_error_details table below

Error in fcc_dm_error_details table:
ORA-00001: unique constraint (OFSAAFCCM.PK_477) violated
ORA-12899: value too large for column "OFSAAFCCM"."FCC_ZCS_CUST"."FULL_NM" (actual: 162, maximum: 150)
ORA-00001: unique constraint (OFSAAFCCM.ZCS_AD_SEQID_IDX) violated
ORA-00001: unique constraint (OFSAAFCCM.ZCS_DOC_SEQID_IDX) violated
ORA-12899: value too large for column "OFSAAFCCM"."FCC_ZCS_CUST"."FULL_NM" (actual: 162, maximum: 150)
ORA-12899: value too large for column "OFSAAFCCM"."FCC_ZCS_CUST"."FULL_NM" (actual: 157, maximum: 150)
ORA-12899: value too large for column "OFSAAFCCM"."FCC_ZCS_CUST"."FULL_NM" (actual: 162, maximum: 150)
ORA-12899: value too large for column "OFSAAFCCM"."FCC_ZCS_CUST"."FULL_NM" (actual: 162, maximum: 150)
ORA-00936: missing expression
ORA-00001: unique constraint (OFSAAFCCM.ZCS_AD_SEQID_IDX) violated

Changes

NA

Cause

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