Poor Performance When First Accessing Information Discovery Open Orders Page
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, 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.
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