Cost Balancing Workcenter not Takes in Consideration Primary Permission List
Last updated on MAY 29, 2018
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9.2 and later
Information in this document applies to any platform.
BU Security is set by the Primary Permission List and is not considered by the Cost Balancing WorkCenter.
The Cost Balancing Workcenter Alerts Application Class is equating ROWSECCLASS to OPRCLASS
In the SetSecuritySQL method in the Alerts Application Class code of the SCM_CM_WORKCENTER Application Package, it is setting %RowSecurityPermissionList to OPRCLASS in the SQL where clause. BU Security is turned on in our environment. BU Security is set by the Primary Permission List and not by the Row Security Permission List. In all other areas of FSCM, BU Security SQL looks to the OPRCLASS field on PSOPRDEFN. This workcenter is deviating from the normal Security controls for BU Security.
Steps to Reproduce the Issue:
- User Profile VP1 - Primary Permission list EPINPNLS and Rowsecurity
Permission List ALLPAGES
- Security Options
- BU Security by Permission List EPINPNLS only for BU = US001
- Apply Security Setup
- Navigate to Procurement Operations ¿ Cost Balancing WorkCenter
Note: there are no transaction available for BU = US001
If change to BU = US010 and run apply sevcurity again, also there are no transactions available.
- If remove the security by permission and the transaction are available Note
BU Security is set by the Primary Permission List and is not considered by the Cost Balancing WorkCenter
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