ORA-20008: WARNING: 0 Batch Records Successfully Process on Ledger Stat Load Type III (Doc ID 1963677.1)

Last updated on MAY 03, 2016

Applies to:

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

Symptoms

On : 7.3.4

When attempting to run Ledger Load Type III the following error occurs in FSI_MESSAGE_LOG.

Error:

CONTEXT_SPECIFIC_TEXT
WRAPPER_LEDGER_STAT_LOAD: Starting batch table update/insert
WRAPPER_LEDGER_STAT_LOAD: Batch table updated/inserted with data. Executing ledger load program
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).


Steps:

1. Ran ledger load process to upload the Drivers's information to the ledger stat, this is where it fails.

SET SERVEROUTPUT ON
DECLARE
x NUMBER :=0;
BEGIN
x :=
ofsa_util.wrapper_ledger_stat_load('batch_id_10','20141211','STG_DRIVER_DATA','CALENDAR_MONTHS','REPLACE','Y','20140701','20140731');
dbms_output.put_line ('The return variable is ' || x);
END;


the no of records in pl sql table finally is 1
Flushing out global temporary table LS_LOAD_TABLE_GTT_V
Data re-inserted to global temporary table LS_LOAD_TABLE_GTT_V
Is_calendar_month is Y. Calling currency update procedure to update data in GTT
Multi currency is enabled. update currency-based fininacial elements to functional currency UPDATE LS_LOAD_TABLE_GTT_V a SET ISOCRNCYCD = 'PEN' WHERE ISOCRNCYCD <> 'PEN' AND EXISTS (SELECT NULL from ofsa_detail_elem WHERE column_property_cd IN (SELECT column_property_cd FROM rev_column_property_dsc WHERE currency_basis_flg = 1) AND leaf_node = a.financ_id) AND NOT EXISTS (SELECT NULL FROM fsi_currencies WHERE iso_currency_cd = a.ISOCRNCYCD AND iso_currency_cd NOT LIKE '00%')
initializing FSI_DATA_IDENTITY
Rows Updated: 0
the value of sequence is 2
The return variable is 0

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