Object Registration Fails With 'ORA-00001: unique constraint (PK_REV_TAB_REF_CONSTRAINTS) violated' and Several Tables Have Duplicate FKs
(Doc ID 2770629.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 and laterOracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
After merging a new data model with your custom data model, you get the following error during the Object Registration step of the Model Upload process:
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00001: unique constraint (<ATOMIC SCHEMA>.PK_REV_TAB_REF_CONSTRAINTS) violated
After investigating, there are one or two tables getting duplicate foreign key constraints assigned to them.
Example:
TABLE - FOREIGN KEY CONSTRAINT - PARENT TABLE
FCT_TRANSACTION_SUMMARY - FK_1972_5 - DIM_CUSTOMER
FCT_TRANSACTION_SUMMARY - FK_1972_5 - DIM_CUSTOMER
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE
These duplicates prevent you from completing the Object Registration.
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 |