Routing Wizard uses the standard Oracle Routing API to create the Routing and does not write to any other database objects.
A significant amount of validation is performed by the Routing Wizard during the upload process in order to prevent errors being loaded into Oracle. If any part of the Routing fails the Wizard validation or the Oracle Routing API validation, the Routing will not be loaded.
To upload Routings, you have a choice to validate them first by using the ‘Validate’ icon on the Routing 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.
The validations have been built into the Wizard, and do not include all errors which may be encountered based on your instance of Oracle. Additional errors may therefore be returned when the ‘Upload’ is performed.
Upload Routings
Upload will perform validation as per the ‘Validate’ option but will continue to load the Routing data where applicable. Although all sections will be validated, only those sections with an upload action will be uploaded, so it is possible to add a Resource to an existing Routing and only upload that Resource.
There are four 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 unprocessed records on the worksheet to EBS. This validates and uploads all records.
• Background Upload Selected – Validates and uploads a single or range of records, then will create a concurrent request. It does not update the sheet with results until requested to (via the Refresh Concurrent option).
• Background Upload All – Validates and uploads all unprocessed records on the worksheet, then creates a concurrent request. It does not update the sheet with results until requested to (via the Refresh Concurrent option).
Note: By default the Routing Wizard will validate all Routings belonging to an Item but upload only those that have an upload action. When uploading large amounts of data, background processing is recommended to prevent timeout.
Refer to section:
