My Oracle Support Banner

Unique Constraint Error while executing the data load task BD_EVENT_ENTITY_MAP_ORDER (Doc ID 3035739.1)

Last updated on JULY 22, 2024

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

In this data map BD_EVENT_ENTITY_MAP_ORDER, code is picking based on order internal ID hence same sequence IDs are picking to load it in event entity map. Due to this we are facing subjected error and I modified the code to run the batch.

OOTB code:-
 LEFT OUTER JOIN FCC_ORDER_LOOKUP ON ORDR_arc.ORDR_INTRL_ID=FCC_ORDER_LOOKUP.ORDR_INTRL_ID

Modified code:-

 LEFT OUTER JOIN FCC_ORDER_LOOKUP ON ORDR_arc.ORDR_INTRL_ID=FCC_ORDER_LOOKUP.ORDR_INTRL_ID and ordr_arc.ORDR_PLCMT_DT=FCC_ORDER_LOOKUP.ORDR_PLCMT_DT

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.