This chapter contains the following topics:
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.
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.| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work With Batch Versions - Available Versions | W98305A | Report Management (GH9111), Batch Versions (P98305) | Work with existing versions of a batch program. |
| Version Prompting | W98305D | Select the version on the Work With Batch Versions - Available Versions form, and then click Select. | Submit a batch version for processing. |
Enter GH9111 in the Fast Path. Double-click Batch Versions.
On the Work With Batch Versions - Available Versions form, enter R9200100 in the Batch Application field and then click Find.
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.
On the Version Prompting form, click Data Selection and then click Submit.
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.If you changed the Data Selection statement, click OK.
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
On the Printer Selection form, click OK to run the batch application.
On each workstation, delete these spec files:
qlbltbl.ddb, qlbltbl.xdb
dddict.ddb, dddict.xdb
ddtext.ddb, ddtext.xdb
To push the display decimal changes out to users, run R92TAM on the server on which the changes were made.
The Data Dictionary Compare report (RD969200NA) compares data dictionary items between two environments or data sources. You can use this report as an audit or validation tool to determine which data items were added, deleted, or changed.
Before an upgrade, you can compare the data items in the Production and Pristine environments. After the upgrade, you can use the report to verify that your modifications were carried forward to the new release.
See ”Data Dictionary Compare Report” in the JD Edwards EnterpriseOne Tools Software Updates Guide.