Instructions for Restarting Concurrent Programs with a Manual Restart Mode in Oracle Purchasing

For Oracle E-Business concurrent programs, the Restart Mode attribute indicates how a program can be restarted in case of system failure.

The Restart Mode can be one of four values:

Resumable: This program can be automatically restarted and can resume its processing at the point where it left off before the system failure.
Restartable: This program can be automatically restarted but will go back to the beginning of its processing.
Manual: An administrator must perform manual steps to restart this program. Product-specific documentation lists the steps required to restart any shipped programs with a Manual restart mode.
Unknown: It is unknown whether this program can be restarted automatically or not. This value is the initial default setting.

Important: The Restart Mode for Oracle-provided programs should not be modified. If it were to be modified, the value may be overwritten without warning by future Oracle EBS software updates.

For more information about the Restart Mode, see the Oracle E-Business Suite Setup Guide

For the Oracle Purchasing concurrent programs with a Restart Mode of Manual, an administrator must perform the steps specified prior to restarting the program following a system failure. The following is the list of such concurrent programs:

Import Price Catalogs Concurrent Program
Import Standard Purchase Order Concurrent Program
Import Contract Purchase Agreements Concurrent Program
Run MassCancel Concurrent Program
Retrieve Time from OTL Concurrent Program
Create Standard Purchase Orders Concurrent Program

Steps to manually restart these programs:

Import Price Catalogs Concurrent Program

The manual restart steps for Import Price Catalogs are as follows:
1. Identify the failed Request
  - Navigate to the Find Requests window using Purchasing Responsibility: click Requests, then click Find Requests in the Requests window.
  - Query the failed Import Price Catalogs request.
  - Note the Request ID and any error messages.
2. Review, purge, and reinsert the unprocessed data
  - Check the following interface tables for unprocessed records:
    - PO_HEADERS_INTERFACE
    - PO_LINES_INTERFACE
  - Verify that the following status columns are neither in Accepted nor Pending status:
    - PROCESS_CODE
    - INTERFACE_STATUS_CODE
  - Purge unprocessed records from the interface tables.
  - Reinsert the corrected data.
3. Resubmit the Import Price Catalog Program
  - Navigate to the Requests window.
  - Submit the Import Price Catalogs program again.
  - Monitor its progress until completion.
Import Standard Purchase Order Concurrent Program

The manual restart steps for Import Standard Purchase Order are as follows:
1. Identify the failed Request
  - Navigate to the Find Requests window using Purchasing Responsibility: click Requests, then click Find Requests in the Requests window.
  - Query the failed Import Standard Purchase Order request.
  - Note the Request ID and any error messages.
2. Review, purge, and reinsert the unprocessed data
  - Check the following interface tables for unprocessed records:
    - PO_HEADERS_INTERFACE
    - PO_LINES_INTERFACE
  - Verify that the following status columns are neither in Accepted nor Pending status:
    - PROCESS_CODE
    - INTERFACE_STATUS_CODE
  - Purge unprocessed records from the interface tables.
  - Reinsert the corrected data.
3. Resubmit the Import Standard Purchase Order Program
  - Navigate to the Requests window.
  - Submit the Import Standard Purchase Order program again.
  - Monitor its progress until completion.
Import Contract Purchase Agreements Concurrent Program

The manual restart steps for Import Contract Purchase Agreements are as follows:
1. Identify the failed Request
  - Navigate to the Find Requests window using Purchasing Responsibility: click Requests, then click Find Requests in the Requests window.
  - Query the failed Import Contract Purchase Agreements request.
  - Note the Request ID and any error messages.
2. Review, purge, and reinsert the unprocessed data
  - Check the PO_HEADERS_INTERFACE interface table for unprocessed record.:
  - Verify that the following status columns are neither in Accepted nor Pending status:
    - PROCESS_CODE
    - INTERFACE_STATUS_CODE
  - Purge unprocessed records from the interface tables.
  - Reinsert corrected data.
3. Resubmit the Import Contract Purchase Agreement Program
  - Navigate to the Requests window.
  - Submit the Import Contract Purchase Agreements program again.
  - Monitor its progress until completion.
Run MassCancel Concurrent Program
Retrieve Time from OTL Concurrent Program
Create Standard Purchase Orders Concurrent Program

The manual restart steps for Run MassCancel, Retrieve Time from OTL, and Create Standard Purchase Orders are as follows:

Create a service request for data cleanup.
After data cleanup completes, rerun the program.