Recommended 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 Lab

SQL / PL-SQL Explainer

Explain Oracle SQL/PLSQL, review joins, identify tables, and improve code quality. Sign-in may be required.

Open SQL / PL-SQL Tool

Oracle SQL Workbench / Executor

Connect to Oracle, write formatted SQL, browse objects, extract DDL, run read-only SQL, and load CSV data.

Open Oracle Workbench

ERP 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.

ERP Home Setup Configuration Transactions Planning / Reports Registers Approvals

Configuration

Maintain item sourcing, BOM-enabled flag, model/configuration relationship, default supplier, score fields, resources, standard BOM, model BOM, and routing.

ERP Home

Create Item

Item Number Description Item Type Make / Buy BOM Enabled Related Model Item Default Supplier Lead Time Days Min Order Qty Fixed Order Qty Safety Stock Current On Hand Unit Cost Sales Price Demand Score Supply Score Margin Score Risk Protection Score

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

Update 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 Item Line Type Component Item Resource Option Group Required? Qty / Hours Per Scrap % Operation Seq

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