Financial Management - PSFT (MOSC)

MOSC Banner

How to implement prompt filtering in query

For PeopleSoft Financials , PeopleTools 8.58.22        Image 42  

How do you implement the permission list based security at the prompt level? Specifically, when user A is running a query and the prompt is to pick an Account, how is the list filtered to only show accounts with the setid that defined in TableSet Security by Permission Lists.

The view SP_BU_TRD_CLSVW, will filter out the prompts based upon Business Units however there is no logic in the underlying view that filters based upon permission lists.

I've read and re-read the Securing Advanced Queries (oracle.com), but am at a loss at how the it makes the jump to the prompt filtering.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center