To upload records, you have a choice to validate them first by using the ‘Validate’ icon on the Requisition Wizard ribbon. The choices are ‘Validate Selected’ which will validate as per rows selected, or ‘Validate All’ which will validate all rows on the sheet.
Validation will be performed on every populated field and set any applicable default when an empty field is encountered. This allows the user to perform a test run that validates the selected records but does not upload the records.
Upload Records
Upload will perform validation as per the ‘Validate’ option but will continue to load the individual records. Every validated record is sent to Oracle and an ID is retrieved and written to the sheet when successful.
There are two ways of selecting which records will be uploaded. Each method performs the same steps within the selection; consequently, they only differ by the scope of the selection:
•Upload Selected– Uploads a single or range of records as per the selection of rows with the cursor.
•Upload All– Uploads all records on the worksheet.
There are two steps that need to be completed before data is available in Oracle Purchasing:
Step One– Upload the requisition/s into the Oracle Requisitions Interface Table which is included in this section.
Step Two– Import the data from the Oracle Requisition Interface Table into Oracle Purchasing. Once this step is completed successfully then you are able to view the requisition/s in Oracle Purchasing. Refer to theSubmit Requisition Import Concurrent Programfor details on this step.
