Import Contract Purchase Agreements

The Import Contract Purchase Agreements program enables you to import contract purchase agreements from legacy systems into Oracle Purchasing. Oracle Purchasing provides the Purchasing Documents Open Interface (PDOI) that validates the purchase agreements information, and then the Import Contract Purchase Agreements concurrent program imports it into Purchasing.

To use this feature, you must first use a custom import program to load the data into the interface tables. Once the data is loaded, the Import Contract Purchase Agreements concurrent program is run from within Oracle Purchasing to validate and create contract purchase agreements through PDOI. This program populates data in the PO_HEADERS_INTERFACE table.

Submission

In the Submit Requests window, select Import Contract Purchase Agreements in the Name field.

Parameters

Default Buyer (Optional)

Enter the default buyer name to be associated with the incoming documents that are not assigned to a buyer. If a default buyer is not specified and the imported purchase agreement also does not have buyer information, the program will use the normal Purchasing defaulting mechanism to generate buyer information. If the buyer name provided in the interface is not valid, then the record will error out and the default buyer name will not be supplemented.

Approval Status (Required)

This is a mandatory parameter. Select either Approved, Incomplete, or Initiate Approval. You can import contract purchase agreements with an INCOMPLETE status and then automatically initiate the PDOI Auto Approval workflow Process for these imported documents. Specifying a status of Incomplete or leaving the status Null in the interface data, and specifying a value of Initiate Approval for the Approval Status runtime parameter can achieve this. Contract purchase agreements can also be imported with an APPROVED status. Specifying a status of Approved in the interface data or leaving the status Null in the interface data, and specifying a value of Approved for the Approval Status runtime parameter can achieve this. The PDOI Auto Approval workflow Process is not initiated.

Attention: If the concurrent program is executed with the Approval Status parameter INITIATE APPROVAL or APPROVED, then you must run the Workflow Background Process for Item type PO Approval with process deferred as Yes.

Batch ID (Optional)

Enter a valid batch ID, that is a unique identifier for the group of documents in this submission. If you don't enter a Batch ID, one is generated for you when the process runs.

Batch Size (Optional)

Enter the batch size to process data. The default batch size is 5000.

Gather Stats

Select Yes or No to determine whether data must be collected for analysis. The default value is No.

Related Topics