1. Product Packaging Guide
  2. Creating Pristine Control Tables

Creating Pristine Control Tables

For control table changes to be included on an update CD, the JD Edwards EnterpriseOne Product Packaging Tool requires a pristine copy of the control tables. If the installation includes the PS900 pristine environment, these tables already exist in the JD Edwards EnterpriseOne instance and you can bypass the following task. If the installation does not include the pristine environment, you can create a set of pristine control tables by copying the Control Table tables from Control Tables Local to a new data source: Control Tables - PS900. You perform this process only once.

To create pristine control tables:

  1. On the Deployment Server, sign in to JD Edwards EnterpriseOne in the DEP900 environment.

  2. From menu GH9011, select Batch Versions.

  3. Type R98403 in the Batch Application field and click Find.

  4. On Work With Batch Versions - Available Versions, select version XJDE0501 (Control Tables For Pristine Database), and select Processing Options from the Row menu.

  5. Select the Environment tab and change these processing options:

    • Target Environment (option 1)

      Leave this field blank.

    • Target data source (option 2)

      Enter Control Tables - PS900.

    • Data Load (option 3)

      Enter 2 to copy data to the table.

    • Source data source (option 4)

      Enter Control Tables Local.

  6. Run the version locally.

    The report copies the F9000, F9001, F9002, F0004, F0004D, F0005, F0005D, F9005, F9005D, F9006, F9006D, F91100, F91100D, F91400, F91410, F91420, F91430, F91500, F91510, and F951000 tables from the Control Tables Local data source to Control Tables - PS900.

  7. Verify the results of the report and the creation of the tables.

  8. Quit the Batch Versions application.

  9. From menu GH9011, select Object Configuration Manager.

  10. On Machine Search and Select, select the machine with the System - 900 data source.

  11. For the PS900 environment, add Object Configuration Manager mappings for tables F9000, F9001, F9002, F0004, F0004D, F0005, F0005D, F9005, F9005D, F9006, F9006D, F91100, F91100D, F91400, F91410, F91420, F91430, F91500, F91510, and F951000, and assign these new tables to the Control Tables - PS900 data source.

  12. Activate the new mappings.

  13. Quit Object Configuration Manager.