EBS Customizations (MOSC)

MOSC Banner

EBS R12.29 - Creation of Roles and Grants for Value Sets

In R12.2.X Oracle has introduced Roles and grants to all value sets. One cannot view any values under a value set, unless a role / grant is assigned to that user.

As you know, we might have many value sets in the system. Is there an easy way to create roles for all the available value sets and assign them to users?

Right now we are creating one role for each set of value sets, i.e., GL COA segments one role, one role for each set of value sets used in a concurrent program etc. This is tedious.

Please let me know if anyone has a better & easy method.

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