PLS-00306: wrong number or types of arguments in call to 'FN_LEDGERDATALOADER' Errors Running Ledger Load (Doc ID 2064387.1)

Last updated on MARCH 09, 2017

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 Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On OFSAAI 7.3.4.0.0, when attempting to run the Ledger Load through the UI in a batch, the batch fails with the following errors in the RunProc log file in the $FIC_DB_HOME/log/date directory:

ERROR

Log Message here 1: Mon Sep 14 18:31:03 CET 2015||INFO||Login Information Successfully Set
Log Message here 1: Mon Sep 14 18:31:03 CET 2015||INFO||Parameters : fn_ledgerDataLoader,'OFSAUAT_LEDGER_LOAD_20150731_5','20150731'
Log Message here 1: Mon Sep 14 18:31:03 CET 2015||INFO||Statement to execute : BEGIN :D := fn_ledgerDataLoader('OFSAUAT_LEDGER_LOAD_20150731_5','20150731'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'FN_LEDGERDATALOADER'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Log Message here 1: Mon Sep 14 18:31:03 CET 2015||SEVERE||Could not Execute
Log Message here 1: Mon Sep 14 18:31:03 CET 2015||INFO||After Calling execProc
Log Message here 1: Mon Sep 14 18:31:03 CET 2015||SEVERE||Stored procedure execution failed

The Ledger Load Type III runs successfully is launched directly in the database using the ofsa_util.wrapper_ledger_stat_load

If the procedure is run directly in the database, it executes successfully:

DECLARE
 x NUMBER := 0;
BEGIN
 x := ofsa_util.wrapper_ledger_stat_load('LedgerStat_1609_9',
                                         '20150731',
                                         'STG_GL_DATA',
                                         'CALENDAR_MONTHS',
                                         'REPLACE',
                                         'N',
                                         '20150101',
                                         '20151231');
 dbms_output.put_line('The return variable is ' || x);
END;

The issue can be reproduced at will with the following steps:

1. Execute the LEDGER_LOAD batch from Operations -> Batch Execution

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