# Oracle EBS Routing and Operations Load Worksheet > Source: https://netray.co/tools/oracle-ebs-routing-operations-load-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable worksheet to prepare routing operations and resources for migration or setup, with total hours per lot calculated for each line. ## Category oracle ## Erp Oracle E-Business Suite ## Industry Discrete Manufacturing ## Audience - EBS consultant - Manufacturing engineer - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Assembly **Key:** assembly **Type:** text #### Operation sequence **Key:** op_seq **Type:** number #### Department **Key:** dept **Type:** text #### Resource **Key:** resource **Type:** text #### Basis **Key:** basis **Type:** select **Options:** - Item - Lot #### Setup hours **Key:** setup_hr **Type:** number **Format:** hours #### Run hours per unit **Key:** run_hr **Type:** number **Format:** decimal #### Lot size **Key:** lot_size **Type:** number **Unit:** units #### Total hours per lot **Key:** lot_hours **Type:** number **Expr:** setup_hr + run_hr * lot_size **Format:** hours #### Hours per unit **Key:** hr_per_unit **Type:** number **Expr:** if(gt(lot_size,0),(setup_hr + run_hr * lot_size) / lot_size,0) **Format:** decimal #### Resource rate per hour **Key:** rate **Type:** number **Format:** currency #### Resource cost per lot **Key:** lot_cost **Type:** number **Expr:** (setup_hr + run_hr * lot_size) * rate **Format:** currency **Rows:** **Assembly:** AS-10045 **Op seq:** 10 **Dept:** CUT **Resource:** SAW01 **Basis:** Item **Setup hr:** 0.5 **Run hr:** 0.05 **Lot size:** 100 **Rate:** 38 **Assembly:** AS-10045 **Op seq:** 20 **Dept:** MACH **Resource:** CNC03 **Basis:** Item **Setup hr:** 1.5 **Run hr:** 0.12 **Lot size:** 100 **Rate:** 75 **Assembly:** AS-10045 **Op seq:** 30 **Dept:** ASSY **Resource:** LABOR **Basis:** Item **Setup hr:** 0.25 **Run hr:** 0.2 **Lot size:** 100 **Rate:** 32 **Assembly:** AS-20310 **Op seq:** 10 **Dept:** MACH **Resource:** CNC03 **Basis:** Item **Setup hr:** 2 **Run hr:** 0.4 **Lot size:** 40 **Rate:** 75 **Assembly:** AS-20310 **Op seq:** 20 **Dept:** TEST **Resource:** TESTER **Basis:** Lot **Setup hr:** 1 **Run hr:** 0.1 **Lot size:** 40 **Rate:** 45 **Totals:** #### Total hours (all lines) **Key:** lot_hours **Agg:** sum **Format:** hours #### Total resource cost **Key:** lot_cost **Agg:** sum **Format:** currency **Summary:** #### Average cost per operation line **Key:** avg_cost **Expr:** sum_lot_cost / count **Format:** currency **Primary:** true **Notes:** Basis is recorded for documentation. Oracle treats Item basis as per unit and Lot basis as once per lot, so for Lot basis resources enter the full run hours per lot in the lot hours logic you adopt and adjust the formula in your own copy. ## Content **Intro:** Routing data is one of the heaviest conversion objects in an Oracle EBS manufacturing project. This worksheet gives engineers and consultants a clean layout for operations and resources, with hours and cost per lot calculated so errors surface before load. **Sections:** #### How to use it **Body:** List one row per operation and resource per assembly. Enter the department, resource, setup hours, run hours per unit and the lot size you plan against. The sheet calculates total hours per lot, hours per unit and resource cost. Sort by assembly, then operation sequence, to review each routing in order. Export to Excel and use it as the source for your load file, or as the reviewed baseline for a manual keying session. **Bullets:** - Use consistent operation sequence steps such as 10, 20, 30 to leave room for later inserts - Validate departments and resources against your setup before loading - Keep one lot size per assembly for like-for-like comparison #### What the numbers mean **Body:** Total hours per lot is setup plus run per unit times lot size. Hours per unit spreads setup across the lot, so small lots look more expensive per unit, which is the whole point of lot sizing. Resource cost multiplies hours by the rate and is a planning indicator, not the costing result. Costing in Oracle uses the resource rates and overhead rules defined in the cost organization. #### Routing fields in Oracle EBS **Body:** A routing in Oracle Bills of Material is made of operations, which belong to departments, and operations hold resources with usage rate, basis, assigned units and scheduling flags. Resources can be scheduled or not, charged or not, and may use autocharge types such as WIP move or manual. These choices drive scheduling, costing and shop floor reporting, so capture them as extra columns in your own copy if your project needs them. #### Common mistakes **Body:** The most frequent issues are inconsistent units for run time, mixing minutes and hours across source systems, and reusing a resource at multiple operations without checking capacity. Also check for operations without a department, resources not assigned to the department, and routings missing a final operation for move transactions. Reconcile total hours against the legacy system to catch conversion errors early. **Cta:** If you are migrating routings from a legacy ERP or MES, Netray can help review and map them with a private, on-prem workflow. **Faq:** #### Is this the Oracle open interface format? **Answer:** No. It is a planning and review layout. Use it to prepare and check the data, then map it to the columns required by your chosen load method, such as the open interface tables or a loader tool. #### Why do I need lot size on the sheet? **Answer:** Lot size is needed to turn per-unit run time and one-off setup into a total for a lot, and to see how setup is spread. It is also useful when comparing lot sizes. #### Can I use minutes instead of hours? **Answer:** Yes, but be consistent. Convert by dividing minutes by 60 before entering, since the sheet and Oracle resource usage rates are normally expressed in hours. #### Does this schedule the shop floor? **Answer:** No. It totals time and cost only. Scheduling and capacity are handled by Oracle's scheduling and planning functions using the setup you load. ## Search terms oracle ebs routing load template, oracle bom routing data load excel, ebs routing operations worksheet, oracle routing conversion template, bom routing migration worksheet, oracle bill of resources routing --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json