Define Business Unit Item Supplier Lookup Performance with VNDR_SET_INV_VW

(Doc ID 2184727.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 and later
Information in this document applies to any platform.


Supplier lookup on "Define Business Unit Item" page is very slow because of (VNDR_SET_INV_VW) SQL coding.

Steps to reproduce the issue:
) Navigate to Main Menu > Items > Define Items and Attributes > Define Business Unit Item
2) Enter Business Unit field
3) Enter Item ID field
4) Click the Search button at the bottom left of the page
5) Click the magnifying glass next to the supplier ID field at the bottom right of the page.
6) Wait 2 minutes to have pagelet display
7) Done


Not applicable. 


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