My Oracle Support Banner

'ORA-01400: Cannot Insert NULL into ("LEDGER_STAT"."ACCUM_TYPE_CD")' Running Ledger Stat Load (Doc ID 1970918.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


In Oracle Financial Services Analytical Applications (OFSAA), you get the following ORA-01400 error in FSI_MESSAGE_LOG when running the program fn_ledgerDataLoader to load LEDGER_STAT using a Type I Ledger Load:

WRAPPER_LEDGER_STAT_LOAD: Starting batch table update/insert
WRAPPER_LEDGER_STAT_LOAD: Batch table updated/inserted with data. Executing ledger load program
WRAPPER_LEDGER_STAT_LOAD- Error: -1400: ORA-01400: cannot insert NULL into ("<atomic user>"."LEDGER_STAT"."ACCUM_TYPE_CD")

As a result, the batch fails to load data into LEDGER_STAT.




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.