Order Organizer Query For Status Closed Shows Lost And Offer Expired Results As Well.
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.
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.
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.
The issue has the following business impact:
Slows down Sales Order Entry and Order Organizer appears to be working incorrectly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms