Free Oracle tools

129 templates, calculators, worksheets and reference tables. Each runs in your browser and exports to PDF, Excel, Word or CSV.

Templates and forms (18)Worksheets (31)Calculators and simulators (33)Reference tables (21)Code and query generators (9)Checklists (13)Assessments (4)

Templates and forms

Oracle EBS Inventory Organization Parameters Setup Template

Fill-in setup document for a new inventory organization with the decisions a business owner must sign off before configuration.

Oracle EBS Item Cost Update Request Form

Fill-in form to request and approve a standard cost change with reason, impact and sign-off lines for the audit file.

Oracle EBS Engineering Change Order Request Template

Fill-in change request that captures what changes, which BOMs and routings are affected, effectivity, and approval signatures before you create the ECO in Oracle Engineering.

Oracle EBS WIP Job Close Variance Review Memo Template

A one page memo to record why a discrete job closed with a variance, who owns the fix and what will change.

Oracle EBS Concurrent Program Registration Request Template

A request form that captures everything an EBS developer needs to register a custom concurrent program: executable, execution method, parameters, request group and incompatibilities.

Oracle EBS Instance Clone Request Template

A clone request form for EBS refreshes: source and target, backup point, data scrambling, post-clone configuration and sign-off.

Oracle EBS User Access Review Template

A periodic access review record for EBS users and responsibilities, with scope, evidence, exceptions and reviewer sign-off.

Oracle EBS AP Supplier Onboarding Form Template

A supplier set-up request for Oracle Payables with legal, tax, site, banking and payment term fields plus verification and approval steps.

Oracle Fusion BI Publisher Report Specification Template

Document a BI Publisher report before you build it: purpose, data model, parameters, layout, schedule and security in one template.

Oracle Fusion SCM UAT Test Script Template

A fill-in test script with preconditions, step table, expected results and sign off for user acceptance testing of Oracle Fusion SCM.

Oracle Fusion SCM Implementation Statement of Work Template

A generic statement of work outline for an Oracle Fusion SCM implementation with scope, phases, assumptions, responsibilities and acceptance.

Oracle Fusion Integration Design Document Template

Fill in interface details once and get a clean design document covering method, mapping, scheduling, error handling and approvals.

JD Edwards Orchestrator Design Template

A fill-in design document for a JD Edwards Orchestrator orchestration: purpose, inputs, steps, rules, outputs, security and test cases.

JD Edwards Environment Refresh Runbook Template

A fill-in runbook for refreshing a JDE test or development environment from production: scope, data sources, pre-checks, steps, validation and sign-off.

JD Edwards Object Promotion Request Template

A change request form for promoting JDE objects through OMW project statuses and path codes, with testing evidence, package plan and rollback.

JD Edwards Data Dictionary Item Request Template

A form for requesting a new or changed data dictionary item: alias, type, size, row and column descriptions, edit rules and where it will be used.

JDE Package Build and Deployment Request Template

A change request document for JDE package builds and deployments with objects, targets, approvals, back-out and verification steps.

JDE World DREAM Writer Version Documentation Template

Document a DREAM Writer program version, its processing options, data selection, sequencing and output in a form that survives staff changes and migration projects.

Worksheets

Oracle EBS Item Attribute Template Worksheet

Plan item master attribute values for a new item template, with the underlying MTL_SYSTEM_ITEMS_B column for each attribute.

Oracle EBS BOM Interface Load Worksheet

Stage BOM component rows with the columns used by the Oracle BOM open interface, then export to Excel for loading.

Oracle EBS Cycle Count Setup Worksheet

Editable worksheet to plan ABC cycle counts, record counted quantities and see variance in units and value before you approve adjustments in EBS.

Oracle EBS WIP Job Close Variance Worksheet

Editable worksheet to review material and resource variances per discrete job before running the close, with variance percent and totals.

Oracle EBS Routing and Operations Load Worksheet

Editable worksheet to prepare routing operations and resources for migration or setup, with total hours per lot calculated for each line.

Oracle EBS Cycle Count Program Workload Planner

