My Oracle Support Banner

Summary Screen PFSINBRW Query Using Message Date Is Not Working (Doc ID 3011399.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle Banking Payments - Version 14.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.7.0.3.0 version, Production Support

Summary Screen PFSINBRW Query using Message Date is not working

We selected the field "Message Date" in summary screen PFSINBRW and click on Search.
Response is Empty error is coming.

ERROR
-----------------------
Response is Empty.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to PFSINBRW screen.
2. And fill the message date and search.
System throws an error.

ANALYSIS
---------------
From the logs, observed the below error,

[20240311 07:59:07 674]SummaryQuery.doQuery-->DAOException raised=ORA-00932: inconsistent datatypes: expected NUMBER got DATE
[20240311 07:59:07 674]java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)

Same issue has been addressed already and provided the fix in 4.0(Ref. Bug 36235164)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can't able to fetch the records in PFSINBRW screen.

Changes

 Fix :- Summary Screen PFSINBRW Query using Message Date is not working

We selected the field "Message Date" in summary screen PFSINBRW and click on Search.

Response is Empty error is coming.
Components Affected
-------------------
pfdinbrw_rad.xml;

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
Changes
Cause
Solution
References


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