Batch Execution Screen Shows 'ERROR' and Causes the OFSAA Application to Hang / Freeze

(Doc ID 2182594.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

While trying to search in the Operations > Batch Execution screen, you get 'ERROR' on the screen and the application hangs there.

You find the following ORA-01843 error in the RevAppserver.log:

[REVELEUSLOG] Sep 6,16 13:53:26 : [NONE]Writting Cargo ..........[SC:10][ST:1001][SST:0][Oper:0][Version:0][EF:false][D:FICMASTER][S:null][U:null][PT:1001][P:null[[[Ljava.lang.String;@1bbc7f9d, select count(1) from ( select distinct a.v_batch_id c1, a.v_batch_description c2 from BATCH_MASTER a,BATCH_TASK_MASTER b,BATCH_PARAMETER_MASTER c,BATCH_TASK_PRECEDENCE_MASTER d, BATCH_EXECUTION_MAPPING g where a.V_BATCH_ID = b.V_BATCH_ID and a.V_BATCH_ID = c.V_BATCH_ID and a.V_BATCH_ID = d.V_BATCH_ID and b.V_TASK_ID = c.V_TASK_ID and b.V_TASK_ID = d.V_TASK_ID and a.v_src_framework like ? and UPPER(a.v_batch_id) like UPPER(?) escape '~' and to_date(a.V_LAST_MODIFIED_DATE, 'dd mon yyyy HH24:MI:SS') between to_date(?, 'MM/DD/YYYY') and to_date(?, 'MM/DD/YYYY')+1 and a.v_batch_id = g.v_batch_id and g.V_GROUP_CODE IN (select distinct (ugm.v_group_code) from cssms_usr_group_map ugm where ugm.v_usr_id = ?) and UPPER(a.v_batch_description) like UPPER(?) escape '~' order by c1 asc)]]
[REVELEUSLOG] Sep 6,16 13:53:26 : [NONE]Got Cargo back ..........[SC:10][ST:1001][SST:0][Oper:0][Version:0][EF:true][D:FICMASTER][S:null][U:null][PT:1001][P:nullError while Executing Bind variables query :Error Executing Query. Error: ORA-01843: not a valid month]
[REVELEUSLOG] Sep 6,16 13:53:26 : [ICCBATCHEXECUTIONSERVICE]Exception in Batch search method...

The error appears to freeze the application.

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