Ledger Load 3 GTT Table Creation Procedure Fails With PLS-00306: wrong number or types of arguments in call to 'FN_LEDGER_LOAD_CREATE_GTT' Errors
Last updated on SEPTEMBER 01, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.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)
On OFSAA 8.0.0, when running the Ledger Load 3, GTT table creation function, it is failing with errors in the batch log file:
Log Message here 1: Thu Jul 9 15:05:28 2015||INFO||Parameters : fn_ledger_load_create_gtt,'INFODOME_LEDGER_LOAD_GTT_CREATION_20140331_1','20140331'
Log Message here 1: Thu Jul 9 15:05:28 2015||INFO||Statement to execute : BEGIN :D := fn_ledger_load_create_gtt('INFODOME_LEDGER_LOAD_GTT_CREATION_20140331_1','20140331'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'FN_LEDGER_LOAD_CREATE_GTT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Log Message here 1: Thu Jul 9 15:05:28 2015||SEVERE||Could not Execute
Log Message here 1: Thu Jul 9 15:05:28 2015||INFO||After Calling execProc
Log Message here 1: Thu Jul 9 15:05:28 2015||SEVERE||Stored procedure execution failed
There are no errors in FSI_MESSAGE_LOG table.
The issue can be reproduced at will with the following steps:
1. Run the LEDGER_LOAD_GTT_CREATION batch without edit
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