Welcome to Routing Wizard.
We developed this tool to help with the data conversion process for Routings and to provide an alternative to the Oracle Applications Routing data entry form.
Oracle users needing to create Routings now have a richly featured excel solution allowing them to create their Routing directly from excel to Oracle Applications Routing module.
Routing Wizard is a VBA program embedded in a Microsoft Excel workbook. It is a close cousin to our other Wizard products and shares the same look and feel.
This documentation is written with the assumption the user knows how to create a Routing manually. We highly recommend you read this document in conjunction with the following:
• Oracle Bill of Materials Users Guide (11i), Chapter 3, Creating a Routing.
• Oracle Manufacturing APIs and Open Interfaces Manual, Chapter 3, Routing API Overview.
The software interfaces with the standard Oracle Routing API Interface. It does NOT modify any Oracle objects.
Features
All options are available on a ribbon.
Simply type, import, or paste the values directly into the spreadsheet. You can also double-click in the spreadsheet to load the form for data-entry. The data-entry form is optional.
You can upload Routings one at a time, select a range of Routings, or upload all Routings on the worksheet.
You can submit Routings or Operations to Delete Groups.
You can choose to have one Routing per sheet or multiple Routings within a sheet.
The program is flexible about the spreadsheet layout. You can move, delete, or hide unwanted columns. You can also have multiple sheets or even use sheets in other workbooks.
Limitations
Dynamic Locator entry is not supported in the Routing Wizard because of the API limitations.
Resources Referenced to Standard Operation cannot be uploaded in the Routing Wizard because of the API limitations.
Operations and Resources of a Common Routing cannot be uploaded in the Routing Wizard because all changes must be made in the parent Routing.
