Performance Issue when Selection Organization In Requisition Creation Form (Doc ID 2075156.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

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.


Cause

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