ALMBI Transformation Error Insert Failed For FCT_AGG_BASE_CCY_CASHFLOWS ORA-00904: "DIM_ALM_COA_B"."F_LATEST_RECORD_INDICATOR"
(Doc ID 3023918.1)
Last updated on MAY 28, 2024
Applies to:
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.1.0.0.0 and laterOracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Symptoms
On ALMBI 8.1.2.2, when running the ALMBI Transformation, the following error is thrown: Insert failed for FCT_AGG_BASE_CCY_CASHFLOWS ORA-00904: "DIM_ALM_COA_B"."F_LATEST_RECORD_INDICATOR" .
Executed the given script and found attached error in FSI_MESSAGE_LOG.
ERROR
PROCESS_ID SEQUENCES MSG_TIMESTAMP MESSAGE_CD MSG_SEVERITY_CD BATCH_RUN_ID CONTEXT_SPECIFIC_TEXT
10603485 5 09-MAY-24 1019 20 INFODOM_TRANSFORMALMRESULT_20230430_3 Error Occured while Inserting data into PRC_LOAD_RES_CONS_DTL for CF Results Insert failed for FCT_AGG_BASE_CCY_CASHFLOWS ORA-00904: "DIM_ALM_COA_B"."F_LATEST_RECORD_INDICATOR": invalid identifier
"F_LATEST_RECORD_INDICATOR" column does not exist in DIM_ALM_COA_B table.
The issue can be reproduced at will with the following steps:
1.Run ALMBI Transformation from SQL*Developer:
set serveroutput on
DECLARE num number;
Begin num := FN_ALM_BI_TRANSFORMATION('INFODOM_TRANSFORMALMRESULT_20230430_3','20230430','10603485','Y','N');
END;
2. Check errors
Changes
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 |
| Changes |
| Cause |
| Solution |