Calculated Field Sum Function Does Not Honor Currency Rounding Before Adding Values.
Last updated on MARCH 02, 2017
Applies to:Siebel Tools Upgrade - Version 8.0 SIA  to 8.1  [Release V8]
Information in this document applies to any platform.
- SUM all the lines on an Order for the total.
- However, when the line totals use a calculated field and have a discount of a value like 12.5% then the calculated field for the line total has a value $76.125.
- Field should be $76.13. This field is setup as DTYPE_CURRENCY. So when we have two lines on the Order like this then each line will be displayed on the applet as $76.13 (correct),
- However the calculated field which uses the SUM function for the Order Total will be $152.25 vs $152.26. (Off by 1 cent).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms