A complete library of production-ready diagnostic scripts for Oracle EBS R12.x and Oracle Fusion Cloud. Every script diagnoses, fixes, backs up, and documents — automatically.
Every script in this library — regardless of module or platform — operates on the same four-layer model. This is not just a collection of SQL queries. It is a governed, self-documenting remediation system.
CONS_BACKUP schema. Tables are named ap_invoices_all_784528 — the table name plus your case number. A central FIX_BACKUP_REGISTRY tracks every backup ever taken. A rollback script is generated automatically.The AI platform runs these same 65 scripts autonomously — interprets results with an LLM, searches the knowledge base for prior resolutions, routes governed fixes through a human approval framework, and updates the knowledge base on resolution.
Filter by platform, module, and fix capability. Search by keyword. Every script links to a full detail page with sample output, backup architecture, and knowledge base examples.
Full validation analysis for a single invoice — header integrity, amount reconciliation, distributions, PO matching, tax, holds, and accounting pre-check. Diagnoses every condition that can cause NEEDS REVALIDATION status.
View Details →Diagnoses payment batch failures — bank account validity, payment document setup, EFT configuration, void and stop payment flags, and batches stuck in FORMATTING or CONFIRMING status.
View Details →Complete vendor master health check — active status, site configuration, bank accounts, payment terms, 1099 setup, holds, and duplicate supplier detection across TCA.
View Details →Analyzes all matching tolerance controls and identifies invoices at or beyond quantity, price, amount, and exchange rate tolerance thresholds. Root causes QUANTITY MISMATCH, PRICE, and AMOUNT holds.
View Details →Pre-close readiness scan covering unvalidated invoices, unaccounted transactions, open holds, unposted cash, sweep candidates, SLA event errors, and period status across all ledgers.
View Details →Inventory of all holds across a date range — aging, hold type breakdown, top vendors by hold count, repeat hold patterns, and resolution path guidance for every hold type.
View Details →Fusion Cloud invoice diagnostics via OTBI, REST API, and BIP — validation error summary, interface rejection detail, ESS job history for Import Payables Invoices, and guided resolution navigation.
View Details →Fusion supplier diagnostics via REST API and OTBI — active status, site configuration, payment method, bank account completeness, workflow task backlog for supplier amendments.
View Details →Full validation of AR invoices and credit memos — header integrity, line amounts, tax lines, revenue distribution accounts, payment terms, batch status, and duplicate transaction detection.
View Details →Diagnoses all errors in RA_INTERFACE_ERRORS_ALL — invalid transaction types, currencies, GL dates, UOMs, duplicate numbers, missing flexfield values, and orphaned interface records.
View Details →Receipt status analysis, unapplied and misapplied payment detection, lockbox import errors, remittance batch status, on-account credit aging, and cross-currency receipt validation.
View Details →Customer master health check — active status, site uses, payment terms, credit limits, dunning configuration, duplicate detection via TCA, and open debit/credit analysis.
View Details →Comprehensive pre-close scan — unposted receipts, unaccounted transactions, incomplete batches, unrun revenue recognition, open interface records, and pending adjustment approvals.
View Details →Diagnoses revenue scheduling rules, deferred revenue balances, unrecognized lines, contingency flags, invoicing vs. accounting rule alignment, and VSOE/SSP allocation setup.
View Details →Fusion AutoInvoice diagnostics via OTBI and BIP — error summary by type and batch source, ESS job history for Import AutoInvoice, and guided resolution navigation paths.
View Details →Fusion AR close readiness via OTBI, REST API, and ESS job history — unposted receipts, unaccounted transactions, revenue recognition completeness, and Transfer to GL status.
View Details →Diagnoses all GL_INTERFACE errors — invalid accounts, closed periods, unbalanced journals, invalid sources/categories, missing flexfield segments, and orphaned interface groups.
View Details →Master period close diagnostic — all subledger status (AP, AR, FA, PO, INV, PA), unposted journals, XLA accounting errors, intercompany imbalances, revaluation, and consolidation readiness.
View Details →Identifies disabled CCIDs in open transactions, summary account misuse, cross-validation rule violations, incorrect account types, and orphaned combinations with no recent activity.
View Details →Detects intercompany journal imbalances, missing due-to/due-from entries, account setup gaps, unmatched trading partner entries, and elimination set completeness for consolidation.
View Details →Revaluation run status, unrevalued foreign currency balances, gain/loss account setup, prior period revaluation errors, reversal completeness, and exchange rate availability.
View Details →Consolidation mapping completeness, translated balance status, elimination set setup, consolidation workbench errors, subsidiary close alignment, and COA mapping gaps for new accounts.
View Details →Fusion GL close readiness via OTBI, BIP, REST, and ESS — unposted journals, clearing account balances, journal batch status, intercompany imbalances, and Close Ledger job history.
View Details →Fusion journal import diagnostics — ESS job error history, BIP interface rejection detail, REST journal batch validation status, and unposted journal aging by source.
View Details →Asset record completeness, CIP vs. capitalized classification, category setup, depreciation method and prorate convention, asset book assignment, and mass additions queue health.
View Details →Depreciation run status, assets with unexpected zero depreciation, fully reserved assets still depreciating, negative NBV detection, prior period adjustments, and calendar alignment.
View Details →Retirement transaction status, gain/loss account setup, NBV calculation accuracy, partial retirement proportions, reinstatement history, and retirement date vs. depreciation period alignment.
View Details →Pre-close scan — depreciation run completion, unfinished mass additions, pending retirements, unreconciled asset cost to GL, CIP capitalization events, and tax book alignment.
View Details →Complete mass additions queue health — counts by status, AP distribution linkage, category auto-assignment accuracy, duplicate detection, split/merge candidates, and ON HOLD record resolution.
View Details →PO header, line, shipment, and distribution integrity — approval status, vendor and site validity, distribution CCID validation, encumbrance status, funds check, and change order history.
View Details →Workflow item status, stuck notifications, approver account validation, AME rule setup, position hierarchy gaps, timeout analysis, and notification mailer delivery status.
View Details →Receipt header and line status, routing configuration, over-receipt tolerances, uninspected and undelivered receipts, transaction interface errors, and receiving account setup validation.
View Details →Encumbrance journal status, funds available vs. committed analysis, over-encumbered distributions, reserve for encumbrance account setup, and year-end carry-forward completeness.
View Details →Uninvoiced receipts for accrual, unmatched PO receipts, open POs past need-by date, pending change orders, unprocessed receiving transactions, and encumbrance liquidation completeness.
View Details →Fusion PO approval diagnostics via OTBI workflow task backlog, REST BPM task API, BIP approval routing detail, and ESS notification delivery history with escalation guidance.
View Details →Fusion PO diagnostics via REST API and OTBI — approval state, funds check result, lines with exceptions, distribution account validity, and ESS import job history.
View Details →Pending and errored transactions in MTL_MATERIAL_TRANSACTIONS_TEMP, costing failures, lot/serial control violations, locator issues, and negative quantity creation detection.
View Details →Cost update status, pending cost transactions, standard vs. actual variances, average cost layer imbalances, overhead rate validity, and purchase price variance analysis.
View Details →Item attribute completeness across all functional groups, UOM validity, category assignment, organization assignment status, lot/serial control consistency, and planner/buyer assignment.
View Details →Pending and uncosted transaction counts, open cycle count entries, unprocessed physical inventory adjustments, interface record aging, and cost update completion status.
View Details →Reorder rule completeness, items below minimum quantity threshold, pending requisitions from planning, lead time validity, sourcing rule completeness, and safety stock analysis.
View Details →Order header and line status, all holds with root cause, workflow activity status per line, pricing completeness, credit check analysis, inventory reservation, and ATP availability.
View Details →Complete holds inventory — aging, hold type breakdown, credit hold root cause, payment term holds, manual holds, repeat hold patterns, and resolution path for every hold definition.
View Details →Delivery line status, pick release errors, subinventory availability, backorder analysis, ship confirm prerequisites, freight carrier setup, and document generation status.
View Details →OE_PROCESSING_MSGS analysis — header and line errors grouped by type, invalid customers/order types/price lists, duplicate order numbers, credit failures, and batch completion status.
View Details →AutoInvoice interface status for shipped lines, workflow activity at INVOICE INTERFACE, interface errors, revenue trigger, transaction type mapping, and RMA credit memo generation.
View Details →Work order status, BOM and routing validity, component and resource availability, cost completeness, scrap account setup, outside processing PO linkage, and quantity reconciliation.
View Details →Pending WIP cost transactions, variance account setup, resource rate validity, overhead absorption, earned vs. applied variance analysis, and WIP-to-GL accounting entry completeness.
View Details →Open WOs past scheduled completion, uncosted transactions, pending move transactions, incomplete assemblies, outside processing receipts, and variance calculation completeness.
View Details →Expenditure item status, burdening setup, billing hold analysis, uncosted and undistributed items, GL interface status, project and task status, and cross-charge routing.
View Details →Draft invoice status, billing hold reasons, revenue recognition status, funding balance, agreement validity, billing cycle setup, event completeness, and retention tracking.
View Details →Uncosted and undistributed items, un-interfaced revenue and costs to GL, unbilled receivables aging, open billing events, ungenerated invoices, and burden batch processing status.
View Details →Assignment status, grade/step validity, payroll assignment, cost center allocation (must sum to 100%), position setup, future-dated changes, termination status, and organization hierarchy.
View Details →Payroll action and assignment action errors, element entry validity, Fast Formula compilation status, costing CCID validation, bank account completeness, and retropay trigger status.
View Details →Fusion payroll diagnostics via OTBI, REST HCM API, and BIP — run action status, error counts, assignment action detail, ESS job history for Calculate Payroll and Prepayments.
View Details →Fusion worker diagnostics via REST API and OTBI — assignment status, future changes, employment terms completeness, costing validity, and Synchronize Person Records ESS job history.
View Details →Fusion absence diagnostics via OTBI and REST — plan balances, accrual errors, absence request status, negative balances, eligibility rule completeness, and Calculate Accruals ESS history.
View Details →Manager status and work shifts, stuck and long-running requests, queue capacity analysis, top failure patterns, ICM status, and processing node availability for parallel managers.
View Details →Stuck workflow items, error activities, deferred queue depth, agent listener status, notification mailer configuration, purge readiness, and high-volume item type backlog analysis.
View Details →Top SQL by elapsed time/CPU/IO, active and blocking sessions, current lock contention, buffer cache hit ratio, redo log switches, tablespace usage, and top database wait events.
View Details →Row counts and aging across all major interface tables — GL, AP, AR, PO, INV, OM, PA, WIP, FA. Identifies orphaned records older than 30, 60, and 90 days across all modules in one pass.
View Details →Long-running, errored, and blocked ESS jobs via OTBI and REST. Python trend analysis for 30-day P90/P95 duration baselines. Dependency chain analysis and automated alerting setup.
View Details →Inbound and outbound integration job history, payload error detail via BIP, message volume trends, OIC console navigation guidance, and programmatic health check REST scripts.
View Details →User-responsibility mapping, expired accounts, orphaned grants, menu function exclusions, profile option conflicts at all levels, operating unit access setup, and password policy compliance.
View Details →Fusion security diagnostics via REST Identity API and OTBI — role assignments, dormant user detection, SOD conflict analysis, Data Security Policy completeness, and HCM Security Profile validity.
View Details →Contact William A. Green Consulting to discuss access to the complete script library and how it can be deployed in your Oracle environment.