My Oracle Support Banner

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

Last updated on SEPTEMBER 22, 2022

Applies to:

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


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.


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

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