Plan ABC cycle counting: how many counts per year, per day and how many hours of counter time your frequency choices need.

Oracle EBS Responsibility Design Worksheet

Plan custom responsibilities row by row: menu, request group, data group, MO security profile and the business role each one serves.

Oracle EBS GL Journal Import Worksheet

Prepare journal lines in the shape of GL_INTERFACE, check debits against credits per row set, and export to Excel or CSV before loading.

Oracle EBS Profile Option Change Log Worksheet

Track every profile option change with its level, old and new value, reason and approver, so clones, upgrades and audits stop being guesswork.

Oracle EBS Custom Code Inventory Worksheet

Catalog reports, interfaces, conversions, extensions and forms with a disposition and effort estimate so you can size an EBS upgrade or retirement.

Oracle EBS Concurrent Program Load Planner Worksheet

List your scheduled concurrent programs with runtime and frequency, then see total busy minutes and the processes needed to carry the load.

Oracle Fusion FBDI Template Field Guide

Map every FBDI column to its source, rule and owner before you load. Editable worksheet that exports to Excel.

Oracle Fusion Item Class Design Worksheet

Plan item classes, parent classes, attribute groups and templates before you configure Fusion Product Hub, then export the design to Excel.

Oracle Fusion Role Provisioning Worksheet

Plan who gets which Fusion job role, with which data access, who approved it and whether it raises a segregation of duties concern.

Oracle Fusion Cloud SCM Fit Gap Worksheet

Log each requirement, classify it as standard, configuration, extension or gap, and total the effort and cost before the design workshops end.

Oracle Fusion Data Migration Mapping Worksheet

Map legacy fields to Oracle Fusion objects and attributes, record the transform rule, and see how many records survive cleansing.

Oracle Fusion Cutover Plan Worksheet

Plan a go-live weekend task by task, with start offsets, durations, owners and a calculated end hour for each step.

Oracle Fusion Manufacturing Work Definition Worksheet

Design routing operations before you key them in. Capture work centers, setup and run times, yield and the total time for an order quantity.

Oracle Fusion Inventory Organization Design Worksheet

Lay out inventory organizations, subinventories and locators with their purpose, ownership and counts before configuring them.

Oracle Fusion Data Conversion Tracker Worksheet

Track each conversion object across mock loads, with source counts, loaded counts, errors and automatic error rates.

Oracle EBS to Fusion Fit Gap Worksheet

Capture each requirement, classify it as standard, configuration, extension or gap, and total the effort in days.

JD Edwards Work Order Status Codes Template

Editable worksheet to document your JD Edwards work order status codes, what each one means, who owns it and where an order can move next.

JD Edwards UBE Job Scheduling Worksheet

Editable worksheet to plan and document scheduled UBE batch jobs with versions, queues, run windows, dependencies and owners.

JD Edwards Security Workbench Worksheet

Editable worksheet to record JD Edwards role security records by type, with the actions allowed, risk notes and approver for each.

JD Edwards UBE Runtime Log Worksheet

Record each UBE run with its version, records processed and runtime, and see throughput per second so slow versions stand out.

JD Edwards Next Numbers Capacity Worksheet

List the next number series you track, their current and ending values and annual volume, and see how many years of headroom remain.

JD Edwards User Defined Code Change Log Worksheet

Track each UDC value you add, change or retire, which environments it has reached, who approved it and why.

JD Edwards Go-Live Cutover Plan Worksheet

Plan each cutover task with an owner, start hour and duration, and see end times and total window length before the weekend arrives.

JDE UBE Runtime Baseline Log Worksheet

An editable log of UBE runs with computed throughput, so you can compare before and after a tools release, database or hardware change.

JD Edwards World to EnterpriseOne Data Conversion Mapping Worksheet

Editable worksheet that tracks every World file you convert to EnterpriseOne: source, target, cleansing rule, record counts, owner and status.

JD Edwards World Custom Program and Modification Inventory Worksheet

Editable inventory of custom programs, modified objects and custom files with business criticality and a retire, keep or replace decision.

Calculators and simulators

Oracle EBS Min-Max Planning Calculator

