William A. Green Jr., Oracle EBS Consultant and founder of William Delaney Consulting

Oracle EBS Consultant  ·  William Delaney Consulting

Oracle EBS Data Fix Library

Diagnostic SQL tools and documented data fix cases built from 27 years of Oracle Financials consulting. Covering Accounts Payable, Receivable, General Ledger, Fixed Assets, Purchasing, Subledger Accounting, and more — tested across Oracle EBS 11i and R12 in Fortune 500 and government environments.

27+
Years Oracle EBS
144
Diagnostic Scripts
75
Data Fix Cases
12+
EBS Modules
11i + R12
Versions Covered
🔍
Diagnostic SQL Tools
144 scripts across 12+ Oracle EBS modules

Run targeted SQL diagnostic scripts against your Oracle EBS database to quickly surface invoice errors, accounting mismatches, unposted transactions, and data corruption — before they become escalated issues. Organized by module and EBS version for fast lookup.

  • Covers AP, AR, GL, FA, PO, CE, INV, XLA, WF, FND, and more
  • Separate scripts for Oracle R12 and 11i environments
  • Invoice, payment, supplier, journal, and receipt diagnostics
  • Search and filter by module, version, or keyword
  • Includes supplier merge, multi-currency, and subledger queries
Browse Diagnostic Tools →
📄
Data Fix Case Library
75 documented cases with SQL fix scripts

75 fully documented data fix cases from real Oracle EBS client engagements. Each case includes problem symptoms, root cause analysis, affected database tables, and validated SQL fix scripts — ready to review and adapt for your environment.

  • AP, AR, GL, FA, PO, XLA, IBY, PA, and INV coverage
  • Single-script and multi-phase fix approaches
  • Root cause analysis and key tables per case
  • Covers Oracle EBS R12 and 11i
  • Search by module, release, or symptom keyword
Browse Data Fix Cases →
Workflow

How to Use This Library

Each resource in the library follows the same structured approach — from diagnosis through resolution.

01
Run a Diagnostic
Use the Diagnostic Tools to identify the scope and nature of the issue in your Oracle EBS database — whether it's incorrect amounts, missing records, or stuck processes.
02
Match a Case
Search the Data Fix Case Library by module, EBS version, or keyword. Each case documents real symptoms and root cause analysis from production environments.
03
Review the Fix
Each case includes step-by-step resolution instructions, the key Oracle EBS tables affected, and backup/rollback procedures before any data change.
04
Apply and Validate
Adapt the validated SQL fix scripts for your specific environment. Post-fix validation queries are included to confirm the data is in the correct state.
Coverage

Oracle EBS Modules Covered

The diagnostic tools and data fix cases span the following Oracle E-Business Suite Financials and distribution modules, validated across versions 10.7, 11i, R12.1.3, and R12.2.4.

AP
Accounts Payable
Invoices, payments, suppliers, distributions, PO matching, holds
AR
Accounts Receivable
Cash receipts, applications, transactions, adjustments, distributions
GL
General Ledger
Journal entries, period close, balances, CCID corrections, transfers
FA
Fixed Assets
Depreciation, GL transfer, asset books, override amounts, batch IDs
PO
Purchasing
Purchase orders, receipts, accrual reconciliation, billed quantities
XLA
Subledger Accounting
AE lines, events, headers, distribution links, GL transfer status
CE
Cash Management
Bank statements, reconciliation, accounting errors, bank accounts
INV
Inventory
GL interface rows, material transactions, account batch IDs
IBY
iPayments
External bank accounts, credit cards, duplicate account cleanup
PA
Project Accounting
Draft invoices, project billing item amounts, invoice dates
WF
Workflow
Approval workflows, stuck notifications, process management
FND
Oracle Foundation
Concurrent programs, system profiles, user and access diagnostics
William A. Green Jr., founder of William Delaney Consulting

William A. Green Jr.

Oracle EBS Consultant  ·  Founder, William Delaney Consulting

A former U.S. Marine with 27+ years in Oracle E-Business Suite, William began his Oracle career in 1997 as a Business Analyst before founding William Delaney Consulting in 2000, specializing in Oracle Financials implementations and data fix engagements for Fortune 500 companies and government entities. He holds an Accounting degree from Alabama State University (Magna Cum Laude, 1992).

This library is the product of years of hands-on diagnostic and data correction work in production Oracle EBS environments. Every script and case reflects a real problem solved — spanning Oracle EBS versions 10.7, 11i, R12.1.3, and R12.2.4. Technical toolkit includes PL/SQL, SQL*Plus, SQL Developer, TOAD, Oracle Reports, and Workflow Builder.

Oracle EBS 10.7 / 11i / R12 PL/SQL & SQL*Plus Oracle Financials Subledger Accounting (XLA) EBTax (ZX) Data Migration Custom Reporting Workflow Builder SQL Developer & TOAD
Notable Clients
Delta Motorola CSX U.S. Air Force BAE Systems
Contact
📞 (949) 439-4730 ✉ wagreen@william-delaney.com