Error When Trying To Filter In The Open Line Items In The Accounts Tab

(Doc ID 1234335.1)

Last updated on APRIL 03, 2015

Applies to:

Oracle Advanced Collections - Version 12 and later
Information in this document applies to any platform.

Symptoms

Attempting to filter in the Open Line Items in the Accounts tab and receive the following error:

One of the error messages is -

ORA-00932: inconsistent datatypes: expected DATE got NUMBER
ORA-06512: at "APPS.JTF_GRIDDB", line 837


ERROR
-----------------------
APP JTF 210604 Program error. Please inform your system administrator or support representative that:
jtf_grid.populate package reports error:
An unexpected error occured in jtf_grid.populate


grid: <IEX_OPEN_LINES_BEAN.GRID>
datasource: <IEX_OPEN_LINES>

The following information is available:

<null>

The error is most likely in the form or the metadata definition. Please check the following alert for the error code.

ORA-00932: inconsistent datatypes: expected DATE got NUMBER
ORA-06512: at "APPS.JTF_GRIDDB", line 837

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