ERP Planning Lab
ERP-style planning, demand-supply review, planned order release, PO/job output, score validation, and registers.
Open ERP Planning LabRecommended ERP, SQL and Planning Tools
Quick access to key tools from Tools, ERP, AI, Workspaces, and Portal Directory pages.
ERP Planning Lab
ERP-style planning, demand-supply review, planned order release, PO/job output, score validation, and registers.
Open ERP Planning LabSQL / PL-SQL Explainer
Explain Oracle SQL/PLSQL, review joins, identify tables, and improve code quality. Sign-in may be required.
Open SQL / PL-SQL ToolOracle SQL Workbench / Executor
Connect to Oracle, write formatted SQL, browse objects, extract DDL, run read-only SQL, and load CSV data.
Open Oracle WorkbenchERP Planning Lab
ERP-style score-based supply-demand planning. Submit a fresh plan, validate score, release BUY items to PO and MAKE items to discrete job, consume onhand/capacity, and review registers.
Configuration
Maintain item sourcing, BOM-enabled flag, model/configuration relationship, default supplier, score fields, resources, standard BOM, model BOM, and routing.
Update Item
| Item | Type | Make/Buy | BOM | Model | Supplier | LT | Safety | Onhand | Fixed | Cost | Price | Scores | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CFG-PUMP-1001 Configured pump from MODEL-PUMP-SYSTEM |
CONFIGURATION | MAKE | Yes | MODEL-PUMP-SYSTEM | - | 9 | 0.0 | 0.0 | 1.0 | 610.0 | 1080.0 | D 92.0 · S 66.0 · M 88.0 · R 72.0 | Update |
| COMP-MOTOR Motor component |
COMP | BUY | No | - | Quantum Metals | 14 | 8.0 | 4.0 | 10.0 | 210.0 | 0.0 | D 76.0 · S 64.0 · M 70.0 · R 62.0 | Update |
| COMP-PCB Electronic PCB |
COMP | BUY | No | - | Fast Electronics | 5 | 20.0 | 12.0 | 25.0 | 48.0 | 0.0 | D 82.0 · S 80.0 · M 72.0 · R 76.0 | Update |
| FG-ETO-PANEL Engineer-to-order control panel |
FG | MAKE | Yes | - | - | 12 | 0.0 | 0.0 | 1.0 | 1250.0 | 2400.0 | D 94.0 · S 60.0 · M 90.0 · R 64.0 | Update |
| FG-MTO-PUMP Make-to-order industrial pump |
FG | MAKE | Yes | - | - | 7 | 2.0 | 1.0 | 5.0 | 420.0 | 760.0 | D 88.0 · S 68.0 · M 86.0 · R 78.0 | Update |
| FG-RETAIL-KIT Retail finished kit |
FG | MAKE | Yes | - | - | 4 | 15.0 | 20.0 | 10.0 | 85.0 | 140.0 | D 82.0 · S 74.0 · M 78.0 · R 72.0 | Update |
| MODEL-PUMP-SYSTEM Configurable pump system model BOM |
MODEL | MAKE | Yes | - | - | 10 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | D 88.0 · S 65.0 · M 80.0 · R 70.0 | Update |
| OC-MOTOR-TYPE Motor type option class |
OPTION_CLASS | MAKE | Yes | - | - | 5 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | D 70.0 · S 65.0 · M 70.0 · R 70.0 | Update |
| OPT-HIGH-MOTOR High power motor option |
OPTION | BUY | No | - | Quantum Metals | 12 | 0.0 | 6.0 | 1.0 | 260.0 | 0.0 | D 78.0 · S 65.0 · M 75.0 · R 65.0 | Update |
| OPT-STD-MOTOR Standard motor option |
OPTION | BUY | No | - | Quantum Metals | 10 | 0.0 | 10.0 | 1.0 | 180.0 | 0.0 | D 72.0 · S 70.0 · M 70.0 · R 70.0 | Update |
| PACK-BOX Retail packaging box |
RM | BUY | No | - | Global Components | 4 | 40.0 | 70.0 | 100.0 | 3.0 | 0.0 | D 66.0 · S 88.0 · M 60.0 · R 84.0 | Update |
| RM-ALUMINUM Aluminum raw material |
RM | BUY | No | - | Quantum Metals | 10 | 30.0 | 22.0 | 50.0 | 18.0 | 0.0 | D 74.0 · S 58.0 · M 64.0 · R 60.0 | Update |
| SUB-POWER-MODULE Power module subassembly |
SUB | MAKE | Yes | - | - | 5 | 3.0 | 1.0 | 4.0 | 310.0 | 0.0 | D 78.0 · S 66.0 · M 72.0 · R 68.0 | Update |
Create Resource
| Code | Name | Type | Daily Cap | Horizon | Available | Reliability | Stress | Action |
|---|---|---|---|---|---|---|---|---|
| RES-CNC | CNC Machine | MACHINE | 40.0 | 10 | 400.0 | 78.0 | 35.0 | Update |
| RES-LABOR | Assembly Labor | LABOR | 64.0 | 10 | 640.0 | 86.0 | 20.0 | Update |
| RES-QA | Quality Inspection | LABOR | 24.0 | 10 | 240.0 | 88.0 | 18.0 | Update |
| RES-SUPCAP | Supplier Capacity Buffer | SUPPLIER | 100.0 | 10 | 1000.0 | 76.0 | 30.0 | Update |
Create Item Resource / Routing
| Item | Operation | Resource | Hours/Unit | Action |
|---|---|---|---|---|
| FG-ETO-PANEL | 10 | RES-LABOR - Assembly Labor | 2.0 | Update |
| FG-ETO-PANEL | 20 | RES-QA - Quality Inspection | 0.75 | Update |
| FG-MTO-PUMP | 10 | RES-CNC - CNC Machine | 1.5 | Update |
| FG-MTO-PUMP | 20 | RES-LABOR - Assembly Labor | 0.75 | Update |
| FG-MTO-PUMP | 30 | RES-QA - Quality Inspection | 0.2 | Update |
| FG-RETAIL-KIT | 10 | RES-LABOR - Assembly Labor | 0.45 | Update |
| FG-RETAIL-KIT | 20 | RES-QA - Quality Inspection | 0.08 | Update |
| SUB-POWER-MODULE | 10 | RES-LABOR - Assembly Labor | 0.6 | Update |
| SUB-POWER-MODULE | 20 | RES-QA - Quality Inspection | 0.12 | Update |
Create Standard BOM Line
| Parent | Component | Qty Per | Scrap % | Operation | Action |
|---|---|---|---|---|---|
| FG-ETO-PANEL | SUB-POWER-MODULE | 1.0 | 2.0 | 10 | Update |
| FG-ETO-PANEL | RM-ALUMINUM | 8.0 | 5.0 | 20 | Update |
| FG-MTO-PUMP | COMP-MOTOR | 1.0 | 1.0 | 10 | Update |
| FG-MTO-PUMP | RM-ALUMINUM | 4.0 | 4.0 | 20 | Update |
| FG-RETAIL-KIT | COMP-PCB | 1.0 | 2.0 | 10 | Update |
| FG-RETAIL-KIT | PACK-BOX | 1.0 | 0.0 | 20 | Update |
| FG-RETAIL-KIT | RM-ALUMINUM | 2.0 | 3.0 | 30 | Update |
| SUB-POWER-MODULE | COMP-PCB | 2.0 | 2.0 | 10 | Update |
| SUB-POWER-MODULE | COMP-MOTOR | 1.0 | 1.0 | 20 | Update |
Create Model BOM Line
POC Oracle-style model BOM: parent must be MODEL / MODEL_BOM / BOM. Lines can be MAKE, BUY, RESOURCE, OPTION, or OPTION_CLASS. Discrete job release is blocked for model item and allowed for CONFIGURATION item linked to the model.
| Model | Line Type | Component / Resource | Option Group | Required | Qty / Hours | Scrap % | Operation | Action |
|---|---|---|---|---|---|---|---|---|
| MODEL-PUMP-SYSTEM | OPTION_CLASS | OC-MOTOR-TYPE | MOTOR | Yes | 1.0 | 0.0 | 10 | Update |
| MODEL-PUMP-SYSTEM | OPTION | OPT-STD-MOTOR | MOTOR | Yes | 1.0 | 0.0 | 20 | Update |
| MODEL-PUMP-SYSTEM | OPTION | OPT-HIGH-MOTOR | MOTOR | No | 1.0 | 0.0 | 20 | Update |
| MODEL-PUMP-SYSTEM | BUY | COMP-PCB | - | Yes | 1.0 | 2.0 | 30 | Update |
| MODEL-PUMP-SYSTEM | MAKE | SUB-POWER-MODULE | - | Yes | 1.0 | 2.0 | 40 | Update |
| MODEL-PUMP-SYSTEM | BUY | RM-ALUMINUM | - | Yes | 4.0 | 3.0 | 50 | Update |
| MODEL-PUMP-SYSTEM | RESOURCE | RES-CNC - CNC Machine | - | Yes | 1.25 | 0.0 | 60 | Update |
| MODEL-PUMP-SYSTEM | RESOURCE | RES-LABOR - Assembly Labor | - | Yes | 0.8 | 0.0 | 70 | Update |
| MODEL-PUMP-SYSTEM | RESOURCE | RES-QA - Quality Inspection | - | Yes | 0.25 | 0.0 | 80 | Update |