ALMBI Error ORA-01400: Cannot Insert NULL into ("Owner"."FCT_AGG_CONS_CCY_ALM_MEASURES"."N_CCY_KEY") (Doc ID 1437599.1)

Last updated on MARCH 21, 2012

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version: 5.2.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management Analytics (ALMBI), when running the ALM_BI_TRANSFORMATION (PKG_ALM_BI_TRANSFORMATIONS) batch to move ALM Process data into the ALMBI reporting tables, you get the following error in FSI_MESSAGE_LOG:

Insert Failed from FSI_O_CONSOLIDATED_MASTER to FCT_AGG_CONS_CCY_ALM_MEASURES: SQLCODE:-1400 SQLMSG:ORA-01400: cannot insert NULL into ("<Atomic>"."FCT_AGG_CONS_CCY_ALM_MEASURES"."N_CCY_KEY")

The error prevents data from being inserted into FCT_AGG_CONS_CCY_ALM_MEASURES.

Steps to Reproduce:

1. Go to Operations > Batch Maintenance
2. Create a new Batch
3. Create a new Task in the Batch with the following selected:

Component: TRANSFORM DATA
Rule Name: ALM_BI_TRANSFORMATION

4. Run the batch in Batch Execution

The error above exists in FSI_MESSAGE_LOG.

Cause

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