11.5.10 AP Invoice Approval AME how to filled REQUESTER_ID field
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