1. Product Packaging Guide
  2. Creating Change Tables

Creating Change Tables

JD Edwards EnterpriseOne Product Packaging requires that a set of tables, called change tables, exist and be mapped to the Control Tables - <environment> data source. A change table is a table that contains the items that have changed between releases or updates. Normally, these tables are generated during the installation process, when you run the environment workbench. If, however, the environment is populated with demo data, these tables will not be generated even though the environment workbench reports that they were created successfully.

Complete this task and the next if you need to create change tables in the mastering environment.

To create change tables:

  1. On the deployment server, sign in to the JDEPLAN environment.

  2. From menu GH9011, select Batch Versions.

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

  4. Select version XJDE0507 (Change Table) and click Copy.

  5. On Version Copy, complete these fields as directed:

    • New Version

    • Version Title

      Type a name for the new version.

      CREATECT

  6. Click OK.

  7. On Batch Version Design, click the Processing Options button on the General tab.

  8. Edit these processing options for CREATECT as directed:

    • Target Environment (option 1)

      Type the name of the mastering environment.

    • Target Data Source (option 2)

      Leave this field blank.

    • Data Load (option 3)

      1: Load Production to create the table without data.

    • Source data source (option 4)

      Control Tables Local

  9. Click OK.

  10. On Batch Version Design, click Run.

  11. On Version Prompting, select Data Selection and click Submit.

  12. On Data Selection, verify that these tables are listed in the right operand for BC OBNM, and add those that are missing:

    • F960004

    • F960005

    • F967611

    • F969000

    • F969001

    • F969002

    • F969005

    • F969006

    • F9691100

    • F9691400

    • F9691410

    • F9691420

    • F9691430

    • F9691500

    • F9691510

    • F9695100

    • F9698710

    • F9698712

    • F9755

    • F9757

    • F9759

    • F9760

    • F98800DN

    • F98800N

    • F98800TN

    • F98810DN

    • F98810N

    • F98811N

    • F98830N

    • F98840N

    • F98845N

  13. Run the version.

    The program creates the change tables in Control Tables - CRP or whichever environment Control Table data source you specified.