You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Dynamically secure catalog items based on DFF for multiple Countries

in Learning 1 comment

Summary:

Hi Experts,

We need to secure catalog items based on a DFF which contains multiple countries (Around 37 ) where our client operates. I have created the custom SQL predicate which is static in nature (meaning we are passing country field hardcoded) and we need some dynamic retrieving of values of country from the logged in user AOR so that he can see catalog items according to their AOR.

This can reduce our maintenance of 37 data roles .Please suggest some dynamic way or any profile option which can help us in Fusion.

SAMPLE SQL PREDICATE

&TABLE_ALIAS.LEARNING_ITEM_ID IN (SELECT c.learning_item_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!