Submit P.O. Import Concurrent Program
Once you have uploaded your data and are ready to import it, you can submit the concurrent request by clicking the ‘Submit Concurrent Program’ button on the Purchase Order Wizard ribbon.
This will run the Standard Oracle Import program and will advise you of the concurrent program request number.
If you are loading a Standard Purchase Order the concurrent program ‘Import Standard Purchase Orders’ is submitted. If you are loading Blanket Purchase Agreements then ‘Import Price Catalogs’ is submitted. Please refer to the Oracle Purchasing User Guide for additional details on the submission options.
The ‘Submit Request’ form with the details of the Batch will be displayed.
Click the Parameters search button 
and a form will display depending on the type of Purchase Order being processed (see the following examples).
Standard Purchase Orders Example
Blanket Purchase Agreement/Quotations Example
Click ‘Ok’ and the ‘Import Price Catalogs form will display:
Blanket Purchase Agreements or Quotations Form
Create Sourcing Rules
When Importing Blanket Purchase Orders or Quotations, PO Wizard can add ‘Approved Supplier List’ entries, ‘Create Sourcing Rules’ and ‘Create Sourcing Rule Assignments’.
To do this, firstly when the Blanket Purchase Order or Quotation has been loaded into the interface table the Line level effective dates must be provided in the Wizard. In the Quotation template these are the ‘Start Date’ and ‘End Date’ columns. In the Blanket template these are the ‘Line Effective Date’ and ‘Line Expiration Date’ columns.
When submitting the concurrent program the request parameters must be set as follows:
· The ‘Create Sourcing Rules’ must be set to ‘Yes’
· The ‘Approval Status’ must be set to ‘Approved’
Approval Status
The value which can be selected as an Approval Status is dictated by the Import Approval Methods form. To restrict the value which can be selected (for example restrict the selection to ‘Incomplete’ refer to the Approval Import Settings section.
Standard Purchase Order Form
Example of form for 12.1.3 and earlier
Example of form for 12.2.5
Approval Status - The value which can be selected as an approval status is dictated by the Import Approval Methods form. To restrict the value which can be selected (for example restrict the selection to ‘Incomplete’) refer to the Approval Import Settings section.
Complete the required fields as appropriate and then select the ‘Ok’ button. This will return you to the ‘Import Standard Purchase Orders’ form. Notice that the ‘Submit’ button is now active.
Select the ‘Submit’ button and the Request ID will be provided.
Select ‘OK’ and the Request ID will be populated into your worksheet.
You can view the status of the request by either clicking the ‘View Requests’ button on the ‘Import Standard Purchase Orders’ form (as previously displayed) or clicking the ‘View Concurrent Request’ button on the PO Wizard ribbon.
The ‘Requests’ form will appear detailing the status of the request.
Once the request has been completed close the ‘Requests’ form and refresh your worksheet by either using the ‘Refresh Sheet’ button on the ‘Import Standard Purchase Orders’ form or clicking the ‘Refresh Interface Status’ button on the PO Wizard Ribbon.
Defaulting Values for Concurrent Requests
The Wizard supports your custom LOV parameters and default values. For example: If you wanted to change the Blanket Agreement import and set the default approval option to initial approval you would:
1. Choose concurrent program menu option
2. Edit the concurrent program “Import Price Catalogs” from a sysadmin responsibility.
3. Select Parameters.
4. Update the Default Value to “INITIATE APPROVAL”.
If you wanted to change the value set to remove the ‘APPROVED’ option, you can do this too.
The list of values in the Wizard will display as:
Refer to section:
