Step 2: Start the Import

To import data from the interface tables, the Run PPM Package Interface report is used.

The Run PPM Package Interface report:

  • Queries the interface tables for active records matching the given selection criteria.

  • Defaults any information that has defaulting rules in Deployment Management but has not been specified in the interface table records.

  • Validates package header data and package line object type information for referential and data integrity. This validation is based on the logic used when entering or updating data through the standard interface. Information in User Data fields and in-line parameters is not validated.

  • Imports packages and package lines passing validation into the standard package tables. Partial imports are not allowed. packages with one or more failed lines will not be imported.

  • Can be used to submit new packages.

  • Reports on the results of the execution, listing both the packages and package lines that passed validation and were imported, and those that failed validation and the specific validation errors they encountered.

To run the Run PPM Package Interface report:

  1. Log on to PPM.

  2. From the menu bar, select Open > Reports > Create Report.

    The Submit New Report page appears.

  3. Select Administrative from the Report Category.

    The page is updated showing the list of administrative reports.

  4. Select Run PPM Package Interface.

    The Submit Report: Run PPM Package Interface window appears.

  5. Complete the fields, as described in the following table.

    Required fields are denoted with a red asterisk next to the field on the screen. Depending on your selections, the required fields may vary.

    Field Name

    Definition

    Group Id

    Specifies the group ID for which the interface program should be run. The interface program will only look for records with this value in the GROUP_ID column. This is useful when importing a batch of packages.

    Package No.

    Specifies the package number for which the interface program should be run. The interface program will only look for records with this value in the PACKAGE_NUMBER column. This is useful when importing a specific package.

    Package Id

    Specifies the package ID for which the interface program should be run. The interface program will only look for records with this value in the PACKAGE_ID calumniation is useful when importing a specific package.

    Source Code

    Indicates whether or not to set the SOURCE_TYPE_CODE column of the final requests created with a free-form text code. This is used as an indicator of how the request was created for auditing or testing purposes.

    Run Import

    • If set to Yes. Indicates that the program will process the records in the interface table and try to import them.

    • If set to No. Indicates that the program will simply report on the records in the interface table. This option is useful when auditing prior executions of the interface.

    Show Successful Transactions

    Indicates whether or not to show packages and package lines that were successfully imported.

    Show Failed Transactions

    Indicates whether or not to show packages and package lines that were not successfully imported.

  6. (Optional) To test the process, set the Run Import field to No.