My Oracle Support Banner

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 11.13.20.10.0 and later
Oracle Fusion Self Service Procurement - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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