Procurement - EBS (MOSC)

MOSC Banner

Restrict LOV of values for Requestor in Purchase Requisition form

in Procurement - EBS (MOSC) 2 commentsAnswered ✓

Hi,

I want to Restrict List of Requestors in Purchase Requisition Form based on Ledger/OU. We have multiple company Employees in "People-> Enter and Maintain form" and we segregate their data by adding respective Ledger using "Assignment->Purchase Order Information". I am trying to achieve it using personalization and attaching Record Group Query with Requestor LOV but no success. Any idea?


Personalization:

Builtin Type: Create Record Group from Query

Argument: select hv.full_name , hv.employee_id , hv.employee_num employee_number , pb.name

from per_employees_current_x per , per_business_groups_perf pb ,

per_assignments_f a , hr_employees_current_v hv

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