My Oracle Support Banner

RUN DQ RULE Task Fails With PLS-00306: wrong number or types of arguments in call to 'FN_DT_DQ_ENGINE' (Doc ID 2861532.1)

Last updated on AUGUST 15, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.5.0 and later
Oracle Financial Services Profitability Management - Version 8.0.7.4.0 to 8.0.7.4.0 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7.4.0 and later
Oracle Financial Services Data Foundation - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When running a batch, the Data Quality Rule 'RUN DQ RULE' Task fails.  The error below exists in the <INFODOM>_<BATCH NAME>_<MIS DATE>_x_Taskx_execution.log from /<FTPSHARE>/logs/20220331/<INFODOM>/RUN DQ RULE:

[01-04-22 17:32:43,049 GMT PM] [INFO ] [BACKEND] [<OFSAA USER>] [RUN DQ RULE] [DQRuleExecutionHelper]Statement to execute : BEGIN :D := FN_DT_DQ_ENGINE('<INFODOM>_<BATCH NAME>_<MIS DATE>_x', '20220331', '<TABLE_NAME>',80, '<OFSAA USER>', '<INFODOM>', 'null', 'Y', 'N', 'NULL', '-1', NULL); END;
[01-04-22 17:32:43,054 GMT PM] [INFO ] [BACKEND] [<OFSAA USER>] [RUN DQ RULE] [DQRuleExecutionHelper]2. Exception occurred is ORA-06550: line 1, column 14:
PLS-00306: wrong number or types of arguments in call to 'FN_DT_DQ_ENGINE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

As a result of this issue, you cannot complete the Batch.

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


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