My Oracle Support Banner

"ORA-00904: "N_GAP_MRGN_INT_CASH_FLOW_NET": invalid identifier" While Excecuting FN_ALM_BI_TRANSFORMATION (Doc ID 3034687.1)

Last updated on JULY 26, 2024

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Enterprise Performance Management (EPM)
Maintenance Level (ML)
Data Definition Language (DDL)

Symptoms

On : 8.1.2 version, DATA MODEL

While executing package PKG_ALM_BI_TRANSFORMATIONS you get the following error:

ERROR
-----------------------
Error Occured while Inserting data into FCT_AGG_BASE_IRR_CASHFLOWS for CF Results Insert failed for FCT_AGG_BASE_CCY_IRR_GAP ORA-00904: "N_GAP_MRGN_INT_CASH_FLOW_NET": invalid identifier.

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
References


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