Performing calculation in DFF Segments

Objective:

                A calculation need to be performed like Segment1 – Segment2 = Segment3 in DFF. An example of DFF screenshot is given.

The difference between value entered in Loaded Weight Segment and Empty Weight Segment should be defaulted in Net Weight.

Open the DFF in Application Developer > Flexfield > Descriptive > Segments.

 

Click on Segments button. Select Net Weight segment and click on open. In the Validation section choose Default type as SQL Statement and give the following query in Default Value.

select ((:$FLEX$.Loaded_Weight)-(:$FLEX$.Empty_Weight)) from dual