Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to get run-time delegated user id in Self service page

edited Jun 9, 2014 7:40AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered ✓

Hi

I have userA who has delegations of UserB. Record in Sysadmin is as below.

UserA Securing Attributes

AttributeApplicationValue
ICX_HR_PERSON_IDOracle iProcurement2030
ICX_HR_PERSON_IDOracle iProcurement2050
TO_PERSON_IDOracle iProcurement2030

I have a query to retrieve registration number in mileage claim as one of DFF. My problem is when userA claim expense for userB , query retrieves userA's registration number. Could someone guide me how I can retreive userB's user_id in order to achive the solution.

Query

SELECT pvrf.registration_number

FROM pqp_vehicle_repository_f pvrf

    ,pqp_vehicle_allocations_f pvaf   

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