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.