ALMBI Transformation Fails with 'ORA-02291: Integrity Constraint (FK_T_AGG_BASE_CCY_CASHFLOWS_5) Violated - Parent Key Not Found'
(Doc ID 2011559.1)
Last updated on FEBRUARY 17, 2023
Applies to:Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1, when you run the ALM Results Transformation program, ALM_BI_TRANSFORMATION, from within an ALM batch of processes, results are not getting loaded for a specific ALM Process. In FSI_PROCESS_RUN_HISTORY, BI_TRANSFORM_STATUS is null for the PROCESS_SYS_ID and rows are missing from tables like FCT_AGG_BASE_CCY_CASHFLOWS. The ALMBI Transformation is launched from an ALM Process by selecting the "Move Results to ALM BI Mart" check box on the Output Preferences screen.
If you check FSI_MESSAGE_LOG for the Process, you find the following error message:
select * from FSI_MESSAGE_LOG where process_id = <insert ALM Process ID> order by batch_run_id desc, sequences;
Error Occured while Inserting data into PRC_LOAD_RES_CONS_DTL for CF Results Insert failed for FCT_AGG_BASE_CCY_CASHFLOWS ORA-02291: integrity constraint (<atomic>.FK_T_AGG_BASE_CCY_CASHFLOWS_5) violated - parent key not found
One of the Transformation failed: Program Terminated
The error prevents the ALM_BI_TRANSFORMATION program from inserting rows for the Process.
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