Payables and Cash Management - EBS (MOSC)

MOSC Banner

11.5.10 AP Invoice Approval AME how to filled REQUESTER_ID field

edited Mar 21, 2014 12:00PM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

Hello Oracle

I would like to ask you if you can help me how to assign automatically the value

REQUESTER_ID

I have the following personalization but is not working

Trigger = WHEN-VALIDATE-RECORD

Trigger Object = INV_SUM_FOLDER

Condition

:INV_SUM_FOLDER.REQUESTER_ID is null

OR

:INV_SUM_FOLDER.REQUESTER_NAME is null

Actions

Property

item

Target Object : INV_SUM_FOLDER.REQUESTER_NAME

Property Name VALUE

Value

=select full_name from per_all_people_f

where person_id = (select employee_id from FND_USER

where user_id = :INV_SUM_FOLDER.CREATED_BY)

and sysdate between effective_start_date and effective_end_date

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