Administering the Data Dictionary

This chapter provides an overview of data dictionary administration and discusses how to update display decimals.

Understanding Data Dictionary Administration

Just as a dictionary contains word definitions, Oracle's JD Edwards EnterpriseOne data dictionary is a central repository that contains data item definitions and attributes. These attributes determine how a data item:

• Appears on reports and forms.

• Validates data entry within an application.

• Assigns column and row descriptions.

• Provides text for field-sensitive help.

The data dictionary is active because changes that you make are automatically reflected in applications without having to recompile the software.

You should assign one or two people to be the data dictionary administrator for each application area in the enterprise. Data dictionary administrators should be experienced with JD Edwards EnterpriseOne and have a comprehensive knowledge of their product area, such as finance or manufacturing. The data dictionary administrator makes all additions, changes, and deletions to data items for the product group. Such changes are reflected in the pristine data dictionary on the enterprise server.

If the setup is similar to the suggested typical customer configuration, then all environments share the same data dictionary. Therefore, the administrator can sign on to any environment to make changes. We recommend that you use the Security Workbench to assign application security on the Data Dictionary application (P92001) to prevent unauthorized users from making data dictionary changes.

Updating Display Decimals in Data Dictionary

Data items that belong to the QTYINV data item class come with the display decimal set at 0 (zero). You can change the display decimal to any number up to 8. For example, if you change the display decimal to 4, instead of seeing 100 you will see 100.0000.

Important! You should change the display decimal value in a CRP environment before any live production data is entered. JD Edwards EnterpriseOne does not have a data conversion feature, so if you change display decimals after users have entered data, the data entered before changing the display decimals will be wrong.

Forms Used to Update Display Decimals

Updating Display Decimals

Enter GH9111 in the Fast Path. Double-click Batch Versions.

1. On the Work With Batch Versions - Available Versions form, enter R9200100 in the Batch Application field and then click Find.

2. Select one of these versions and click Select:

   • Update Display Decimals for Class - Proof

     The proof version produces only a report of what the process would do if run in final mode.

   • Update Display Decimals for Class - Final

     The final version actually makes the changes.

3. On the Version Prompting form, click Data Selection and then click Submit.

4. On the Data Selection form, create this statement:

   If BC Data Item Class (F9210) = QTYINV

   Note. QTYINV is the only data item class for which you can modify display decimals. If you modify other data item classes, you must research and test how the modifications affect the software. Also, if you modify which data items reside in the QTYINV data item class, you must research and test how the modifications affect the software.

5. If you changed the Data Selection statement, click OK.

6. On the Processing Options form, complete these fields and then click OK:

   • Enter 1 to run in Update Mode or 0 to run in Proof Mode. The default is 0.

   • Data Item Class

   • New Data Display Decimals

7. On the Printer Selection form, click OK to run the batch application.

8. On each workstation, delete these spec files:

   qlbltbl.ddb, qlbltbl.xdb
   dddict.ddb, dddict.xdb
   ddtext.ddb, ddtext.xdb

9. To push the display decimal changes out to users, run R92TAM on the server on which the changes were made.