My Oracle Support Banner

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 later
Oracle 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


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