Error Running Data Transformation 'PLS-00306: Wrong Number or Types of Arguments in Call to DT Name' (Doc ID 1999583.1)

Last updated on AUGUST 07, 2017

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)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, a Batch with a data transformation (ex. fn_popDimAccount) fails.  The following error exists in the "RunProc" log file from $FIC_DB_HOME/log/date:

From RunProc_<infodom>_<batch name>_20150309_17_Task3.log:

Log Message here 1: Mon 13 Apr 2015 11:42:05 AM IST||INFO||Parameters : fn_popDimAccount,'<infodom>_<batch name>_20150309_17','20150309'
Log Message here 1: Mon 13 Apr 2015 11:42:05 AM IST||INFO||Statement to execute : BEGIN :D := fn_popDimAccount('<infodom>_<batch name>_20150309_17','20150309'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'FN_POPDIMACCOUNT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Log Message here 1: Mon 13 Apr 2015 11:42:05 AM IST||SEVERE||Could not Execute
Log Message here 1: Mon 13 Apr 2015 11:42:05 AM IST||INFO||After Calling execProc
Log Message here 1: Mon 13 Apr 2015 11:42:05 AM IST||SEVERE||Stored procedure execution failed


As a result of the error, the Batch Task ends in a status of Failed.

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