My Oracle Support Banner

Ledger Load From STG_GL_DATA Fails with 'ORA-20008: WARNING: 0 Batch records successfully processed' (Doc ID 2461756.1)

Last updated on OCTOBER 19, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.1 and later
Oracle Financial Services Profitability Management - Version 8.0.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.1 and later
Oracle Financial Services Asset Liability Management - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 8.0.x, for the Type 3 Ledger Stat Load program fn_ledgerDataLoader, when attempting to load data from STG_GL_DATA into LEDGER_STAT, the batch fails and the following messages are in FSI_MESSAGE_LOG:

17-OCT-2018 04:05:28 - Start of loop for each combination of DATA_SOURCE and YEAR_S in LS_LOAD_TABLE_GTT_v
17-OCT-2018 04:05:28 - End of loop for each combination of DATA_SOURCE and YEAR_S in LS_LOAD_TABLE_GTT_v
17-OCT-2018 04:05:28 - End of big loop - <>
17-OCT-2018 04:05:28 - BadBatchRows = 0 GoodBatchRows = 0
17-OCT-2018 04:05:28 WARNING: 0 Batch records successfully processed; 0 Batch records NOT processed due to parameter errors (see the FSI_LS_LOAD_BATCH table for specific messages).
WRAPPER_LEDGER_STAT_LOAD- Error: -20008: ORA-20008: WARNING: 0 Batch records successfully processed; 0 Batch records NOT processed due to parameter errors (see the FSI_LS_LOAD_BATCH table for specific messages).


The following exists in the COMMENTS column in FSI_LS_LOAD_BATCH:

Ledger Stat Load Successfully Completed.

Finally, the batch log from $FIC_DB_HOME/log/date contains the following:

Log Message here 1: Wed 17 Oct 2018 04:01:20 PM SAST||INFO||Statement to execute : BEGIN :D := fn_ledgerDataLoader('OFSALMINOF_LEDGER_LOAD_20180331_1','20180331','STG_GL_DATA','CALENDAR_MONTHS','REPLACE','N',null,null); END;
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||INFO||Fetching the return status.
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||INFO||Return value From the Stored Procedure : 0
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||SEVERE||Error code returned : 54
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||INFO||execPackage : return val : 0
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||INFO||After Calling execProc
Log Message here 1: Wed 17 Oct 2018 04:01:59 PM SAST||SEVERE||Stored procedure execution failed

You do not understand why the load failed.

Cause

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
Symptoms
Cause
Solution
References


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