Once you have successfully loaded your data into the interface table and are ready to import it into Oracle Purchasing, click the ‘Concurrent Processing’ icon on the Wizard ribbon and click ‘Submit Concurrent Program’.
The following form will appear:
Click the search button (ie …) for the Parameters and the following form will appear:
Import Batch ID- Choose the batch you wish to import. This is displayed in cell B6 on your worksheet.
Group By –Is programmed to default to ‘All’ option, grouping all the lines on one requisition per header record.
Last Requisition Number –last requisition number that exists in your system. Purchasing selects the next available requisition number. Leave this field blank to automatically get the next availablenumber.
Multiple Distributions –If you have to create multiple distributions for a requisition a line(s), select ‘Yes’ otherwise, choose ‘No’.
Initiate Approval after ReqImport– If this is set to ‘Yes’ the workflow approval will be started. If you require the status of the Requisition to remain as ‘Incomplete’ when loaded into Oracle, then set this value to ‘No’.
Once you have completed your selection click on ‘Ok’ and ‘Submit’. This will run the Standard Requisition Import program and will advise you of the concurrent program request number.
Check the status of your concurrent program by selecting the ‘View Concurrent Request’ button on the ribbon.
A view of the Oracle Concurrent Request screen will display:
Once the import has ‘Completed’ you can close the screen. You can then check the status of the import by clicking the ‘Refresh Concurrent Status’ button on the Wizard ribbon.
This will show the successfully Accepted records as green and Error as red with the line error message in the ‘Requisition Lines’ section as appropriate.
