My Oracle Support Banner

Mismatch In Attribute SRVC_EXPRN_DT Defined In 2 Tables (Doc ID 2954437.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Attribute FCC_CUST_MKT_SERVED_EVNT.SRVC_EXPRN_DT defined as not null
 
However the source, which is CUST_MKT_SERVED_PRCSNG, has attribute SRVC_EXPRN_DT defined as null.
 
Customer does not provide SRVC_EXPRN_DT, so ECM Batch fails when trying to insert into FCC_CUST_MKT_SERVED_EVNT due to SRVC_EXPRN_DT defined to be not null.

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
Cause
Solution
References


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