1. Financial Management Fundamentals Implementation Guide
  2. Understanding Data Selection for the Update Data Relationships Program

Understanding Data Selection for the Update Data Relationships Program

For most JD Edwards EnterpriseOne batch programs, you set data selection and processing options within the same program and program version. For the Update Data Relationships program (R00422), however, you set the processing options in program R00422 and then, if necessary, you set the data selection in one of these programs:

  • Select F0006 Data Relationships (R00422A)

  • Select F5201 Data Relationships (R00422B)

Having two separate programs for data selection enables you to select the appropriate data for the table (F0006 or F5201) that you want to update. You can set up different versions of these programs with different data selection. However, JD Edwards recommends that you do not set data selection unless necessary. Processing all data helps to ensure that data integrity issues do not occur.

Before you run the Update Data Relationships program, determine the columns that you want to update. For columns that do not need to be updated, ensure that:

  • The Enforce Rule flag is not selected for those columns in the Column Relationships program (P00421).

  • The Update processing option in the Update Data Relationships program is set to update default values based on the enforce rule.

When you run the Update Data Relationships program, you use processing options to specify the table to update and the version to run. The Update Data Relationships program runs either the R00422A or the R00422B program, based on the table that you specify in the processing options.

Caution: When you enter the data selection for a version, you should carefully evaluate the records that you want to update. Some records have dependencies on other records and, therefore, should be included in the data selection. If you omit certain records from the data selection, data integrity issues might occur. For example, to avoid data integrity issues, you should enter data selection by company when you update business units to ensure that all business units for the company are updated and not just a select group.