My Oracle Support Banner

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.