Performance Issue when Selection Organization In Requisition Creation Form
(Doc ID 2075156.1)
Last updated on JULY 02, 2018
Applies to:Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.
While creating a manual Purchase Order Requisition, selecting the organization is not possible as the list of values times out
The below query has the performance issue
This query is immediate while running on the backend table as it's using the index INV.MTL_SYSTEM_ITEMS_B_U1 but it's running for long on the form because its using the index INV.MTL_SYSTEM_ITEMS_B_N13.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!