Error 'ORA-00932 : inconsistent data types : expected date got number" Occured While Querying Settlement Invoice on 'Find Settlement' Form (Doc ID 982864.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Financials for India - Version: 12.1.1 - Release: 12.1
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, India PO Localizations

When attempting to query a Settlement Invoice on 'Find Settlement' Form
the following error occurs.

ERROR
-----------------------
ORA-00932 : inconsistent data types : expected date got number

FRM-40735: POST-QUERY trigger raised unhndled exception ORA -00932


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform a Settlement
2. Query the Settlement Invoice on Find Settlement form
3. Error Message pops up.

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