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
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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.
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