My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2017

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)


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.


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

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