Calculated Field Sum Function Does Not Honor Currency Rounding Before Adding Values. (Doc ID 1325561.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools Upgrade - Version 8.0 SIA [20405] to 8.1 [21039] [Release V8]
Information in this document applies to any platform.

Symptoms

- 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).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms