PRC:POZ:Dynamically Populating A DFF Default Value On Purchase Requisition Page
(Doc ID 2760071.1)
Last updated on MARCH 14, 2021
Applies to:Oracle Fusion Self Service Procurement Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Self Service Procurement - Version 11.13.20.01.0 and later
Information in this document applies to any platform.
Dynamically populate a Descriptive FlexField (DFF) default value on Purchase Requisition page
Is it feasible to dynamically update the default value for one of the DFF List of Values (LOV) on purchase requisition page?
Need is to default the value with the cost center associated to the employee who is the assigned requester for the Purchase Requisition (PR) creation.
Currently are able to default it with a constant value based upon the following SQL.
It default the value based upon the person_id.
Is there a way I can dynamically insert the person_id for the employee, selected as the requestor in the requisition preferences?
select gcc.segment4 from per_all_assignments_m pa, gl_code_combinations gcc where gcc.code_combination_id=pa.DEFAULT_CODE_COMB_ID
and pa.person_id=300000002024193 (Need this value to be dynamically selected)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document