Blitz Report™ Toolkits

Database health and AWR tuning

The standard AWR reports are difficult to read. Blitz Report combines the AWR data with EBS information, for example the package and code line behind an under-performing SQL, in easy to read Excel analysis.

• DBA AWR SQL Performance Summary
• DBA AWR Wait Event Summary
• DBA SGA SQL Performance Summary
• DBA Blocking Sessions

All 77 reports

A simpler way to work with AWR

Concurrent request and workflow monitoring

Excel based alerts for critical processes such as integrations and concurrent requests: scheduled reports email the exceptions, delivering results quickly and efficiently.

• FND Concurrent Requests
• FND Concurrent Requests Summary
• WF Queue Backlog
• FND SOA Runtime Error

All 14 reports

Concurrent request monitoring and alerts

Audit, data governance and access

Track setup and master data changes, such as a billing address or bank account, with the standard EBS audit functionality, without licensing the GRC module. Review who can access what.

• FND Audit Table Changes by Column
• FND Audit Table Changes by Record
• FND User Responsibilities
• FND User Login History

All 59 reports

Track master data changes with EBS audit

Setup extracts, patches and upgrades

BR100 style setup extracts for documentation and migration, profile options and flexfields, and the patch level of each environment for upgrade projects.

• FND Profile Option Values
• FND Descriptive Flexfields
• AD Applied Patches R12.2
• AD ADOP Sessions

All 71 reports

Check if a patch is applied in EBS 12.2

Enterprise Command Center data

Manage and monitor the data sets that populate the Enterprise Command Center dashboards, and export the enriched dashboard data to Excel.

• ECC Admin - Data Load Tracking
• ECC Admin - Data Sets
• ECC Admin - Concurrent Programs

All 284 reports

ECC administration and data export

General ledger and financial statements

Account analysis down to journal lines, balances by account hierarchy and real-time financial statements with drilldown to the subledger.

• GL Account Analysis
• GL Journals
• GL Balance by Account Hierarchy
• GL Financial Statement and Drilldown (FSG)

All 132 reports

Period close and reconciliation

Period close exceptions, subledger to GL and accrual reconciliation for Finance teams, run from EBS and delivered as formatted Excel without data volume restrictions.

• XLA Subledger Period Close Exceptions
• AP Period Close Exceptions
• AR to GL Reconciliation
• CST AP and PO Accrual Reconciliation

All 70 reports

Inventory period close optimization

Payables

Invoices with lines and distributions, payments, aging and the trial balance, for daily work and the period close.

• AP Invoices and Lines
• AP Trial Balance
• AP Invoice Payments
• AP Accounted Invoice Aging

All 130 reports

Receivables

Aging, transactions with lines, customers and sites and applied receipts for collections and the period close.

• AR Aging
• AR Transactions and Lines
• AR Customers and Sites
• AR Applied Receipts

All 117 reports

Fixed assets

Asset register, book details, additions and depreciation projections across your asset books.

• FA Asset Register
• FA Asset Book Details
• FA Asset Additions
• FA Depreciation Projection

All 132 reports

Cash management

Bank statements and reconciliation, bank account balances and the reconciliation to the general ledger.

• CE Bank Statement and Reconciliation
• CE General Ledger Reconciliation
• CE Bank Account Balances
• CE Cleared Transactions

All 23 reports

Cost accounting

Reports by Doug Volz, the global leader in cost management solutions for Oracle EBS: inventory, intransit, receiving and WIP reconciliation, profit in inventory, stuck transactions and period control.

• CAC Inventory and Intransit Value (Period-End)
• CAC Inventory to G/L Reconciliation (Restricted by Org Access)
• CAC Item Cost Out-of-Balance
• CAC Accounting Period Status

All 116 reports

Purchasing

Purchase orders with lines, approved supplier lists, approval history and purchase price variance.

• PO Headers and Lines
• PO Approved Supplier List
• PO Approval History
• PO Purchase Price Variance

All 115 reports

Inventory

On-hand quantities, material transactions, items and inventory aging across organizations.

• INV Onhand Quantities
• INV Material Transactions
• INV Items
• INV Aging

All 127 reports

Order management and shipping

Orders with lines, holds, shipping and delivery transactions and price lists from order to cash.

• ONT Orders and Lines
• ONT Order Holds
• WSH Shipping/Delivery Transactions
• QP Price Lists

All 83 reports

Optimizing order management form exports

Manufacturing and planning

Bills of material, routings, the MRP horizontal plan and maintenance work orders.

• BOM Bill of Material Structure
• BOM Routings
• MRP Horizontal Plan
• EAM Work Orders

All 190 reports

Projects

Project status, revenue and cost by period, budgets and invoice review for project accounting.

• PA Project Status Summary
• PA Project Revenue and Cost by Period
• PA Project Budget
• PA Invoice Review

All 128 reports

HR and payroll

Employee assignments, headcount by organization, absences and payroll process summaries.

• PER Employee Assignments
• PER Headcount by Organization
• PER Employee Absences
• PAY Payroll Process Summary

All 181 reports

Mass data upload and migration

Users update or create records in Excel and upload them directly into Oracle EBS without needing any technical knowledge, for daily work as well as data migration in upgrade projects.

• AP Invoice Upload
• GL Journal Upload
• INV Item Upload
• AR Customer Upload

All 157 uploads

Discoverer and BI Publisher replacement

Import Discoverer workbooks and BI Publisher reports and run them as Blitz Reports in Excel, without record size or performance limitations.

• DIS End User Layers
• DIS Discoverer and Blitz Report Users
• DIS Workbook Import Validation
• DIS Import Performance

All 19 reports

Discoverer replacement with Blitz Report