Order Organizer Query For Status Closed Shows Lost And Offer Expired Results As Well. (Doc ID 1994129.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Inquiry & Status

Order Organizer query for status Closed shows Lost and Offer Expired results as well.

When we query Order Organizer only using the Status field with value Closed, Lost and
Offer Expired quotes also get returned and appear first in the list of orders/quotes returned.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Order Management > Orders, Returns > Order Organizer.
2. Query only the Status field on Order Headers selecting Closed.
3. Execute the query (Find).

Quotes with status Lost and Offer Expired get returned along with Closed orders, and, the
quotes appear first so the user must scroll before seeing the Closed Orders.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Slows down Sales Order Entry and Order Organizer appears to be working incorrectly.

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