My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.