Calculate min and max quantities for Oracle min-max planned items from annual demand, lead time, variability and ordering cost.

Oracle EBS WIP Job Variance Calculator

Split a standard cost discrete job into material usage, resource efficiency and resource rate variances before you close it.

Oracle EBS Item Lead Time Calculator

Compute total planning lead time for a make or buy item from preprocessing, fixed, variable and postprocessing days.

Oracle EBS Operation Yield and Start Quantity Calculator

Turn routing operation yields and component shrinkage into the start quantity and component requirement for a job.

Oracle EBS Average Cost Receipt and PPV Calculator

See how a PO receipt moves weighted average cost, and what the same receipt would book as PPV under standard costing.

Oracle EBS EOQ and Order Modifier Calculator

Compute economic order quantity, then apply minimum order quantity and fixed lot multiplier to see the order size MRP would plan and its cost impact.

Oracle EBS Cycle Count Workload Calculator

Enter item counts and count frequency per ABC class to see yearly counts, daily counts and the number of counters needed for an Oracle Inventory cycle count.

Oracle EBS Support End-Date Planning Calculator

Enter your support window and project phases to see the latest start date, the slack and the cost of running past the window.

Oracle EBS Tablespace Growth Forecast Calculator

Project compound growth of an EBS tablespace or database, find when it crosses an alert threshold and how much storage to add.

Oracle EBS Concurrent Manager Queue Wait Calculator

Model average queue wait and utilization for a concurrent manager queue as you change the number of target processes.

Oracle EBS Database Growth Forecast Calculator

Project EBS database size from monthly growth and a one-time purge, and see how many months of storage headroom remain.

Oracle EBS AP Early Payment Discount Calculator

Check whether taking an early payment discount on supplier terms beats your cost of funds, per invoice and per year.

Oracle EBS AR Aging Bad Debt Reserve Calculator

Apply loss rates to Oracle Receivables aging buckets to estimate the allowance for doubtful accounts and the reserve percentage.

Oracle EBS Fixed Asset Straight-Line Depreciation Calculator

Straight-line depreciation by life in months with salvage value, plus a net book value curve over the asset's life.

Oracle EBS Maintenance Window and Backup Time Calculator

Work out how long the outage needs to be, including a backup, the work itself, validation and a contingency buffer, and how long a rollback restore would take.

Oracle Fusion FBDI Load Time Estimator

Estimate the duration of a bulk data load from the record count, throughput, batch size and expected error rate.

Oracle Fusion Min-Max and Safety Stock Calculator

Work out the min and max quantities and safety stock to load into Oracle Fusion item organization attributes, with a lead time what-if chart.

Oracle Fusion EOQ and Fixed Lot Multiple Calculator

Compute the economic order quantity, round it to the supplier pack size, and see what the rounding costs per year.

Oracle Fusion Standard Cost Rollup Calculator

Estimate a one-level standard cost with yield loss, setup spread over lot size and overhead on labor, and sweep lot size to see the effect.

Oracle Fusion Manufacturing Lead Time Calculator

Estimate work order lead time from setup, run, queue and move, and derive fixed and variable lead time values per unit.

Oracle Fusion Kanban Card Calculator

Size a kanban loop: how many cards or containers you need for a given demand, replenishment time, container quantity and safety factor.

JD Edwards Batch Window Runtime Calculator

Estimate how long a JDE UBE will take from record volume, throughput and parallel runs, and test whether growth will break the batch window.

JDE UBE Batch Window Calculator

Model UBE elapsed time against your batch window as you add parallel queue slots, including a contention penalty for each extra slot.

JDE F0911 Table Growth Forecast Calculator

Project F0911 Account Ledger size over a horizon from daily documents, lines per document, row bytes, index overhead and annual volume growth.

JDE Standard Cost Roll-Up Per Unit Calculator

Sanity-check a rolled-up unit cost by building it from setup, run hours, labor and machine rates, overhead percent and scrap, then see how lot size moves it.

JDE HTML Web Server JVM Sizing Calculator

First-pass sizing of JDE web server JVM count from logged-in users, memory per session and heap, with an N+1 spare.

