Skip to Main Content
Return to Navigation

Using the Upgrade Driver Program

The sequence of Application Engine sections that are run by an upgrade driver is maintained in the PS_PTIA_DCAEPGMS table. The Application Engine sections defined in the PS_PTIA_DCAEPGMS table are referred to as root sections.

There are two categories of Upgrade Groups:

Upgrade groups contain one or more Application Engine sections that are ordered within the group by sequence number. The Application Engine program PTIADATACONV is used to execute the MAIN and the DDL data conversion groups.

When data conversion is executed using the PTIADATACONV Application Program, the sequence number is used to determine the “Relative Run Order” of Application Engine sections that reference the same table or tables, but not the “Absolute Run Order” of the upgrade group(s).

This section discusses:

Defining an Upgrade Path

Before you can define data conversion sections, you must define an upgrade path.

To define an upgrade path:

  1. From your browser, sign in to the Demo database.

  2. Select select PeopleTools, then select Lifecycle Tools, then select Upgrades, then select Define Upgrade Paths.

  3. The Define Upgrade Path page appears.

  4. Click theAdd a New Value tab.

  5. Enter a value for Upgrade Path.

  6. Click Add.

  7. Select a value for Active Flag.

  8. Enter description for the new upgrade path.

  9. Click Save.

    Image: Define Upgrade Path page

    This example illustrates the fields and controls on the Define Upgrade Path page.

    Define Upgrade Path page

After you have defined an upgrade path, you can add sections for the upgrade path on the Define Data Conversion page.

Accessing the Define Data Conversion Page

Before you run data conversion, you may need to change what the Upgrade Driver program runs. You can add, remove, or deactivate Application Engine sections through the Define Data Conversion page.

To access the Define Data Conversion page:

  1. From your browser, sign in to the Demo database.

  2. Select select PeopleTools, select Lifecycle Tools, select Upgrades, select Define Data Conversion.

  3. The Define Data Conversion page appears.

  4. Enter your upgrade path.

    For example:

    HC90

    CR90

  5. Click Search.

    The Define Data Conversion page displays information for the selected upgrade path, as shown in the example below. Following the example of the Define Data Conversion page are descriptions for each section of the page.

    Image: Define Data Conversion page

    This example illustrates the fields and controls on the Define Data Conversion page. You can find definitions for the fields and controls later on this page.

    Define Data Conversion page
    Upgrade Path

    This field contains the upgrade path on which the section will be run.

    Program Name

    This is the Application Engine program that contains the section.

    Group Number

    This is the group number. All sections with the same group number will be run during the same run of the PTIA_DATACONV Application Engine program

    Group Level

    This is the group level.

    Conv Type

    This is the conversion type. PTIA supports two categories: MAIN and DDL

    Section

    This is the section that will be called from the PTIA_DATACONV Application Engine program.

    Sequence

    This is the order in which the sections will be called during the run of PTIA_DATACONV for the group number.

    Active Flag

    This field determines whether the section will be run. If the value of this field is Active, the section will be run. If the value is Inactive, it will not be run. If you need to remove a section, change the value in this field to Inactive.

    Short Description

    This field contains the Section description.

    Long Descr

    This field is optional.

This section also discusses:

  • Adding a new Section on the Define Data Conversion Page

  • Inactivating a Section on the Define Data Conversion Page

Adding a new Section on the Define Data Conversion Page

Follow the instructions below to add a new section to the Define Data Conversion page.

Note: To add a new section, the Application Engine program and section must exist on the Demo database.

To add a new section to the Define Data Conversion page:

  1. From your browser, sign in to the Demo database.

  2. Select select PeopleTools, then select Lifecycle Tools, then select Upgrades, then select Define Data Conversion.

  3. The Define Data Conversion page appears.

  4. Enter your upgrade path.

    For example:

    HC90

    CR90

  5. Click Search.

    The Define Data Conversion page displays information for the selected upgrade path.

  6. Add a new row.

  7. Select a value for Program Name.

  8. Enter a value for Group Number.

    Note: Each group number corresponds to a data conversion step in the PeopleSoft Change Assistant template. If you select a group number that already exists in the PS_PTIA_DCAEPGMS table, your section will be executed when PeopleSoft Change Assistant runs the data conversion step that corresponds to the group number you selected. Alternatively, if you assign a group number to your new section that does not already exist in PS_PTIA_DCAEPGMS, you must add a new step to your PeopleSoft Change Assistant template. The new template step will have the same properties as the other data conversion steps, except for the group number specified in the step properties Parameters box.

  9. Enter values for Group Level and Conv Type.

  10. Select a value for Sectionand enter value for Sequence.

  11. Select a value for Active Flag.

  12. The Short Descriptionfield is populated from the Section description. The Long Descrfield is optional.

  13. Click Save.

Inactivating a Section on the Define Data Conversion Page

Follow the instructions below to deactivate a section on the Define Data Conversion page. If a section is deactivated, the section will not run as part of data conversion.

To inactivate a section on the Define Data Conversion page:

  1. From your browser, sign in to the Demo database.

  2. Select select PeopleTools, then select Lifecycle Tools, then select Upgrades, then select Define Data Conversion.

  3. The Define Data Conversion page appears.

  4. Enter your upgrade path.

    For example:

    HC90

    CR90

  5. Click Search.

  6. Find the row with the Program Name and Section you want to remove and change the value of the Active Flag field to Inactive.

  7. Click Save.