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 DECEMBER 10, 2024

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 Based on the Display Decimals Defined for the Data Dictionary Item in P92001

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 for both System and Server Map data sources. It should be turned ON for EnterpriseOne tables residing in SQL, Oracle and DB2/400 databases, (all databases except for Microsoft Access databases). Go to GH9011 > Database Data Sources > Select Data Source System - xx. Find & select any Data Source name e.g. Business Business - Test. Goto Form > Advanced. "Use Decimal Shift" box is checked.

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 Based on the Display Decimals Defined for the Data Dictionary Item in P92001
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.