Type 3 Ledger Load Fails with 'ORA-01400: Cannot Insert NULL into LEDGER_STAT for Custom Dimension (Doc ID 2044946.1)

Last updated on AUGUST 20, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run a Type 3 Ledger Load (fn_ledgerDataLoader), the data is not loaded and the following error exists in FSI_MESSAGE_LOG:

"WRAPPER_LEDGER_STAT_LOAD- Error: -1400: ORA-01400: cannot insert NULL into ("<atomic>"."LEDGER_STAT"."TRANSACTION_ID")"

The errors occur on the custom / user defined dimensions.

You confirmed these dimensions exist on STG_GL_DATA, STG_GL_DATA_V, and LS_LOAD_TABLE_GTT_V.  However, the error still occurs.

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