Item Mass Maintenance (IMM) - Find Item Query Form Error ORA-00904: "DISPLAY": Invalid Identifier (Doc ID 2068310.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, User Interface in Test:

Users are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 19549533. They also recently applied the following 2 UI patches:

bug 21771922
MSCITMNT.fmb 120.96.12020000.10
mscimmattr.ldt 120.47.12020000.13

Bug 21561008
mscdsui.odf 120.106.12020000.22
MSCGPRJB.pls 120.98.12020000.13
MSCGPRJS.pls 120.39.12020000.8
MSC_SYSTEM_ITEMS.xdf 120.34.12020000.6

User navigates ASCP/Setup/Item Mass Maintenance - selects Sim Set name, Org radio button, Included radio button - then select Flashlight icon to bring up query form:
Criteria = Item
Condition = Equals
From = %

After they hit Ok they see the following errors:

ORA-00904: "DISPLAY": invalid identifier
FRM-40502: ORACLE ERROR: unable to read list of values

A. Support tried to duplicate in 12.2.4.1 instance and cannot reproduce the issue. However we do not have the one off patches applied. Also there is no history of this error for this form

B. Tkprof trace shows

The following statements encountered a error during parse:

select distinct inventory_item_id hidden, item_name displayed from msc_items where 1=1 and upper(ITEM_NAME) like upper('40305-02') order by display

Error encountered: ORA-00904
--------------------------------------------------------------------------------
select distinct inventory_item_id hidden, item_name displayed from msc_items where 1=1 and upper(ITEM_NAME) like upper('%') order by display

Error encountered: ORA-00904

C raw trace shows same ORA-00904 on same sql

D. FRD log shows

Executing POPULATE_GROUP_WITH_QUERY Built-in:
In Argument 0 - Type: Integer Value: -21
In Argument 1 - Type: String Value: select distinct inventory_item_id hidden, item_name displayed from msc_items where 1=1 and upper(ITEM_NAME) like upper('%') order by display
Out Argument 0 - Type: Number Value: 904

later it shows

Executing COPY Built-in:
In Argument 0 - Type: String Value: Completed app_form.reset_message_level.
In Argument 1 - Type: String Value: global.frd_debug

Executing DBMS_ERROR_CODE Built-in:
Out Argument 0 - Type: Number Value: -904

Executing DBMS_ERROR_TEXT Built-in:
Out Argument 0 - Type: String Value: ORA-00904: "DISPLAY": invalid identifier


Executing DBMS_ERROR_TEXT Built-in:
Out Argument 0 - Type: String Value: ORA-00904: "DISPLAY": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. User navigates ASCP/Setup/Item Mass Maintenance - selects Sim Set name, Org radio button, Included radio button - then select Flashlight icon to bring up query form:
Criteria = Item
Condition = Equals
From = %
2. Select OK and error occurs

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