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

Quantum API Console Help & Test Cases

Use these smoke tests to confirm that the Quantum API Console menu link, backend routes, mock optimizer, and API calling workflow are working correctly.

Test Case 1 — Page Open Test

  1. Open the portal menu.
  2. Click Quantum API Console.
  3. The screen should open without a 404 or 500 error.

Expected result: Quantum API Console page loads successfully.

Test Case 2 — Help Page Test

  1. Open /quantum-api-caller/help.
  2. Confirm this help page appears.
  3. Click Open Quantum API Console.

Expected result: Help and console navigation works.

Test Case 3 — Mock Optimizer Direct API Test

This test does not require any paid quantum provider. It calls the internal mock optimizer route.

curl -sS -X POST https://www.technopkg.com/api/quantum/mock-optimizer \
  -H 'Content-Type: application/json' \
  -d '{
    "scenario": "supplier_selection",
    "objective": "minimize cost, lead time, and risk",
    "supplier_data": [
      {"supplier":"SUP_A","unit_cost":12.5,"lead_days":12,"quality_score":0.96,"risk_score":0.20,"capacity":700},
      {"supplier":"SUP_B","unit_cost":11.8,"lead_days":18,"quality_score":0.92,"risk_score":0.35,"capacity":900},
      {"supplier":"SUP_C","unit_cost":13.1,"lead_days":8,"quality_score":0.97,"risk_score":0.15,"capacity":500}
    ]
  }'

Expected result: response JSON contains "ok": true, "provider": "TechnoPkg Mock Quantum-Inspired Optimizer", and a recommendation.

Test Case 4 — Console-to-Mock API Test

  1. Open Quantum API Console.
  2. Select template TechnoPkg Mock Optimizer Test Case.
  3. Click Apply Template.
  4. Check I confirm this API call is approved.
  5. Click Call Quantum API.

Expected result: Response tab shows HTTP 200 and a mock optimization result.

Test Case 5 — Security Block Test

Use this to confirm that unsafe local/private targets are blocked by default.

FieldValue
MethodGET
Base URLhttp://127.0.0.1:5000
Endpoint Path/

Expected result: Request is blocked because private/local network targets are not allowed unless explicitly enabled for a lab setup.

ERP/SCM Sample Payload

Use this body JSON for supplier-selection or planning experiments.

{
  "scenario": "supplier_selection",
  "objective": "select best supplier mix using cost, lead time, quality, risk, and capacity",
  "demand_qty": 1000,
  "supplier_data": [
    {"supplier":"SUP_A", "unit_cost":12.5, "lead_days":12, "quality_score":0.96, "risk_score":0.20, "capacity":700},
    {"supplier":"SUP_B", "unit_cost":11.8, "lead_days":18, "quality_score":0.92, "risk_score":0.35, "capacity":900},
    {"supplier":"SUP_C", "unit_cost":13.1, "lead_days":8,  "quality_score":0.97, "risk_score":0.15, "capacity":500}
  ]
}
Note: The mock optimizer is only for portal testing. Real quantum or quantum-inspired API results depend on the provider endpoint, payload schema, token, and network access.