My Oracle Support Banner

EGL9.2.How To Apply Row Level Security by Permission List And BU To PS Queries ? (Doc ID 2916778.1)

Last updated on DECEMBER 20, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


How To Apply Row Level Security by Permission List And BU To PS Queries ?

The following scenario is in place :

1.Apply security Options on Permission list level and Secured Fields BU: Set Up Financials/Supply Chain > Security > Activate Row-level Security.

2.Associate the Permission List EPGL9000 to the BU=US003. Set Up Financials/Supply Chain > Security > Unit Security by Perm List.

3.Make sure that the User GLA1 has the primary permission list EPGL9000 on the User Profile. PeopleTools > Security > User Profiles.

4.Run Apply Security Views. Set Up Financials/Supply Chain > Security>Apply Security Views.

5.Via Application Designer, change the prompt table edit for JRNL_HEADER, JRNL_LINE, and LEDGER to the delivered view SP_BU_GL_CLSVW.

6.Go to  PeopleTools > Security > Query Security > Query Access Manager > Tree Name and create the query.

7.For the permission list EPGL9000, go to PeopleTools > Security > Permission and Roles > Permission Lists > Permission List>Query tab and add the tree name and access group.

8.Try to add a journal for another BU than US003 with user GLA1 and also inquiry on Ledger- not possible, that is correct.General Ledger>Journals>Journal>Add/Update Journal Entries. 

9.Create a query with the record JRNL_HEADER with user GLA1-which only has access to US003. Reporting>Query Manager>Add a new query.

10.When adding BU as prompt, the query returns correctly results only on US003.

11.When no prompt or condition is setup on BU, the query returns data on all Bus – not taking into consideration the restriction on BU which is incorrect.

Check replication document attached.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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