Free Oracle tools
210 templates, calculators, worksheets and reference tables. Each runs in your browser and exports to PDF, Excel, Word or CSV.
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.
Oracle EBS 12.2 Private AI Layer Blueprint Generator
Fill in your Oracle EBS 12.2 version, database, hosting and users to get a shareable architecture plan for a private, on-prem AI assistant.
JD Edwards EnterpriseOne Private AI Layer Blueprint Generator
Fill in your JD Edwards EnterpriseOne version, database, hosting and users to get a shareable architecture plan for a private, on-prem AI assistant.
JD Edwards World Private AI Layer Blueprint Generator
Fill in your JD Edwards World version, database, hosting and users to get a shareable architecture plan for a private, on-prem AI assistant.
Oracle PeopleSoft Private AI Layer Blueprint Generator
Fill in your Oracle PeopleSoft version, database, hosting and users to get a shareable architecture plan for a private, on-prem AI assistant.
Hyperion and Essbase Private AI Layer Blueprint Generator
Fill in your Hyperion and Essbase version, database, hosting and users to get a shareable architecture plan for a private, on-prem AI assistant.
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.
Oracle EBS 12.2 AI Assistant Sizing and Value Calculator
Estimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on Oracle EBS 12.2.
JD Edwards EnterpriseOne AI Assistant Sizing and Value Calculator
Estimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on JD Edwards EnterpriseOne.
JD Edwards World AI Assistant Sizing and Value Calculator
Estimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on JD Edwards World.
Oracle PeopleSoft AI Assistant Sizing and Value Calculator
Estimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on Oracle PeopleSoft.
Hyperion and Essbase AI Assistant Sizing and Value Calculator
Estimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on Hyperion and Essbase.
Oracle EBS 12.2 adop Patch Cycle Downtime Calculator
Estimate how long a 12.2 adop cycle runs, how much of it users actually lose at cutover, and how that compares with applying the same patches in downtime mode.
Oracle EBS 12.1.3 to 12.2 Upgrade Downtime Estimator
Turn the timings from your mock upgrade into a production cutover window for a 12.1.3 to 12.2.x upgrade, with contingency and a database-size sweep.
Oracle EBS On-Premises vs OCI/AWS/Azure Hosting Cost Calculator
Compare the infrastructure cost of running an EBS 12.2 estate in your data centre against a public cloud, using your own vCPU and storage prices.
Oracle EBS 12.2 Custom Code Remediation Effort Calculator
Estimate the hours, cost and weeks needed to make custom objects online-patching compliant and retested for EBS 12.2.
Oracle EBS 12.2 Disk Space Calculator (fs1, fs2, fs_ne and Database)
Size application and database tier storage for EBS 12.2, including both file system editions, fs_ne, staging, growth and backups.
Oracle EBS Critical Patch Update (CPU) Annual Effort Calculator
Estimate the annual hours, cost and production downtime of applying Oracle CPU patches to EBS, by cycle frequency and number of environments.
Oracle EBS Concurrent Request Purge Retention and Disk Calculator
Estimate how much disk the concurrent request log and output files use, and how large FND_CONCURRENT_REQUESTS stays, for a given Purge Concurrent Request and/or Manager Data (FNDCPPUR) Age value.
JD Edwards EnterpriseOne 9.2 Upgrade Retrofit Effort Calculator
Estimate retrofit and test hours, cost and duration for a JD Edwards EnterpriseOne upgrade to 9.2 from your counts of modified objects, and see how much replacing mods with UDOs saves.
PeopleSoft Application Engine Trace Flag Calculator (-TRACE value)
Turn trace options on and off to get the -TRACE, -TOOLSTRACESQL and -TOOLSTRACEPC values for an Application Engine run, as documented in PeopleBooks.
Oracle Essbase BSO Block Size and Database Size Calculator
Enter stored member counts for dense and sparse dimensions and get block size, block counts and estimated .pag and .ind sizes for a block storage cube.
Oracle Essbase Index, Data File and Data Cache Sizing Calculator
Enter the total size of your .ind and .pag files and available memory to get recommended index cache, data file cache and data cache settings for a BSO database.
Oracle Database 19c SGA, PGA and HugePages Sizing Calculator for ERP
Split server RAM into SGA and PGA for an Oracle 19c ERP database on Linux, see the default PGA_AGGREGATE_LIMIT and get the HugePages count.
Oracle Database 19c Online Redo Log Size Calculator
Turn your peak redo rate into a redo log size, switches per hour, redo disk footprint and daily archive log volume for Oracle 19c.
Oracle Database 19c Release Update Gap and Patch Window Calculator
Enter your current and target 19c Release Update to see the gap, the release quarter and an estimated patch window for in-place or out-of-place patching.
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.
Oracle EBS Employee, HR and Projects Tables Reference
Lookup of the EBS base tables for employees, assignments, organizations and Oracle Projects, with the key columns and joins you need for reports.
Oracle EBS ER Diagram: Key Table Relationships
Parent and child table pairs with the exact join columns for the Oracle EBS purchasing, WIP, BOM, routing and inventory data models.
Oracle EBS Customer and Supplier Tables Reference
Searchable list of the Trading Community Architecture customer tables and the supplier tables in Oracle EBS, with keys, join columns and where to confirm in the eTRM.
Oracle EBS HR API List (HRMS Public APIs)
A searchable reference of common Oracle EBS HRMS public API packages with their purpose, key parameters and notes, plus a PL/SQL call example.
Oracle Fusion Manufacturing Tables Reference
A searchable list of the main Oracle Fusion Manufacturing tables for work orders and work definitions, with purpose, key columns and join notes for BI Publisher reports.
Oracle Fusion Supplier and Organization Tables Reference
A reference for the Oracle Fusion supplier table, organization tables, and the FBDI interface and error tables used when supplier loads fail.
Oracle Fusion Table Names Reference for SCM and Financials
A searchable reference of widely used Oracle Fusion SCM and Financials table names with what each holds and the keys to join on.
Oracle EBS Order Management Tables Reference (OE, WSH, Order Import)
The OE_ and WSH_ tables behind a sales order in EBS 12.1/12.2, with primary keys, join columns and the order import error tables.
Oracle EBS Purchasing and Receiving Tables Reference (PO, REQ, RCV)
PO, requisition, release, receiving, archive and open interface tables for EBS 12.1/12.2, with keys, joins and status columns.
Oracle EBS Workflow Tables Reference (WF_ITEMS, WF_NOTIFICATIONS)
The Oracle Workflow runtime, definition, directory and queue tables in EBS 12.1/12.2, with the columns you query to find errored and stuck items.
Oracle EBS Application Object Library (FND) Tables Reference
The AOL FND_ tables for applications, users, responsibilities, menus, functions, concurrent processing, messages and profiles in EBS 12.1/12.2.
Oracle EBS Open Interface Tables, Import Programs and Error Tables Reference
Each EBS 12.1/12.2 open interface table mapped to the concurrent program that loads it, the status column to check and where the errors land.
Oracle EBS 12.2 File System, Log Locations and Control Scripts Reference
Where things live in an EBS 12.2 install: environment variables, every log you need to find and the start/stop scripts, with 12.1 equivalents.
Oracle EBS 12.2 adop Phases and Options Reference
Every adop phase, apply mode and common option in EBS 12.2 online patching, with example commands, whether it needs downtime and the traps to avoid.
Oracle EBS Multi-Org Structure Tables and MO_GLOBAL Reference
Searchable map of the R12 org hierarchy: GL_LEDGERS, XLE legal entities, HR_OPERATING_UNITS, ORG_ORGANIZATION_DEFINITIONS, MOAC profiles and the MO_GLOBAL calls that make secured synonyms return rows.
Oracle EBS Lookups, Value Sets and Flexfield Tables Reference
Every FND table and view you need to decode lookup codes, value set values, table-validated value sets, key flexfield segments and DFF ATTRIBUTE columns in EBS 12.1 and 12.2.
Oracle EBS Advanced Pricing (QP) Price List Tables Reference
The QP tables behind price lists, modifiers, qualifiers and formulas in EBS 12.1 and 12.2, with join keys, code values, the bulk loader interface and a ready SQL to find an item's list price.
Oracle EBS GL_INTERFACE Journal Import Error Codes Reference
Decode every common Journal Import Execution Report error code, see which GL_INTERFACE columns cause it and how to fix it, for EBS R12.
JD Edwards F4211 vs F42119 Sales Order Detail and History Columns Reference
Column-by-column reference for the JDE 9.2 sales order family: F4201 header, F4211 detail, F42119 and F42019 history and the F42199 detail ledger, with keys, data types and storage notes.
JD Edwards Inventory Tables Reference (F41021, F4111, F4105, F4108, F4100)
Reference for the JDE 9.2 inventory tables with key columns, the programs that maintain them, joins, and one row per F41021 quantity bucket explaining what drives it.
JD Edwards EnterpriseOne System and Object Librarian Tables Reference
The system, Object Librarian, Central Objects and Versions tables a CNC admin or developer queries most on 9.2, with key columns and the question each one answers.
JD Edwards EnterpriseOne 9.2 Tools Release History Reference
Tools releases of EnterpriseOne 9.2 with their Release 22 to 26 names, update months, headline tools features and certifications, plus how to check which tools release you run.
JD Edwards AAI and DMAAI Reference (F0012, F4095)
The financial AAIs (F0012) and distribution/manufacturing AAIs (F4095) that cause most posting questions in JDE 9.2, with the program that uses each and a typical setup mistake.
JD Edwards AP and AR Ledger Tables Reference (F0411, F0413, F0414, F03B11, F03B13, F03B14)
Keys and working columns for the JDE 9.2 payables and receivables ledgers, payment and receipt tables, batch input tables and the supplier and customer contact tables.
JD Edwards Security Tables and Security Types Reference (F00950, F95921, F9312)
The JDE 9.2 security tables with their real columns, plus the Security Workbench security types, what each controls and the precedence rules that trip people up.
JD Edwards Sales Order Status Codes and Order Activity Rules Reference (F40203)
The typical SO / S status flow in JDE 9.2, the program that advances each step, special statuses such as 904 and 914, and the F40203 columns behind the rules.
PeopleSoft PeopleTools Metadata Tables Reference (PSRECDEFN, PSRECFIELD, PSPNLDEFN)
Searchable reference of the PeopleTools system tables that store record, field, page, component, PeopleCode, SQL, translate, message, query, project and portal definitions.
PeopleSoft PeopleCode Events and Firing Order Reference
A searchable table of PeopleCode events in component processor order, showing where each event is defined, what it is for, whether Error and Warning are appropriate, and common mistakes.
PeopleSoft Process Scheduler RUNSTATUS and Report Manager Tables Reference
Decode PSPRCSRQST run statuses, read distribution statuses, and find the Process Scheduler and Report Manager tables to query when a report will not post.
PeopleSoft Integration Broker Tables and Message Status Reference
Find the Integration Broker tables behind the asynchronous and synchronous monitors, what each message status means, and what to do about errors, retries and growth.
Oracle Essbase Data Load and Dimension Build Error Codes Reference
Look up Essbase message numbers from data loads, outline builds, calcs and sessions with the message text, likely cause and a practical fix.
Oracle Essbase Calculation Functions Reference (@ Functions)
A searchable reference of the Essbase block storage @ functions used in calc scripts, member formulas and business rules, with syntax, return type, example and performance note.
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.
Oracle EBS HRMS Employee Table Query Generator
Generates a current-employee query over PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, organizations, jobs and supervisors with the date-track filters done right.
Oracle Fusion Suppliers Table Report SQL Template
Fill in a few fields to generate a BI Publisher SQL query that reports Oracle Fusion suppliers and their sites, with notes on supplier import templates.
Oracle EBS AR Aging Buckets SQL Generator
Generates a 7-bucket receivables aging query by customer account and an open-item detail query from AR_PAYMENT_SCHEDULES_ALL, with your bucket boundaries and as-of date.
Oracle EBS GL Balances and Code Combination SQL Generator
Generates a trial balance query joining GL_BALANCES, GL_CODE_COMBINATIONS_KFV and GL_LEDGERS, a segment description query, and a PL/SQL CCID lookup.
Oracle EBS Procure-to-Pay (P2P) SQL Generator: PO to Receipt to Invoice to Payment
Generates a detail query tracing PO distributions through receipts, AP invoice distributions and payments, a non-duplicating summary per distribution, and a supplier statement.
Oracle EBS Order-to-Cash (O2C) SQL Generator: Order to Delivery to Invoice to Receipt
Build a query that follows each Order Management line through Shipping, Receivables invoicing and cash application in Oracle EBS R12.
Oracle EBS Patch Level, Applied Patches and Version SQL Generator
Generate the queries to find the EBS release, whether bugs are applied, recent patch runs, adop session status, 12.2 code levels and product patch levels.
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.
Oracle EBS Concurrent Manager Not Starting Troubleshooting Checklist
A step-by-step checklist for EBS 12.1 and 12.2 when the Internal Concurrent Manager or standard managers will not start.
Oracle EBS Workflow Notification Mailer Troubleshooting Checklist
A grouped checklist for EBS 12.1 and 12.2 when workflow notification emails stop going out, arrive late or responses are not processed.
Oracle EBS 12.2 Forms Not Launching Troubleshooting Checklist (Java, JWS, Browsers)
Work through client launch method, Java, server tier, profiles and post-patch steps to find why Oracle EBS Java forms will not open.
Oracle EBS 12.2 Database Upgrade to 19c Checklist
A step checklist for upgrading the Oracle E-Business Suite 12.2 database to 19c, organised around the interoperability note and the multitenant requirement.
Oracle EBS 12.2.x Release Update Pack (RUP) Upgrade Checklist
Plan and run an Oracle EBS 12.2.x Release Update Pack upgrade with adop, from ETCC and AD/TXK delta to cutover and regression tests.
Oracle EBS Lift-and-Shift to OCI Readiness Checklist (EBS Cloud Manager)
Check eligibility, OCI network design, backup transfer, provisioning and post-move tasks before moving on-prem Oracle EBS to OCI with EBS Cloud Manager.
Oracle EBS Patch Impact Analysis Checklist (Patch Wizard and Customizations)
Analyse what an Oracle EBS patch will change, which customizations it touches and how you will test and roll back, before you apply it.
Oracle EBS 12.2 Installation Checklist (Rapid Install on Oracle Linux)
A step checklist for a fresh Oracle EBS 12.2 install on Oracle Linux: media download, stage area, OS preparation, Rapid Install, post-install patching and hardening.
JD Edwards Orchestrator Error Handling and Production Readiness Checklist
Check an EnterpriseOne orchestration before it goes live: what happens when a step fails, who it runs as, how it is monitored and scheduled, and how it is promoted.
JD Edwards EnterpriseOne 9.0 / 9.1 to 9.2 Application Upgrade Checklist
A step-by-step checklist for an EnterpriseOne application upgrade from 9.0 or 9.1 to 9.2, from planning and table conversions to retrofit, packages and go/no-go.
PeopleSoft PeopleTools-Only Upgrade Checklist (8.5x to 8.61/8.62)
A step by step checklist for a PeopleTools-only upgrade with DPK and Change Assistant, from certifications to rollback, with the critical steps marked.
PeopleSoft PUM Update and Change Package Checklist
Step through a PeopleSoft Update Manager cycle: update image, change package definition, compare reports, retrofit, apply to each environment and test.
Oracle Agile PLM 9.3.6 Installation and Upgrade Checklist
A step-by-step checklist for installing Agile PLM 9.3.6 or upgrading from an earlier 9.3.x release, from certified stack checks to post-install smoke tests.
Oracle Database 12c to 19c Upgrade Checklist for ERP Databases
A 41 item checklist for upgrading a JD Edwards, E-Business Suite or PeopleSoft database from 12c to 19c, with the critical steps marked.
Oracle Database 19c Security Hardening Checklist for ERP
A 37 item hardening checklist for Oracle Database 19c under an ERP: accounts, privileges, network, unified auditing, data protection and patching.
Assessments
Oracle EBS Inventory Accuracy Readiness Assessment
A 10 question self-assessment of inventory accuracy practices in an Oracle EBS environment, scored with recommended next steps.
Oracle EBS Instance Health Assessment
A 10-question self-assessment that scores how well your EBS instance is run and points to the first areas to fix.
Oracle Fusion SCM Implementation Readiness Assessment
Ten questions that show whether data, process, integration and people are ready for a Fusion SCM implementation.
AS/400 Skills Succession Risk Assessment
Eight questions on staffing, documentation and knowledge concentration to score how exposed your IBM i environment is to losing key people.
Oracle EBS 12.2 Security Hardening Assessment
Answer 14 questions about patching, configuration, accounts, network and auditing to see how hardened your Oracle EBS 12.2 instance is.
Oracle EBS 12.2 Stay on Premises or Move to Fusion Cloud Assessment
Thirteen questions that point to staying and modernising on EBS 12.2, a hybrid split, or planning a full Fusion Cloud migration.
Oracle Agile PLM End of Life and Cloud PLM Migration Readiness Assessment
Ten questions on your Agile PLM release, process extensions, event handlers, integrations, vault and data quality, scored into a readiness band with next steps.