My Oracle Support Banner

MDM - CF_SP Fact Is Failing when multiple languages configured (Doc ID 2694578.1)

Last updated on AUGUST 04, 2020

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 to 2.7.0.1.3 [Release 2.7]
Information in this document applies to any platform.

Goal

The ETL load of the MDM fact CF_SP fails with the error:

ORA-00001: unique constraint (DWADM.XF713S01) violated

The issue occurs when there are multiple languages configured in source(MDM)
application, thereby creating multiple language records in the CI_LOOKUP_VAL_L table.

Steps to Reproduce
1. Ensure that there are multiple languages configured in the source, such that
there are more than one record for every lookup value in the CI_LOOKUP_VAL_L table.
2. Enable the entity and let it run.
3. Notice that the entity fails with the mentioned error.

Solution

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
Goal
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.