My Oracle Support Banner

Error When Trying To Filter In The Open Line Items In The Accounts Tab (Doc ID 1234335.1)

Last updated on FEBRUARY 08, 2021

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

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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