'ORA-02291: Integrity Constraint (FK_FCT_FTP_ACCOUNT_SUMMARY_1)' Error Running T2T for ALMBI (Doc ID 1923779.1)

Last updated on SEPTEMBER 08, 2014

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 to 6.1 [Release 6]
Oracle Financial Services Asset Liability Management Analytics - Version 6.1 to 6.1 [Release 6]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When implementing Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1 for the Funds Transfer Pricing (FTP) reports, you get the following error when trying to load data from a FSI_D_<table> instrument table into FCT_FTP_ACCOUNT_SUMMARY using the Database Extract T2T_FCT_FTP_ACCOUNT_<table>:

ORA-02291: integrity constraint (<atomic>.FK_FCT_FTP_ACCOUNT_SUMMARY_1) violated - parent key not found

The error appears in the table FCT_FTP_ACCOUNT_SUMMARY$.

The foreign key constraint FK_FCT_FTP_ACCOUNT_SUMMARY_1 references PK_FCT_COMMON_ACCOUNT_SUMMARY on FCT_COMMON_ACCOUNT_SUMMARY.

The error prevents you from populating data required for the FTP Reports within the ALMBI Dashboards.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms