My Oracle Support Banner

Unable to execute batches after applying OFSAAI Patch (Doc ID 2592969.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.


On : 8.0.7 version, Administration_OFSS

When attempting to execute run from Process Modeller screen, the run execution fails due to below error


Tue 03 Sep 2019 08:35:52 PM GMT PM +0000][INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : DT_ABC,'1567542949688_33712407_20190430_1','20190430','3'
[Tue 03 Sep 2019 08:35:52 PM GMT PM +0000][INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := DT_ABC('1567542949688_33712407_20190430_1','20190430','3'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'DT_ABC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

[Tue 03 Sep 2019 08:35:52 PM GMT PM +0000][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Could not Execute
[Tue 03 Sep 2019 08:35:52 PM GMT PM +0000][INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[Tue 03 Sep 2019 08:35:52 PM GMT PM +0000][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed

The issue can be reproduced at will with the following steps:
1.upgrade OFSAAI to 8072 and try to execute RUN from Process Modeller screen.

Process Modeller >> Execute Run

The issue has the following business impact:
Due to this issue, users cannot execute runs.




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

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