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

Dynamically secure catalog items based on DFF for multiple Countries

Question
14
Views
0
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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