Purchasing Attributes Price Location Lookup Shows Over 300 Duplicate Rows (Doc ID 2228831.1)

Last updated on FEBRUARY 01, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The purchasing attributes price location lookup shows over 300 duplicate rows.


Test Steps:

1. Enter on the item 10000 and go to Purchasing Item Attributes.

Items>Define Items and Attributes>Define Item>Purchase Items Attributes>Item Supplier tab

2. Click on Item Supplier tab, look in Supplier Attributes area, click on Price Loc lookup. Price Location Lookup, see it brings the value MAIN for 300 times, but actually MAIN Supplier Location is only one.

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