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:

Symptoms

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.

Cause

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