JDE Orchestrator API Concurrency Sizing Calculator

Convert peak calls per hour and average response time into concurrent requests, threads and JVM count, with a burst factor.

JD Edwards Julian Date Converter

Turn a calendar date into the CYYDDD Julian number JDE stores in tables such as F0911 and F4801, with leap years handled.

IBM i Power Hosting Cost Comparison Calculator

Compare the multi-year cost of keeping an IBM Power server on premises with moving IBM i to a hosted Power environment, including payback months.

JD Edwards World Custom Object Conversion Effort Calculator

Turn your count of custom RPG programs, DREAM Writer reports, screens and interfaces into build and test hours, cost and elapsed time.

IBM i Batch Window Capacity Calculator

Predict how many years of growth your nightly batch can absorb before it overruns the available window, and how much speedup you need.

AS/400 Disk Storage Growth Forecast Calculator

Estimate how many years of disk you have left on IBM i given data growth, journal receivers and your safe utilisation threshold.

IBM i Restore Time and RTO Calculator

Add up restore, journal apply and verification time for an IBM i recovery and compare it with your recovery time objective.

Reference tables

Oracle EBS Discrete Job Statuses Reference

Look up every Oracle WIP discrete job status, its numeric code, what transactions it allows and the usual next step.

Oracle EBS Inventory Transaction Types Reference

Quick lookup of common Oracle Inventory transaction types, their IDs, source types and effect on on-hand quantity.

Oracle EBS MRP Exception Messages Reference

What each Oracle MRP exception message means, why it appears and what a planner usually does about it.

Oracle EBS WIP Accounting Class Reference

Understand Oracle WIP accounting class types and which valuation and variance accounts each class uses.

Oracle EBS Inventory Tables Reference

Searchable lookup of the core Oracle EBS Inventory and Cost Management tables with purpose and key columns, for report writers and technical consultants.

Oracle EBS WIP Tables Reference

Lookup of Oracle EBS Work in Process tables with purpose and key columns, covering discrete jobs, operations, requirements, resources and interfaces.

Oracle EBS Concurrent Request Phase and Status Reference

Look up every common phase and status combination for a concurrent request, with what it means and the first thing to check.

Oracle EBS Profile Options Reference

A searchable lookup of the profile options EBS administrators change most: sign-on security, concurrent processing, multi-org, logging and session settings.

Oracle EBS Finance Tables Reference (GL, AP, AR, FA)

Lookup of the base tables behind General Ledger, Payables, Receivables, Fixed Assets, Subledger Accounting and Purchasing, with the columns you join on.

Oracle EBS Concurrent Managers and Settings Reference

What each standard concurrent manager and service does, and what the main tuning settings mean, in one searchable table.

Oracle Fusion Work Order Statuses Reference

Look up what each Oracle Fusion Manufacturing work order status means, what you can do in it, and which status usually comes next.

Oracle Fusion SCM Terminology vs EBS Reference

Look up Fusion SCM and Manufacturing terms and see the nearest EBS concept, so EBS veterans stop mistranslating setups.

Oracle EBS Module to Fusion Cloud Product Reference

See which Oracle Fusion Cloud product replaces each E-Business Suite module, with the key change to plan for.

JD Edwards Document Types Reference (OP, SO, OV, PV)

Searchable lookup of common JD Edwards document types such as OP, SO, OV and PV, with the module and the table that normally holds them.

JD Edwards Table Reference (F4211, F4311, F0101, F4101, F4102)

Quick lookup of common JD Edwards tables with description, module, column prefix and the key fields you join on.

JD Edwards EnterpriseOne Core Table Reference

Searchable list of the JD Edwards EnterpriseOne tables you query most often, with column prefix and the key fields to filter on.

JD Edwards System Codes Reference

Look up what each JD Edwards system code stands for and how it shows up in table, application and UDC names.

JD Edwards World Key File Reference Table

A searchable lookup of widely used JD Edwards World files with the module, purpose and key field prefix, useful for queries, reports and migration mapping.

IBM i System Values Reference

