Same Business Unit Appearing Multiple Times On Receipt By Location (Doc ID 2243281.1)

Last updated on MARCH 27, 2017

Applies to:

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

Symptoms

Same Business Unit appearing multiple times on Receipt By Location

Go to below Navigation
Main Menu> Purchasing> Receipts> Review Receipt Information> Receipts by Location


Click on the Business Unit Prompt
Same Business Unit is appearing multiple times

The prompt behind Business Unit on Receipts by Location page is built on a view SP_BUINRV_CLSVW, that is a distinct join of business unit from PS_RECV_HDR with PS_SEC_BU_CLS(Security-> Unit by permission list). If multiple permission list are associated to a BU, Business Unit appears multiple times on the prompt.
For Example, CH001 is tied to below permission lists, that is, CH001 will appear 7 times on the prompt list.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Turn on Security for Permission list by Unit
2. Add your permission and business unit
3. Run apply security updates
4. Go to receipts by location and click on mag glass by business unit field.

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