• Post category:Core HR
  • Post comments:0 Comments
  • Post last modified:February 12, 2021
  • Reading time:3 mins read
You are currently viewing Deriving Values for DFF segments based on other fields
Deriving Values for DFF segments based on other fields

In this article we will look into how to get the LOV values displayed based on other fields for Descriptive Flex Field (DFF) segments.

In the old releases, it wasn’t possible to derive the LOV values based on other contexts for flexfields. However we have option to use other contexts in the where clause for table based Valueset to derive values based on other fields.

We have the Derivation Value defined for some flex fields and we can use only the values that are supported.

For Example let’s consider PER_ASG_DF which is the Assignment DFF and is widely used for adding segments.

Now, when we create a segment for this DFF, we can see the Derivation Value which lists the contexts that can be used in Table based Valueset.

image 42 1024x434 - Deriving Values for DFF segments based on other fields

We can use these contexts in the table based Valueset using the syntax :{PARAMETER.PERSON_ID} and the LOV will get auto-populated with values by passing the context dynamically on the fly.

We can also get the complete list of DFF and supported contexts using the below query.

Query:

select * from FND_DF_PARAMETERS where order by DESCRIPTIVE_FLEXFIELD_CODE

Sample Output:

image 43 - Deriving Values for DFF segments based on other fields