Dependent dff in oracle fusion

Dependent dff in oracle fusion

In this post , We are going to discuss about dependent dff in oracle fusion. In DFF , we do create the DFF segments which will shows in the application. Dependent DFF means , the value of second DFF segment will be derived from the selected value in the first DFF segment.If DFF segments values derives from each other , then we do call these DFF as a dependent dff in oracle fusion.

Dependent dff concept comes , when we have attached the value set to the DFF segments and now we want to control the list of of value of that value set from the selected value in the first DFF segment. In oracle fusion , We have the option to control the DFF segment value set values from entered value in other DFF segment. Here below we will define all about Dependent dff in oracle fusion.

Steps to Create the Dependent dff in oracle fusion

Step1:- Go to DFF registrations task as below.

Dependent dff in oracle fusion

Step2:- Here below is our DFF , in Which we have create two segments Customer No & Bill To.

Dependent dff in oracle fusion

In Bill To , We have attached the Value set Customer Site . We want to show the list of value of Customer Site based on the Customer Selected in the DFF segment 'Customer No.'

Dependent dff in oracle fusion

Step 3:-  Now we are going in our Value set registration for the value set 'Customer Site'

Dependent dff in oracle fusion

Dependent dff in oracle fusion

Step 4:- Here below in our Customer Site Value Set registration's . We will use the condition
:{SEGMENT.segment_code} to create the Dependent dff in oracle fusion.




Sample Code : 

hcsu.cust_acct_site_id = hcas.cust_acct_site_id    and hcas.party_site_id = hps.party_site_id    and hps.location_id = hl.location_id    and hcsu.site_use_code = 'BILL_TO'    and hcas.CUST_ACCOUNT_ID = :{SEGMENT.Internal Customer}

Dependent dff in oracle fusion

Dependent dff in oracle fusion

Dependent dff in oracle fusion