Poor Performance When First Accessing Information Discovery Open Orders Page
(Doc ID 1998217.1)
Last updated on NOVEMBER 14, 2019
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Endeca Intregration
Poor performance when first accessing Information Discovery Open Orders page
Endeca Extensions for EBS V5 successfully installed and FullLoad Graph has been run.
The first time a user accesses a page under Information Discovery, it takes two - three
minutes for the page to display...sometimes even get server timeout error. If user refreshes
browser or clicks link to go to Information Discovery the page loads successfully in a couple
During first time access, we see SQL that is running on EBS database that is doing full
tables scan on OE_ORDER_HEADERS_ALL.
Load in a couple of seconds.
Order Information Super User -> Order Information -> Information Discovery -> Open Orders
Order Information Super User -> Order Information -> Information Discovery -> Closed Orders
Order Information Super User -> Order Information -> Information Discovery -> Returns
Poor performance only happens on first time accessing the page for the day, for each user.
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