A searchable table of the IBM i system values that matter for security, date handling, job limits and startup, with the reason each one is checked.

IBM i CL Command Cheat Sheet

A searchable lookup of the CL commands operators and JDE World support staff use daily, grouped by task with a short note on each.

Oracle EBS Cost Management Tables Reference

A lookup of the Oracle EBS tables behind item cost, WIP jobs, BOM, routing and inventory transactions used in manufacturing costing.

Code and query generators

Oracle EBS On-Hand Reconciliation SQL Generator

Generate a SQL query that compares on-hand quantity to the net of material transactions for an organization, to spot unexplained differences.

Oracle EBS AP Invoice Interface Template

Fill in header and line values to get insert statements for the Payables open interface tables, ready to adapt for your conversion or integration.

Oracle EBS SQL for Concurrent Requests Generator

Build ready-to-run SQL for recent, running, pending and long-running concurrent requests from a few filter fields.

Oracle EBS AP Invoices on Hold SQL Generator

Fill in operating unit, lookback days and optional hold code to get ready-to-run SQL for unreleased holds in Oracle Payables.

Oracle EBS User and Responsibility Audit SQL Generator

Fill in a user and responsibility pattern and get ready-to-run queries for active user access, administrator access and duplicate access reviews.

Oracle EBS Inactive User Cleanup SQL Generator

Set a number of idle days and generate queries to list inactive users, expiring passwords, and a reviewed script to disable them.

Oracle EBS GL Open Journals and Period Status SQL Generator

Enter a ledger and period and get queries to see period status, unposted journals, stuck import rows and subledger entries not yet in the GL.

Oracle Fusion SCM BI Publisher SQL Query Generator

Fill in organization, item and BU filters and get starter SQL for item, on-hand and open PO data models.

JD Edwards Julian Date (CYYDDD) SQL Converter

Build SQL that converts the CYYDDD Julian dates stored in JD Edwards files into real dates, converts a date back, and filters by date range.

Checklists

Oracle EBS Inventory Period Close Checklist

A step-by-step checklist for closing the Oracle Inventory accounting period, including WIP, receiving and cost transactions.

Oracle EBS Discrete Manufacturing Go-Live Checklist

A grouped go-live checklist for Oracle Inventory, BOM, WIP and Cost Management covering setup, data, testing and cutover for discrete manufacturers.

Oracle EBS GL Period Close Checklist

A month-end close sequence for Oracle General Ledger and the subledgers that feed it, with critical steps marked.

Oracle EBS 12.2 Upgrade Readiness Checklist

Check whether your EBS environment, custom code and team are ready to move to Release 12.2 and what to settle before the project starts.

Oracle EBS Patching Checklist for adop

Step through a full adop patching cycle with pre-checks, the five phases and post-patch validation.

Oracle EBS Rapid Clone Checklist

Step-by-step checklist for cloning an EBS instance with Rapid Clone, including the post-clone scrubbing that protects production data and integrations.

Oracle Fusion Supply Planning Checklist

Work through plan setup, data collection, item and sourcing attributes, plan runs and exception review for Fusion Supply Planning.

Oracle Fusion Quarterly Update Test Checklist

A step-by-step regression checklist for each Oracle Fusion Cloud quarterly update, from release notes review to production sign-off.

Oracle Fusion Manufacturing Cutover Checklist

A grouped cutover checklist for moving a plant onto Oracle Fusion SCM and Manufacturing, with critical items marked.

JD Edwards Tools Release Upgrade Checklist

A phased checklist for moving JD Edwards EnterpriseOne to a newer tools release, from certification checks to post-cutover monitoring.

JD Edwards CNC Environment Health Check Checklist

A weekly or monthly checklist for JDE CNC admins covering servers, web tier, database, batch processing, security and backups.

JD Edwards Package Build and Deployment Checklist

Step-by-step checklist for building and deploying JDE packages: pre-build checks, build, deployment, verification and rollback.

IBM i OS Upgrade Readiness Checklist

A grouped checklist covering planning, backup, compatibility, the upgrade weekend and validation for an IBM i operating system upgrade.