Define Business Unit Item Supplier Lookup Performance with VNDR_SET_INV_VW
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
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