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
