PRC:POZ:Dynamically Populating A DFF Default Value On Purchase Requisition Page (Doc ID 2760071.1)

Last updated on AUGUST 12, 2022

Applies to:

Goal

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?

SQL:

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.primary_flag='Y'
and pa.person_id=300000002024193 (Need this value to be dynamically selected)
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.