Procurement - EBS (MOSC)

MOSC Banner

Form Personalisation to restrict Value sets

edited Feb 11, 2015 6:09AM in Procurement - EBS (MOSC)

Hello there,

We have a requirement to only give access to PO Item Category segment value sets 'MHP_PO_CATEGORY_PARENT','MHP_PO_CATEGORY_CHILD' for Purchasing users.

I have done the following form Personalisation.

Action Type: Builtin
Builtin Type: Create Record Group from Query
Argument:
select v.validation_type, v.flex_value_set_name,
l.meaning, v.parent_flex_value_set_id, v.flex_value_set_id
from fnd_flex_value_sets v,
fnd_lookups l,
fnd_flex_validation_tables t
where v.flex_value_set_id = t.flex_value_set_id 
and ((v.validation_type in ('D','I','X','Y')) or

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