ALMBI Error ORA-01400: Cannot Insert NULL into ("Owner"."FCT_AGG_CONS_CCY_ALM_MEASURES"."N_CCY_KEY")
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.
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