My Oracle Support Banner

OEXOETEL Quick Order Organizer Performance When Query (Doc ID 1358376.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Order Management - Version 12.1.2 and later
Information in this document applies to any platform.
Quick Order Organizer
Performance
Custom Index
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
SHIP_FROM_ORG_ID
SCHEDULE_SHIP_DATE
OEXOETEL


Symptoms

On :  12.1.2 version, Transaction Inquiry & Status

ACTUAL BEHAVIOR  
---------------

Customer is experiencing the same issues after putting a custom index on table OE_ORDER_HEADERS_ALL on column ordered_date as per the <Bug 11897250> - QUICK ORDER ORGANIZER PERFORMANCE ISSUES. It was working fine, but now users are experiencing the the query taking over 15 minutes with the below example of parameters.

Parameters used:
Warehouse
Schedule Ship Date to/From: example 8/4/2011 0:00 to 8/4/2011 23:59


This is a huge impact. Users need to be able to use the order organizer to query orders for a day or using a date range



EXPECTED BEHAVIOR
-----------------------
Expect performance to be less than 5 seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Orders,Returns>Quick Sales Order Organizer
3. Once the orders are shown in the Organizer click on the 'Lines' tab > Users experience a huge lag when switching between Summary and Lines tab on the Quick Order Organizer


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot efficiently use the form.

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.