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:
Oracle Financial Services Customer Screening - Version 8.0.8.1.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |