This section explains the process of uploading a single or multiple transactions into the Oracle interface table. Once this step is completed you will still need toSubmit Concurrent Programto complete the process.
Use the cursor to select a single or range of transactions to upload, making sure you have included the first line of each receipt to be uploaded.
PO Receiving Wizard looks through the spreadsheet only between the top and bottom of the range you have indicated. If you have selected a range and only included the first line of the last receipt line to be uploaded, PO Receiving Wizard will continue past the end of the selected range if necessary to complete the last receipt line. The columns selected are NOT important.
1.Choose the Process Option you require from the PO Receiving Wizard ribbon as illustrated below:
The Process Options provided should be used as follows:
•Create – Use this option if creating an Advanced Shipping Notification (ASN), Deliver, Receipt or Direct Delivery.
•Correct – Use this option to correct an existing Transaction. Note that only the Quantity and Comments can be corrected.
•Return – Use this option if you are returning items to the ‘Supplier’ or returning items to ‘Receiving’.
•Inspect – Use this option for inspection required items.
2.Choose the Validate Option you require from the PO Receiving Wizard ribbon as illustrated below:
Validate only- This mode will validate the date using validation built into the Wizard. Note - Further validation will take place when uploaded into Oracle.
Validate and Upload- This mode will validate the data using the validation built into the Wizard and also create/correct/return receipts depending on the Process Option selected.
3.Click the ‘Upload’ icon and choose ‘Upload Selected’ on the ribbon to unload the selected transactions.
You can alter the data in the worksheet and ‘Validate only’ or ‘Validate and Upload’ them multiple times. You are not required to delete the record from the interface table as the Wizard will use the same ‘Process Set’ and replace the existing transactions.
