1. Software Updates Guide
  2. Using Table Indices Compare

Using Table Indices Compare

This section discusses how to compare and merge indexes using Table Compare.To compare and merge specifications using Table Compare:

  1. Navigate to Object Management Workbench (OMW) from a JD Edwards Development Client.

  2. Check out the object to be the target. The target object should always be a copy of the object received in an ESU or Applications Update.

  3. Click the OMW Design button, click the Design Tools tab and then click the Table Compare button.

  4. In the Spec Compare Manager, click the Select Source button. The source objects should be the object version that has been customized.

  5. Select the location of the source object under Object Location.

    Source objects can come from the following locations:

    Location

    Fields

    Central Objects

    Path Code

    Select the path code.

    Object Name

    Select the object name.

    Local

    Path Code

    Select the path code.

    OMW Project (Optional)

    Select the OMW Project

    Filters projects for which you are a member. Specifications come from E1Local

    Object Name

    Select the object name.

    Object History

    Path Code

    Select the path code.

    Object Name

    Select the object name.

    Changed Date

    Displays the date the object was last modified.

    Object Release

    Displays the JD Edwards EnterpriseOne application. release.

    Package

    Path Code

    Select the path code.

    Package Name

    Select the name of the full package build.

    Object Name

    Select the object name.

    Development Save

    SAVE Path Code

    Select the path code.

    Save Object Name

    Select the object name.

    file System .par File

    PAR File Name

    Select the file system .par file.

    Value must include the full path and can be a .par or .zip file.

  6. Click the OK button to accept the selection and return to the Spec Compare Manager.

    The selected object version will be extracted from the location and validated. This may take some time depending on the size and location of the object.

  7. Click the Compare button to compare the specifications.

    The Compare Specifications form displays with the source on the left pane and Target on the right pane.

    The Compare Specifications form enables you to compare and merge the specification differences between the two selected objects. You can select source lines and copy them to the target.

    The table definition row is highlighted in blue. The source rows that are different, but protected are in red text. The Source rows with red text, representing indexes and red background, you can copy to the target.

  8. Click the Ok button to save the merged specifications and exit.

Note: Table Compare does not automatically generate the indexes; it only changes the specifications for the table indices. The table indices and associated header files must be generated through the design tools after the Table Compare merge is complete. The index ids may get changed during the merge process and while the tool attempts to maintain the index ids, the same maintenance steps associated with introducing new indices must be implemented to ensure EnterpriseOne functions properly (for example, New header files must be generated, new indices must be generated and any code relying on the changed indices must be modified or re-built to incorporate the index changes). To minimize the number of index id changes, perform all table index merges in a single compare and merge session.