'ORA-02291: Integrity Constraint (FK_FCT_FTP_ACCOUNT_SUMMARY_1)' Error Running T2T for ALMBI
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)
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.
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