My Oracle Support Banner

E1: DD: Display Decimals Update for Data Item Class QTYINV and Data Dictionary Item QNTY (Doc ID 626475.1)

Last updated on NOVEMBER 23, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Purpose

The following explains the functionality of the Display Decimals Update for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).

Display Decimals Definition

Display decimals define how many decimal places are placed to the right of the decimal point when a numeric variable is displayed or used in a calculation. It is defined for numeric data dictionary items and can be set from zero (0) to eight (8).

How Data is Stored and Displayed

How data is stored and displayed is best explained in the screen-print example below for the input number 1.2345.

 

The decimal shifting occurs provided the Decimal Shift flag in the database data source definition is turned ON.
It should be turned ON for EnterpriseOne tables residing in SQL, Oracle and DB2/400 databases, (all databases except for Microsoft Access databases)


This document details how to update the display decimals for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).

Scope

This document is intended for the EnterpriseOne Data Dictionary administrator who will be responsible for making these type of data dictionary display decimal changes.

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
 Display Decimals Definition
 How Data is Stored and Displayed
Scope
Details
 Data Item Class/Data Dictionary Item Supported
 Procedures for Updating Display Decimals
 Update Display Decimals UBE R9200100
 QNTY Decimal Conversion UBE R30QNTY
 Deploy Data Dictionary Items Changes
 Verify Data Conversion and Default value for QNTY
 How to Identify all EnterpriseOne Tables Affected by Display Decimals Update of QTYINV Class
 Known Issues
References

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