Related Items Not Displaying For Items Having Substitutes-Missing Expression Error

(Doc ID 2247985.1)

Last updated on MARCH 24, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to view the item substitutes, the following error occurs.

ERROR
ORA-00936 Missing Expression


STEPS
1. Via the Order Management Responsibility.
2. Navigate: Orders, Returns > Quick Sales Orders.
3. Bring up a Booked Order.
4. Trying to add a new line. The item on the line has a substitute. When click on related items to view the the substitutes, it displays an Error message--Missing Expression on Quick Sales Order (QSO).

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