My Oracle Support Banner

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

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.