Performance Issue when Selection Organization In Requisition Creation Form
Last updated on SEPTEMBER 08, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms