Display Decimals Update for Data Item Class QTYINV and Data Dictionary Item QNTY

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.

NOTE: 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

Data Item Class/Data Dictionary Item Supported

QTYINV (Inventory Quantities for Manufacturing/Distribution) is the only data item class that is supported for this type of decimal change. JD Edwards EnterpriseOne has researched and grouped all Quantity data dictionary items used in Inventory, Sales, Purchasing and Manufacturing systems under this data item class.

NOTE: All data dictionary items belonging to the QTYINV data item class must be defined with the same display decimal setting as the QTYINV class. The Data Dictionary application also validates that the display decimals of a data item matches the display decimals of the data item class to which it belongs. However, it does not prevent users from modifying which data dictionary items reside in a particular data item class. For this reason, customers must not exclude or include existing EnterpriseOne data dictionary items from the QTYINV class. If customers choose to do so, this modification will not be supported by the Oracle Support. The customers must research and test how this modification impacts the processing in the Manufacturing and Distribution suite; otherwise they will most likely experience unexpected results and data integrity issues. This change is strongly not recommended.

QNTY is a data item (quantity-per) used in Bill of Materials (BOM) and it is the only data dictionary item identified by EnterpriseOne that can have its display decimals changed in order to provide better accuracy in costing. It must be changed independently of the QTYINV class.

NOTE: The QNTY data dictionary item does not fall into the QTYINV data item class. Therefore, the QNTY data item display decimal does Not have to be the same as all the data dictionary items within the QTYINV Class. The recommendation is the display decimals value of data item QNTY should not be less than the display decimals value of class data item QTYINV and data items belonging to class data itemQTYINV to avoid rounding.

The default display decimal setting is ZERO for the QTYINV data item class (including all data dictionary items residing in the QTYINV class) and data dictionary item QNTY.

Procedures for Updating Display Decimals

Since one Data Dictionary is recommended for All EnterpriseOne environments, changing the display decimals in one environment, e.g. Development also affects other environments such as Production, Prototype, etc.

If data dictionary is implemented by Environment, it must be implemented by Pathcode because data dictionary specs is created per pathcode. For example, if customer has more than one data dictionary data source, the environment(s) that connect to that data source must have its own path code. In scenario where environments share the same path code with each environment having its own data dictionary data source and display decimals is modified in only one environment, inconsistent Display Decimals will display across the environments that share the same pathcode, regardless of the data dictionary associated to each environment.

NOTE: Changing Display Decimals must be done before any data is entered in the system. The EnterpriseOne software does not have a post-data conversion utility except for the data dictionary item QNTY. For suggestions on how to update data entered before applying the display decimals change, review the section at the end of this document on how to identify the affected tables

as well as FAQ - How to Convert Business Data for QTYINV Class Data Items to Reflect Display Decimal Change E1: 40: FAQ - How to Convert Business Data for QTYINV Class Data Items to Reflect Display Decimal Change.[This section is not visible to customers.]

If the display decimals are changed after data has been entered, the data entered before the change will be incorrectly displayed. For example, if the display decimal was changed from 0 to 2, a quantity of 1 entered before the change will now display as .01 (reduced by a factor of 100) unless a data conversion is run to multiply the data by a factor of 100.

As with any Data Dictionary change, updating display decimals will replicate to the Data Dictionary Specs throughout the enterprise; therefore it is recommended that this process be run with no users logged into the EnterpriseOne software and no EnterpriseOne processes running on the server.

Update Display Decimals UBE R9200100

This UBE report can be run in either Proof or Final mode, depending on the value of the processing option. The Proof mode produces a report of the data dictionary changes with NO update to the data dictionary items. Final mode produces a report and updates the data dictionary items with the display decimals change.

On the Processing Option tab|Update Info, enter QTYINV for the Data Item Class and specify a new value for the Data Display Decimals. Note that it is not necessary to change the Display Decimals for QTYINV in the Data Dictionary application.

Verify that the Data Selection is set as follows:

Submit this UBE Locally. After the report finishes, go to the Data Dictionary application (P92001) and verify that the Display Decimals has changed for data item class QTYINV and some of the data dictionary items in this class, such as TRQT, UORG, PQOH, etc. Note that the data dictionary changes have been updated only to the data dictionary master tables and not the Replicated data dictionary specs.

QNTY Decimal Conversion UBE R30QNTY

This UBE report converts data in the following tables : F3002, F3011, F3013, F3105, F3283, F3293, and F3296.

From Data Dictionary Design menu, select Work with Data Dictionary Items and inquire and select data dictionary Alias QNTY. In the Display Decimals control, note down the current value; this value is required for the processing option - Number of display decimals converting FROM.

This UBE report can be run in either Proof or Final mode. The Proof mode produces a report and does not convert the data. Final mode produces a report and also converts the data.

On the Processing Option tab - Process, enter the number of display decimals for converting FROM and converting TO.

Submit UBE Locally.

After the UBE has completed successfully, go to Data Dictionary application (P92001), find and select data dictionary Alias QNTY :-

When running the UBE report Update Display Decimals for Data Item Class (R9200100) to update the Display Decimals in proof mode, Data Dictionary (DD) items may be duplicated on the report. The report is based on the business view V92001C, which is a join between the tables F9200, F9210 and F9203. The multiple rows of the same item are due to the corresponding multiple rows in the F9203 (Data Item Alpha Descriptions). When the decimal update is made, it will be made for each row returned by the business view, but the existence of the multiple rows for the same item will not affect the result.

Deploy Data Dictionary Items Changes

NOTE: If this step is not run, data inconsistency may be observed when entering and viewing data affected by the display decimal change.

After making the display decimal changes, the data dictionary changes MUST be deployed throughout EnterpriseOne before entering data in the applications affected by the display decimal changes. The deployment procedures are described in Deploying Data Dictionary Changes E1: DD: Deploying Data Dictionary Changes.

Verify Data Conversion and Default value for QNTY

Fastpath P30200. Inquire on a BOM item and the grid column Quantity should display the data correctly with the appropriate decimals.

Fastpath P3002, select a BOM item, add a test record in the grid, do not populate Quantity, arrow down to next grid row. Quantity should display the data dictionary default value.

How to Identify all EnterpriseOne Tables Affected by Display Decimals Update of QTYINV Class

There is no conversion report to convert production data for the QTYINV class. The recommendation is to make this data dictionary decimal change prior to entering any data within the EnterpriseOne system. If existing data has been added in the tables, the data entered before the change will be incorrectly displayed. Therefore, the only option is to convert the data in all EnterpriseOne tables containing data items belonging to the QTYINV class outside of EnterpriseOne using the a Database utility.

If data exists within the tables, to facilitate the data conversion after running the Display Decimals Update process in EnterpriseOne, create a report using the Report Design Aid tool to produce a CSV output file that lists all tables which have data dictionary item columns that belong to the QTYINV class. Then use this CSV output file as input to a SQL script to update the tables.

The following are the high-level design specs of this type of report. Viewing the tables F9210 and F98711 in the Universal Table Browser (UTB) will help in understanding the design of the report.

NOTE: Advanced knowledge of the EnterpriseOne Development Tools including Business View Design and Report Design is a prerequisite in creating this type of report.

NOTE:

As always, when modifying data outside of EnterpriseOne, it is Strongly advised to take a back-up of the data prior to the modification.
The creation of this type of custom report and conversion of the data is not supported by Oracle Software Support.

Known Issues

Issue 1: Users experience issues in Production environment intermittently when some data items in the QTYINV class have zero display decimals instead of non-zero display decimals, due to users signed into both Pristine and Production environments sharing the same call object kernel.

Resolution : Review Document 1903385.1 E1: DD: System Getting Display Decimals Settings of QTYINV Class Data Items from Pristine Data Dictionary Resulting in Incorrect Quantity and Amount Values.