Type 3 Ledger Load Fails with 'ORA-01400: Cannot Insert NULL into LEDGER_STAT for Custom Dimension
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.
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