Regional Security Does Not Work With Multiple Supplier Pricing Locations (Doc ID 2579031.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Symptoms

PeopleSoft 9.2 introduces the ability to control what items a requester has access to when searching in eProcurement via a combination of eProcurement role actions, item supplier region and SES item indexes. While this function works well if an item is differentiated between multiple suppliers within Item Supplier by Region, it fails when trying to differentiate between multiple supplier pricing locations.

Currently, if an item has a different supplier pricing location within item region supplier than that defined within the initial row of Purchasing – Item Supplier, then the item does not display at all to requester.  Rather than displaying a different price from the same supplier when the requester perform an item search, it doesn’t display the item at all.

In addition, for requesters whose region is tied to the primary supplier pricing location, they do see the item, but they can also see all of the supplier pricing locations, not just that defined within the item supplier region page. Try selecting those secondary pricing locations and then sourcing the req to PO. It doesn’t override to the primary supplier pricing location defined within item region supplier

Steps to Reproduce the issue:

1.Main Menu > eProcurement > Administer Procurement > Maintain Overall System Options > eProcurement Installation Options
2.Set Catalog Search Type to “Search Engine”
3.Deploy and Schedule Recurring Search Indices for Items
4.Main Menu > PeopleTools > Search Framework > Administration > Deploy Object and Schedule Search Index
5.Main Menu > eProcurement > Administer Procurement > Maintain Business Units > eProcurement Business Unit Options
6.Enable Region Security by ePro Business Unit
7.Main Menu > eProcurement > Administer Procurement > Maintain System Users and Roles > Assign Role Actions to Roles
8.Ensure VIEW_ALL_SUPPLIERS and VIEW_SUPPLIER_UOM ePro Role Actions are assigned to ePro Requester Role
9.Main Menu > SetUp Financials/ Supply Chain > Common Definitions > Location > Region Codes
10.Ensure 3 Procurement Region Codes are in place and active
11.Main Menu > SetUp Financials/ Supply Chain > Product Related > Procurement Options > Purchasing > Ship To Locations
12.Ensure that each Region Code is assigned to an active Ship To Code
13.Main Menu > eProcurement > Administer Procurement > Maintain Procurement Users > Requesters
14.Ensure that you have 3 requesters, one each associated to your 3 ship-to codes
VP1
SHIP TO:US001

WENDYCHO
SHIP TO:US005

PATRICKSANCHEZ
SHIP TO :US015

15.Main Menu > SetUp Financials/ Supply Chain > Common Definitions > User Preferences > Define User Preferences
16.Ensure that all 3 users have the appropriate settings within User Preferences (Each associated to 1 of the three PO BUs- US001, US005, US015) and with Requisition Authorizations
17.Main Menu > Items > Define Item Items and Attributes > Define Item > Purchasing Item Attributes > Item Supplier tab
18.Find an item or configure an item with at least 1 active supplier. For us, this will be item 10003
19.Find an second item or configure an item with multiple active suppliers. For us, this will be item 10000
20.Find a 3rd item or configure an item with an active supplier and multiple pricing locations For us, this will be item 10005
21Main Menu > Items > Define Item Items and Attributes > Item Ship To Locations
22.Ensure that none of the three items have an entry within the Item Ship To Locations page
23.Main Menu > Items > Define Item Items and Attributes > Item Supplier by Region
24.Ensure that the ONLY row within Item Supplier by Region for item 10003 is that associated to the BAY AREA region code. The supplier associated should have the MAIN pricing location selected
25.For item 10000, ensure that only two rows are defined, one for BAY AREA, and one for NEW YORK. Each row to have a different supplier assigned, and both with the supplier location of MAIN associated
26.For item 10005, ensure that only two rows are defined, one for BAY AREA, and one for NEW YORK. Each row will have the SAME supplier assigned, but with a different supplier pricing location for each region. In our case, MAIN will be associated to BAY AREA, and SALES to NEW YORK
27.Main Menu > Items > Define Item Items and Attributes > Define Item > Purchasing Item Attributes > Purchasing Controls tab
28.For all 3 items, ensure the “Available to All Regions” checkbox is unpopulated
29.Main Menu > PeopleTools > Search Framework > Administration > Schedule Search Index
30.Perform a full item sync of EP_PV_MASTERITEMVENDOR_SD
31.Login as VP1
32.Main Menu > eProcurement > Requisition
33.and perform a search for item 10005
34.Click item details link for item 10005 as VP1

Issue-1 Both of the supplier pricing locations for item 10005 are being displayed to the requester. Only the MAIN location, the one defined within item region supplier for item 10005 for Bay AREA should be displayed

35.Login as Wendycho
36.and perform a search for item 10005

Issue 2-

Item is NOT displayed, even though an item supplier/ supplier pricing location relationship for region NEW YORK is defined for item 10005

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.