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 188.8.131.52.0 to 184.108.40.206.3 [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