Row Level Security per Business Unit Does Not Apply to Prompt Views Starting With SP_BUNVM_ (Doc ID 2019801.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

You observe that when turning on row level security by Business Unit (navigation: Set Up Financials/Supply Chain, Security, Security Options), a number of pages do not seem to honor the security setting and instead, continue to display all Business Units when doing a Business Unit look up (magnifying glass).

The impacted pages use one of the following search records which include the Business Unit field and use a Prompt table beginning with SP_BUNVM_

IN_PEG_SETUP
IN_PEG_SRCH_WRK
IN_PEG_SRCH_WRK
IN_VMI_ITEMS_VW
IN_VMI_RITM_T
REPL_SETUP_INV
RPL_OPT_INV_REQ
RPL_PRM_INV_REQ
SHIPTO_TBL
TRANSF3_INV_WRK
BCT_XADJ_INV_VW
CUST_SHIPTO_OPT
DS_NETDET_TBL


Changes

 

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