ERP toolkits / Oracle
Oracle E-Business Suite toolkit
Oracle E-Business Suite 12.2 is almost always on-prem or on customer-managed cloud servers. Oracle has committed to Premier Support for 12.2 well into the 2030s.
Free tools that run in your browser, fixes written for admins and developers, and how to put a private AI assistant on top of Oracle E-Business Suite without your data leaving your servers.
Plan your Oracle E-Business Suite work
Free planning apps built for Oracle E-Business Suite. Your work saves to your Netray account.
Oracle EBS Roadmap Planner
Compare staying on EBS 12.2, moving to OCI, Oracle Fusion Cloud ERP or a hybrid: fit scores with reasons, effort, a five-year cost model, CEMLI worksheet and 12.2 checklist.
Training Path Builder
Week by week ERP training plans by role and module, with real screens to practice on, dated lessons, progress tracking and export.
ERP Certification Study Planner
Study plans for ERP certifications built from the official exam objectives, re-weighted toward your weak areas, with progress, readiness and exam-day deadlines.
Upgrade Path Planner
Pick your current and target ERP release and describe your landscape. Get the verified upgrade path, the changes in every release you cross, a risk score, an effort range and a regression test plan.
ERP Table and Field Explorer
Search the core database tables of SyteLine, LN, M3, JD Edwards, SAP, Oracle EBS, NetSuite, Epicor and SYSPRO by name, field or description, see keys and joins, and generate a JOIN query skeleton.
Integration and EDI Designer
Pick business objects and target systems and get the ERP's real interface for each flow (BODs, IDocs, APIs, open interface tables, EDI documents), a field-level starter map and effort notes.
Module Fit and Gap Explorer
Map your manufacturing requirements to an ERP's official modules, see native fit, add-ons and gaps, and compare two ERPs side by side.
ERP Cost of Ownership Model
Five-year ERP total cost model built from your own license or subscription quotes: users, deployment, infrastructure, implementation effort, staff and support.
Implementation Partner Scorecard
Weighted scorecard and ERP-specific interview question bank for comparing ERP implementation partners and consultants.
Design private AI for Oracle E-Business Suite
The builder starts with Oracle E-Business Suite connected the way it supports. Pick a model and GPUs, add documents, and export the architecture.
Loading the architecture builder...
Free Oracle E-Business Suite tools
Calculators and simulators (24)
- Oracle EBS Min-Max Planning Calculator
- Oracle EBS WIP Job Variance Calculator
- Oracle EBS Item Lead Time Calculator
- Oracle EBS Operation Yield and Start Quantity Calculator
- Oracle EBS Average Cost Receipt and PPV Calculator
- Oracle EBS EOQ and Order Modifier Calculator
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Support End-Date Planning Calculator
- Oracle EBS Tablespace Growth Forecast Calculator
- Oracle EBS Concurrent Manager Queue Wait Calculator
- Oracle EBS Database Growth Forecast Calculator
- Oracle EBS AP Early Payment Discount Calculator
- Oracle EBS AR Aging Bad Debt Reserve Calculator
- Oracle EBS Fixed Asset Straight-Line Depreciation Calculator
- Oracle EBS Maintenance Window and Backup Time Calculator
- Oracle EBS 12.2 AI Assistant Sizing and Value Calculator
- Oracle EBS 12.2 adop Patch Cycle Downtime Calculator
- Oracle EBS 12.1.3 to 12.2 Upgrade Downtime Estimator
- Oracle EBS On-Premises vs OCI/AWS/Azure Hosting Cost Calculator
- Oracle EBS 12.2 Custom Code Remediation Effort Calculator
- Oracle EBS 12.2 Disk Space Calculator (fs1, fs2, fs_ne and Database)
- Oracle EBS Critical Patch Update (CPU) Annual Effort Calculator
- Oracle EBS Custom Forms to APEX Migration Effort Calculator
- Oracle EBS Concurrent Request Purge Retention and Disk Calculator
Code and document generators (37)
- Oracle EBS SQL Query Generator for Items and WIP Jobs
- Oracle EBS Inventory Organization Parameters Setup Template
- Oracle EBS Item Cost Update Request Form
- Oracle EBS Engineering Change Order Request Template
- Oracle EBS On-Hand Reconciliation SQL Generator
- Oracle EBS WIP Job Close Variance Review Memo Template
- Oracle EBS Onhand Quantity SQL Generator
- Oracle EBS BOM Explosion SQL Generator
- Oracle EBS Pending Transactions SQL Generator for Period Close
- Oracle EBS AP Invoice Interface Template
- Oracle EBS SQL for Concurrent Requests Generator
- Oracle EBS Concurrent Program Registration Request Template
- Oracle EBS Instance Clone Request Template
- Oracle EBS User Access Review Template
- Oracle EBS AP Supplier Onboarding Form Template
- Oracle EBS AP Invoices on Hold SQL Generator
- Oracle EBS User and Responsibility Audit SQL Generator
- Oracle EBS Inactive User Cleanup SQL Generator
- Oracle EBS GL Open Journals and Period Status SQL Generator
- Oracle EBS HRMS Employee Table Query Generator
- Oracle EBS 12.2 Private AI Layer Blueprint Generator
- Oracle EBS OE_ORDER_PUB.PROCESS_ORDER Script Generator
- Oracle EBS FND_REQUEST.SUBMIT_REQUEST Code Generator
- Oracle EBS PL/SQL Concurrent Program Generator (Package plus FND_PROGRAM Registration)
- Oracle EBS Concurrent Program Parameters and Responsibility SQL Generator
- Oracle EBS FND_USER_PKG Script Generator (Create User, Add Responsibility, Reset Password)
- Oracle EBS Item Import Script Generator (MTL_SYSTEM_ITEMS_INTERFACE and INCOIN)
- Oracle EBS AR Aging Buckets SQL Generator
- Oracle EBS GL Balances and Code Combination SQL Generator
- Oracle EBS Procure-to-Pay (P2P) SQL Generator: PO to Receipt to Invoice to Payment
- Oracle EBS Order-to-Cash (O2C) SQL Generator: Order to Delivery to Invoice to Receipt
- Oracle EBS Workflow Error and Notification SQL Generator
- Oracle EBS XML Publisher Data Template Generator
- Oracle EBS Patch Level, Applied Patches and Version SQL Generator
- Oracle EBS Value Set, Lookup and DFF SQL Generator
- Oracle EBS TCA Customer Creation API Script Generator (HZ V2 APIs)
- Oracle EBS Integrated SOA Gateway REST Service Call Generator (curl)
Reference tables and worksheets (44)
- Oracle EBS Discrete Job Statuses Reference
- Oracle EBS Inventory Transaction Types Reference
- Oracle EBS Item Attribute Template Worksheet
- Oracle EBS MRP Exception Messages Reference
- Oracle EBS BOM Interface Load Worksheet
- Oracle EBS WIP Accounting Class Reference
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
- Oracle EBS Routing and Operations Load Worksheet
- Oracle EBS Cycle Count Program Workload Planner
- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Journal Import Worksheet
- Oracle EBS Profile Option Change Log Worksheet
- Oracle EBS Custom Code Inventory Worksheet
- Oracle EBS Concurrent Program Load Planner Worksheet
- Oracle EBS Profile Options Reference
- Oracle EBS Finance Tables Reference (GL, AP, AR, FA)
- Oracle EBS Concurrent Managers and Settings Reference
- Oracle Fusion SCM Terminology vs EBS Reference
- Oracle EBS Module to Fusion Cloud Product Reference
- Oracle EBS to Fusion Fit Gap Worksheet
- Oracle EBS Cost Management Tables Reference
- Oracle EBS Employee, HR and Projects Tables Reference
- Oracle EBS ER Diagram: Key Table Relationships
- Oracle EBS Customer and Supplier Tables Reference
- Oracle EBS HR API List (HRMS Public APIs)
- Oracle EBS Order Management Tables Reference (OE, WSH, Order Import)
- Oracle EBS Purchasing and Receiving Tables Reference (PO, REQ, RCV)
- Oracle EBS Workflow Tables Reference (WF_ITEMS, WF_NOTIFICATIONS)
- Oracle EBS Application Object Library (FND) Tables Reference
- Oracle EBS Open Interface Tables, Import Programs and Error Tables Reference
- Oracle EBS Public PL/SQL API Reference (OM, INV, PO, AP, AR, TCA, FND)
- Oracle EBS 12.2 File System, Log Locations and Control Scripts Reference
- Oracle EBS 12.2 adop Phases and Options Reference
- Oracle EBS Multi-Org Structure Tables and MO_GLOBAL Reference
- Oracle EBS Forms Personalization Tables and Trigger Events Reference
- Oracle EBS Forms FRM Error Codes Reference (FRM-92101, FRM-40735)
- Oracle EBS Lookups, Value Sets and Flexfield Tables Reference
- Oracle EBS Advanced Pricing (QP) Price List Tables Reference
- Oracle EBS GL_INTERFACE Journal Import Error Codes Reference
- Oracle EBS XML Publisher RTF Template Syntax Reference
Checklists (14)
- Oracle EBS Inventory Period Close Checklist
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS GL Period Close Checklist
- Oracle EBS 12.2 Upgrade Readiness Checklist
- Oracle EBS Patching Checklist for adop
- Oracle EBS Rapid Clone Checklist
- Oracle EBS Concurrent Manager Not Starting Troubleshooting Checklist
- Oracle EBS Workflow Notification Mailer Troubleshooting Checklist
- Oracle EBS 12.2 Forms Not Launching Troubleshooting Checklist (Java, JWS, Browsers)
- Oracle EBS 12.2 Database Upgrade to 19c Checklist
- Oracle EBS 12.2.x Release Update Pack (RUP) Upgrade Checklist
- Oracle EBS Lift-and-Shift to OCI Readiness Checklist (EBS Cloud Manager)
- Oracle EBS Patch Impact Analysis Checklist (Patch Wizard and Customizations)
- Oracle EBS 12.2 Installation Checklist (Rapid Install on Oracle Linux)
Guides
Private AI layer architecture (1)
How-to and fixes (40)
- Fix FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-06508
- Oracle EBS Concurrent Manager Will Not Start: How to Fix It
- Fix Oracle EBS Workflow Notification Mailer Not Sending Emails
- Fix ORA-01555: Snapshot Too Old in Oracle EBS Concurrent Requests
- Fix adop phase=prepare Failures in EBS 12.2 Online Patching
- How to Import AP Invoices in Oracle EBS with Payables Open Interface Import
- How to Use Forms Personalization in Oracle EBS (No CUSTOM.pll Needed)
- How the adop Patching Cycle Works in Oracle EBS 12.2
- How to Extend an OAF Page in Oracle EBS Without Touching Seeded Code
- SQL to Find Responsibilities Assigned to a User in Oracle EBS
- FRM-92101: There was a failure in the Forms Server during startup
- GL period will not close: unposted or unaccounted journal batches
- AutoInvoice import fails with invalid line/header exceptions
- Oracle Workflow error: Attribute does not exist for item type
- Concurrent request completes with Warning and an FDPSTP message
- Oracle EBS Month-End Close Checklist: GL, AP, AR
- How to Close an Inventory Accounting Period in Oracle EBS
- How to Create a BI Publisher Report in Oracle EBS
- How to Register a Custom Concurrent Program in Oracle EBS
- How to Set Up AME Approval Rules in Oracle EBS
- Oracle EBS 12.2: stay on-prem or move to Fusion in 2026
- Fix Oracle EBS MTL_TRANSACTIONS_INTERFACE Rows Stuck With PROCESS_FLAG = 3
- Fix Oracle EBS Order Lines Stuck in Awaiting Shipping
- Fix Oracle EBS Requisition Import Errors in PO_INTERFACE_ERRORS
- Fix Oracle EBS Uncosted Material Transactions Blocking Period Close
- Fix Oracle EBS OPM Batches That Cannot Be Completed or Closed
- How to use FNDLOAD to migrate lookups, profiles and menus between Oracle EBS instances
- How to purge concurrent requests and manager data in Oracle EBS
- How to change the APPS password in Oracle EBS with FNDCPASS
- SQL query to find profile option values by level in Oracle EBS
- How to run Create Accounting and transfer subledger entries to GL in Oracle EBS R12
- Oracle Work Order Tables: WIP_ENTITIES, WIP_DISCRETE_JOBS and the REST Route
- Oracle EBS Outside Processing and Production Scheduling
- Oracle EBS Query for a Vendor Extract Report
- Oracle EBS REST API: Integrated SOA Gateway and PL/SQL APIs
- How to Create an Item in Oracle EBS
- Data Conversion in Oracle EBS: Interface Tables, Open Interfaces and Reconciliation
- Organization Structure in Oracle EBS: Ledger, Legal Entity, Operating Unit, Inventory Org
- Oracle EBS Advanced Pricing: Price Lists, Modifiers, Qualifiers and Formulas
- Oracle EBS Standard Reports by Module and Sample XML for BI Publisher
Add-on products that run with it (17)
- MarkView for Accounts Payable and Oracle E-Business Suite
- Esker Order Management and Oracle E-Business Suite
- NiceLabel LMS Enterprise and Oracle E-Business Suite Label Printing
- BarTender and Oracle E-Business Suite: Label Printing from Oracle
- Loftware Integration for Oracle EBS: WMS Label Requests
- Oracle Mobile Supply Chain Applications (MSCA) for Oracle EBS
- RFgen MobileEdge with Oracle E-Business Suite: replacing MSCA screens
- ProShip and Oracle E-Business Suite: multi-carrier shipping
- dormakaba B-COMM and Oracle EBS Time and Labor: shop floor time collection
- TEKLYNX SENTINEL and JD Edwards EnterpriseOne: automated label printing
- Zebra Enterprise Connector with JD Edwards and Oracle EBS: XML to ZPL labels
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode Inventory
- ShipConsole with Oracle E-Business Suite: Multi-Carrier Shipping
- Cleverence Mobile SMARTS with Oracle: Zebra RFID Handhelds
- Prometheus GWOS-AI with Oracle E-Business Suite
- Thomson Reuters ONESOURCE Indirect Tax with Oracle E-Business Suite
- Propel Apps Mobile Supply Chain with Oracle E-Business Suite
Integrations (12)
- How to add AI agents to Oracle E-Business Suite
- How to use ChatGPT with Oracle E-Business Suite
- How to connect Claude to Oracle E-Business Suite
- How to build an MCP server for Oracle E-Business Suite
- How to add an AI chatbot to Oracle E-Business Suite
- How to connect Power BI to Oracle E-Business Suite
- How to add WhatsApp to Oracle E-Business Suite
- How to connect Microsoft Teams to Oracle E-Business Suite
- How to add Slack alerts and approvals to Oracle E-Business Suite
- How to automate email-to-transaction in Oracle E-Business Suite
- How to add document OCR to Oracle E-Business Suite
- How to build a mobile app for Oracle E-Business Suite
AI use cases (6)
- AI for Oracle E-Business Suite, Without Leaving On-Prem
- AI for Oracle EBS in Aerospace and Defense Manufacturing
- AI for Oracle EBS in Pharmaceuticals: Batch Genealogy, Quality Data, and Validation-Aware Design
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered Directly
- AI for Oracle E-Business Suite Procure to Pay, From Requisition to Payment
- AI for Oracle EBS Order Management, From Booking to Invoice