3 Installing JD Edwards EnterpriseOne

Install Oracle's JD Edwards EnterpriseOne 9.2 with all the path codes and environments you require. The Pristine pathcode and data must be installed for the migration process.

Caution: The process assumes that the target data source only has production data in it. The Platform Pack install for Pristine and Development environments loads demo data into the target data sources. Therefore, this process must be run against Production or Prototype environments.This means that JD Edwards EnterpriseOne 9.2 standard data is in control tables but other transaction data comes from the application and technical conversion programs you run in conjunction with the JD Edwards World Software Update.

EnterpriseOne Application Release 9.2 Installation Guide (for the platform and database you will be using for the EnterpriseOne installation)

EnterpriseOne Application Release 9.2 Upgrade Guide (for the platform and database you will be using for the EnterpriseOne installation)

This graphic describes the Update Center Search

Note:

  1. From the JD Edwards Update Center, you must download and then apply the most current Planner Update for JD Edwards EnterpriseOne 9.2.
  2. You need to download and apply the current Migration TC ESU from the JD Edwards Update Center located on My Oracle Support. In the Update Center, your search for this ESU should include the following criteria. Type = Electronic Software Updates Release = 9.2 Description = *World Migration to E1* Once you have completed the search, download the ESU from the Search which has a full description of World Migration to E1 9.2 TC ESU.

Working with the JD Edwards World Test Environment

It is recommended that you set up an alternate (test) JD Edwards World environment to apply the JD Edwards World Software Update against. One method to accomplish this is to restore the production libraries from a full tape backup to a new set of libraries. You need to set up a signon to access this new set of libraries. Also, you need to change the QJDF data area in the new object library to point to the correct libraries.

Dropping SQL Packages

When migrating data with IBM i data sources, the SQL packages must be dropped before running the TC workbench. The IBM i caches the table layout in the SQL package and does not look at what the current table layout is. If the SQL packages are not dropped, errors might occur in tables with changed formats.

To drop SQL packages

  1. Ensure that JD Edwards EnterpriseOne is shut down.
  2. On the IBM i, enter this command:
  3. WRKOBJ OBJ(*ALLUSR/*ALL) OBJTYPE (*SQLPKG)
  4. Select the business data and control table libraries from the list.
  5. Enter 4 next to each of the packages, and then click Enter.
Note: SQL packages beginning with “Q" are IBM packages. Do not delete.

Modifying the Enterprise Server JDE.INI

Before running the Table Conversion Workbench, make sure this entry in the JDE.INI on the server is active.

To modify the Enterprise Server JDE.INI file

  1. From a regular IBM i screen, signed on as JDE, enter WRKLNK and press Enter.
  2. Drill down to the INI directory by using option 5 on each directory:
    1. E920SYS\ini
    2. Then select option 2 for JDE.INI.
    3. Enter SQL Package Library and press F16.
    4. If there is a semicolon in front of this line, remove it: SQL Package Library=2

    Note: When the TC workbench is completed, enter a semicolon at the beginning of this JDE.INI line. This “comments out" the setting in JDE.INI file:

    Testing Long File Names on the IBM i

    To test long file names

    1. Log on to the IBM i as QSECOFR.
    2. On the command line, enter STRSQL. This command starts a SQL session on the IBM i.
    3. Enter this SQL statement: CREATE TABLE QGPL/ (FIELD CHAR (10)) Where is the name of the file. The system is ready if the file is created in the QGPL library. You can ignore the journal setting.
    4. Enter this SQL statement to remove the file that you just created in the QGPL library, DROP TABLE QGPL/

    Note: The remaining steps in this procedure, Steps 5 through 8 below, are only required if Step 3 above fails.

    Creating a Job Queue in JD Edwards EnterpriseOne

    Installer or system administrator

    Sign onto JDEPLAN

    To create the job queue

    Note: The Job Queue name must match an existing IBM i JOBQ.

    1. Go to menu GH9013 and start the Job Queues application (P986130).
    2. On Job Queue Revisions, complete these fields as described below, and then click OK. This graphic describes the Job Queue Revisions form
      • Host = Enter the Enterprise Server name. Job Queue = Enter the Job Queue name. (Ensure that the Queue name matches the batch queue name on the IBM i. All IBM i can use the batch queue QBATCH as their default.) Default Queue = Select this option. Job Queue Status = Enter 01. Queue Type = Enter 02. Maximum Batch Jobs = This number must match the TC throttle for the plan. It must less than or equal to the MAXACT on the IBM i JOBQ entry in QBATCH. Port Number = For release 9.1 the Port Number is 6017. Ignore the “Network Failed" error if it occurs.
    3. Add another queue called I-ACTIVE. This graphic describes the Job Queue Revisions formSet the maximum number of jobs equal to the maximum number of jobs the queue runs (set the queue for IBM i). Batch processes calling other batch processes use this queue; so define it as type JDEdwards, regardless of the platform.

    Creating Temporary Tables for Data Migration

    On the Deployment Server, logged on as user JDE in the JDEPLAN environment

    Release 9.2 fully installed.

    To create temporary tables for data migration

    1. From menu GH9011, select Report Management, Batch Versions.
    2. On the Work With Batch Versions form, enter R98403 as the Batch Application, and click Find.
    3. Highlight version XJDE0039 (“Create system 89 tables for World Migr"), and then click Copy. This graphic describes the Work With Batch Versions form
    4. On the Batch Version - [Version Copy] form, enter CRTTEMPTBL for the New Version field and Create Temporary Migration Tables for the Version Title field. This graphic describes the Batch Versions formChange the Security field to 1 (Medium security), and then click OK.
    5. On the General tab of the Batch Versions - [Batch Version Design] form, select Processing Options. This graphic describes the Batch Versions form
    6. Set processing options 1-12 as follows: This graphic describes the Environment processing optionsThis graphic describes the Environment processing optionsThis graphic describes the Update processing options formThis graphic describes the Licensing processing options form
      1. For the name of the Target Environment, enter DV920.
      2. Leave blank.
      3. Enter 1 to load production data.
      4. Leave blank.
      5. Enter JDEPLAN for the name of the source environment for the database to be copied from.
      6. Enter 1 to create the environment database.
      7. Enter A to re-create existing tables in data sources that allow automatic table creation.
      8. Enter 1 to copy only tables that exist in the source data source.
      9. Leave blank.
      10. Leave blank (Print tab).
      11. Leave blank.
      12. Leave blank.
    7. Click OK to exit the Processing Options window.
    8. On the General tab of the Batch Versions - [Batch Version Design] form, click Run to submit the version.
    9. Select Advanced from the Form Exit. In the Batch Versions - [Advanced Version Prompting] form, select the Override Location.
    10. Click OK to return the Batch Versions - [Version Prompting] form.
    11. Select Submit from the Form Exit. From the Batch Versions - [JD Edwards Data Sources] select the LOCAL data source.
    12. When the Processing Options window reappears, review options 1-12 and ensure that they are correct.
    13. Click OK to exit the Processing Options window.
    14. Select desired Report Destination option and click OK.
    15. Review the PDF carefully to ensure all tables copied over successfully. If errors are encountered, review the JDE.LOG. Contact the Global Support Center for further assistance.