E1: DD: Data Dictionary Display Decimals versus Currency Decimals (Doc ID 1236703.1)

Last updated on FEBRUARY 24, 2023

Applies to:

Goal

Why are amount fields that are part of the Currency class stored and displayed differently in EnterpriseOne than amount fields that are not part of the Currency class?

For example, in the data dictionary the data item AMTU - Amount User Defined is defined with display decimals = 2.  When checking the data within the table from the database end, the value stored in the table F00092 for this field is 100 times the expected value -  i.e. 168000. When displaying the field in EnterpriseOne, it displays as 1680.00.

There is another data item AEXP - Amount Extended Price whereby the display decimal is also 2. However, the numeric value is displayed as 1556 in the F3460 Forecast File table in EnterpriseOne and stored in the database as 1556.  Why is this numeric value not stored in the database as 155600 and displayed with two decimals?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.