Skip to content
  • Contact
  • Support
  •  Demo Login
Enginatics Logo
  • Blitz Report
    • Features
    • Pricing
    • Download
    • FAQ
    • Tutorials
    • User Guide
    • Installation Guide
    • Toolkits
      • Cost Accounting
      • Data Management
      • DBA
      • Metrics
      • Operations
      • Setup & Support
    • Changelog
  • Supply Chain Hub
    • Features
    • Download
    • Installation Guide
    • Seeded Reports
  • Library
    • lib items
      Advanced Pricing
      QP Price Lists
      Advanced Supply Chain Planning
      MSC ExceptionsMSC Horizontal PlanMSC PeggingMSC Supply and Demand OrdersMSC Vertical Plan
      Application Object Library
      FND Access ControlFND Access Control 11iFND Application Context FileFND ApplicationsFND Attached DocumentsFND Attachment FunctionsFND Audit SetupFND Audit Table Changes by ColumnFND Audit Table Changes by RecordFND Concurrent ManagersFND Concurrent Program IncompatibilitiesFND Concurrent Programs and ExecutablesFND Concurrent Programs and Executables 11iFND Concurrent Request ConflictsFND Concurrent Requests
      FND Concurrent Requests 11iFND Concurrent Requests SummaryFND Descriptive FlexfieldsFND FNDLOAD Object TransferFND Flex Hierarchies (Rollup Groups)FND Flex Security RulesFND Flex Value HierarchyFND Flex Value Sets, Usages and ValuesFND Flex ValuesFND Form FunctionsFND Forms PersonalizationsFND Help Documents and TargetsFND Key FlexfieldsFND LanguagesFND Lobs
      FND Log MessagesFND Lookup SearchFND Lookup ValuesFND Menu EntriesFND Profile Option ValuesFND Profile OptionsFND Responsibility Menu ExclusionsFND Role HierarchyFND RolesFND Tables and ColumnsFND User Login HistoryFND User Login Page FavoritesFND User ResponsibilitiesFND User RolesFND Users
      Applications DBA
      AD Applied PatchesAD Applied Patches 11iAD Applied Patches R12.2
      Assets
      FA Asset Book DetailsFA Asset InventoryFA Asset RetirementsFA Depreciation ProjectionFA Journal Entry Reserve LedgerFA Tax Reserve Ledger
      Bills of Material
      BOM Calendar ExceptionsBOM Routings
      Blitz Report
      Blitz Report Application CategoriesBlitz Report AssignmentsBlitz Report Category AssignmentsBlitz Report Column TranslationsBlitz Report Deletion HistoryBlitz Report Execution HistoryBlitz Report Execution SummaryBlitz Report LOVsBlitz Report License UsersBlitz Report Parameter Custom LOV ValidationBlitz Report Parameter Default ValuesBlitz Report Parameter Table Alias ValidationBlitz Report Parameter Uniqueness ValidationBlitz Report TemplatesBlitz Report User History
      Blitz Report VPD Policy SetupBlitz Reports
      CRM Foundation
      JTF Grid Datasources
      Capacity
      CRP Available ResourcesCRP Resource Plan
      Contracts Core
      OKC Contract Lines Summary
      Cost Accounting
      CAC Accounting Period StatusCAC Accounting Period Status (simple)CAC Cost Vs. Planning Item ControlsCAC ICP PII Inventory and Intransit Value (Period-End)CAC Inventory Out-of-BalanceCAC Inventory and Intransit Value (Period-End)CAC Inventory to G/L Reconciliation (Restricted by Org Access)CAC Inventory to G/L Reconciliation (Unrestricted by Org Access)CAC Item Cost SummaryCAC Margin Analysis Account SummaryCAC Margin Analysis SummaryCAC Material Account SummaryCAC Receiving Account SummaryCAC WIP Account Summary
      Cost Management
      CST Cost GroupsCST Detailed Item CostCST Inventory Value Report - by Subinventory (Item Cost)CST Inventory Value Report - by Subinventory (Subinventory)CST Item Cost ReportsCST Period Close Subinventory ValueCST Period Close Subinventory Value SummaryCST Supply Chain Indented Bills of Material Cost
      Database Administration
      DBA AWR Active Session HistoryDBA AWR Blocking Session SummaryDBA AWR Latch SummaryDBA AWR Latch by TimeDBA AWR PGA HistoryDBA AWR SQL Execution Plan HistoryDBA AWR SQL Performance SummaryDBA AWR SettingsDBA AWR System Metrics SummaryDBA AWR System Time SummaryDBA AWR System Time Summary PercentagesDBA AWR System Wait Class by TimeDBA AWR System Wait Event SummaryDBA AWR System Wait Time SummaryDBA AWR Tablespace Usage
      DBA Archive / Redo Log RateDBA Automated Maintenance TasksDBA Blocking SessionsDBA DBMS Profiler DataDBA Dependencies (used by)DBA Dependencies (uses)DBA External Table CreationDBA Feature Usage StatisticsDBA ParametersDBA Result Cache Objects and InvalidationsDBA Result Cache StatisticsDBA SGA Active Session HistoryDBA SGA Blocking Session SummaryDBA SGA Buffer Cache Object UsageDBA SGA Memory Allocation
      DBA SGA SQL Execution Plan HistoryDBA SGA SQL Performance SummaryDBA SGA Target AdviceDBA SGA+PGA Memory ConfigurationDBA SegmentsDBA Table ColumnsDBA Tablespace UsageDBA Text Search
      Discoverer
      DIS Access PrivilegesDIS Business AreasDIS End User LayersDIS Folders, Business Areas, Items and LOVsDIS Import PerformanceDIS Items, Folders and FormulasDIS UsersDIS Workbooks, Folders, Items and LOVsDIS Worksheet Execution HistoryDIS Worksheet Execution SummaryDIS Worksheet SQLs
      E-Business Tax
      ZX Party Tax ProfilesZX Tax AccountsZX Tax Regimes
      Enterprise Asset Management
      EAM AssetsEAM Weekly ScheduleEAM Work Orders
      Enterprise Command Center
      ECC Admin - Concurrent ProgramsECC Admin - Data Load TrackingECC Admin - Data SetsECC Admin - Metadata Attributes
      General Ledger
      GL Account AnalysisGL Account Analysis 11gGL Account Analysis 11iGL Balance DetailGL Balance Detail (pivot)GL Balance by Account HierarchyGL Data Access SetsGL Header Categories SummaryGL JournalsGL Ledger SetsGL Ledgers and Legal EntitiesGL Ledgers and OrganizationsGL Summary Templates
      Human Resources
      PER Employee AssignmentsPER Employee Grade ChangesPER Employee Salary ChangePER Organization HierarchyPER Organizations
      Installed Base
      CSI Customer Products SummaryCSI Installed Base Extended Attributes SummaryCSI Installed Base Summary by Organization
      Inventory
      INV Default Category SetsINV Intercompany Invoice ReconciliationINV Inventory ItemsINV Item Category SetsINV Item Default LocatorsINV Item Default SubinventoriesINV Item Import PerformanceINV Item RelationshipsINV Item StatusesINV Item TemplatesINV Material TransactionsINV Material Transactions SummaryINV Onhand QuantitiesINV Organization AccessINV Safety Stocks
      INV Stock LocatorsINV Subinventories
      Lease and Finance Management
      OKL Termination Quotes
      Legal Entity Configurator
      XLE Establishment and Legal Entity AssociationsXLE Legal Entities
      Master Scheduling/MRP
      MRP End Assembly PeggingMRP ExceptionsMRP Item ForecastMRP Pegging
      Order Management
      ONT Order HeadersONT Order Headers and LinesONT Order HoldsONT Recurring Billing PlanONT Transaction Types and Line WF Processes
      Payables
      AP Accounts Payable Negative Supplier BalanceAP Cash RequirementAP ExpensesAP Intercompany Invoice DetailsAP Invoice PaymentsAP Invoice on HoldAP Invoices and LinesAP Invoices with PO, Intercompany and SLA DetailsAP Open Balances RevaluationAP Open Items RevaluationAP SuppliersAP Suppliers 11iAP Suppliers Revenue Summary
      Payments
      IBY Payment Process Request Details
      Payroll
      PAY Employee Payroll HistoryPAY Payroll Element Details
      Projects
      PA Task Schedule
      Purchasing
      PO Approval AssignmentsPO Approval GroupsPO Approved Supplier ListPO Document TypesPO HeadersPO Headers 11iPO Headers and LinesPO Headers and Lines 11iPO Invoice Price VariancePO Purchase Price Variance
      Receivables
      AR Aging - 7 Buckets - By Salesperson/AgentAR Autoinvoice Interface SummaryAR Customer Credit LimitsAR Customers and SitesAR Disputed InvoiceAR European Sales ListingAR Incomplete TransactionsAR Miscellaneous ReceiptsAR Open Balances RevaluationAR Open Items RevaluationAR Past Due InvoiceAR Payment TermsAR Transaction RegisterAR Transactions and LinesAR Transactions and Payments
      AR Unapplied Receipts Register
      Service Contracts
      OKS Service Contracts Billing HistoryOKS Service Contracts Billing Schedule
      Subledger Accounting
      XLA Distribution Links SummaryXLA Entity ID Mappings
      Work in Process
      WIP Account DistributionWIP EntitiesWIP Entities SummaryWIP Required Components
      Workflow
      WF Activity Status SummaryWF Business Events and Subscriptions
      XML Publisher
      XDO Publisher Data Definitions
  • Customers
    • Customers Items

      “Excellent tool for quick reporting with a lot of handy functionality. Great replacement for Discoverer, especially for developers.”

      Bphuendra Aole, Senior Applications Developer, IMMI

      “Thank you for everything you do for us. I use your product every single day and love it.”

      Stephen Brown, Sr. EBS Business Analyst, Paysafe Group

      “I was so excited to have my hands on this amazing product the very first day, first hour!!!”

      Rajesh Gupta, VP - Information Tech., C&S ELECTRIC LTD

      Blitz Report allowed RBI to finally retire Discoverer, after struggling & dismissing other reporting solutions. They routinely use the Blitz Report Database Health and Tuning Toolkit to monitor & improve their Oracle EBS performance.

      A senior Oracle EBS business analyst announced their retirement. Blitz Report helped DeKalb bridge the knowledge gap and at the same time, improve and secure their Oracle EBS reporting

      LiDestri didn’t realize how cumbersome their previous reporting tools were. With Blitz Report, they now develop reports 10x faster.

  • Blog
    • blog items
      Blitz Report™

      Simplifying DBA tasks with Blitz Report

      I am an EBS Apps DBA. When I talk with other , it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a query from another DBA’s blog, sometimes I find something useful in a MOS Doc or a bo...

      Enhancing the Blitz Report Library, committed to support and service

      Team commitment to service and support Blitz Report has a number of great features that help our EBS customers get the answers they need to make better decisions more quickly. Features like delivering the required data as native Excel files, reduced processing overhead so performance is incredibly ...

      Hands On Tutorial - Oracle EBS - SQL to Excel Reporting for Non-developers

      Hands On Tutorial Many Oracle EBS end users are intimidated by the thought of creating their own reports.  At the same time, users are often frustrated about having to wait for their IT team to fulfill their requests. In order to help demystify the report creation process, we recently hosted an on...

      How to integrate reports into EBS forms using standard Zoom functionality

      Audience Relevant for development or supporting consultants and business users that require fast form export to Excel without waiting for the data to be ready. Introduction The standard EBS form export is useful for small data volumes, but when you have to export large-volume data such as plan, sal...

      EBS SQL to Excel reporting with Blitz Report for non-developers

      Getting Started with Blitz Report for non-developers We recently hosted a webinar with OATUG that was designed to introduce Oracle EBS users to Blitz Report for non-developers and the power of using SQL to get the answers they needed from their EBS data into Excel. We recorded the session and we are...

      Blitz Report™ Toolkits

      Asset tracking troubleshooting

      Audience: EBS architects, consultants, and business analysts for asset planning and tracking Article Summary: Understanding the asset integrations, including the Enterprise Command Center and troubleshooting transactions with Blitz Report. Prerequisites: 1. Download and install the free version of ...

      Bringing ASCP into a usable state

      Audience: EBS architects, consultants and business analysts for advanced supply chain planning (ASCP) Making the Planner Workbench usable Many customers of the Oracle module - Advanced Supply Chain Planning (ASCP) are disappointed or just cannot get the planners to use the Planner Workbench (PWB). ...

      How to use EBS audit functionality to speed up operations

      Audience: Master data maintenance, support consultants and operational teams. Related blogs: Can data governance be free? How to track changes using standard audit setup Auditing data in Oracle EBS Auditors are increasingly recommending that high-risk activities be tracked and reported. While Ora...

      Can data governance be free?

      Audience: Master Data Maintenance and data governance teams and support consultants Related Blogs: How to use EBS audit functionality to speed up operations How to track changes using standard audit setup Data Governance and compliance Typically, Oracle E-Business Suite (EBS) implementations have m...

      Oracle EBS project implementation and upgrade toolkit

      Introduction Managing EBS projects and upgrades can be a challenge at the best of times. Consulting teams with a mixture of functional and technical skills can benefit from having a ready made toolkit to take care of the project tasks such as exporting master data, tracking changes and creating new...

      Oracle Discoverer

      Oracle Discoverer Replacement

      Task: Oracle Discoverer replacement Audience: DBA's, IT consultants and business operations Background Oracle de-supported Discoverer in 2017, which poses a significant challenge for EBS users. The Enginatics team has developed an Oracle Discoverer replacement utility with automated functionality...

      Does Oracle Discoverer 11g work with Oracle Database 19c?

      Lately we see questions about Oracle Discoverer 11g certification with Oracle Database 19c. Oracle officially confirms that Discoverer is not tested or certified on the Oracle Database 19c. We use Discoverer for development purposes only, but were curious if it will work with the 19c version. Recen...

      Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3

      Since we recently developed automated Discoverer report migration into Blitz Report and our development team needed test environment,  we had to integrate Discoverer with Oracle EBS. In this post we share our experience. Please refer to the Blitz report user guide for more information and detailed...

      Oracle E-Business Suite

      Could your organization lose these mission critical EBS assets?

      The case for agile EBS reporting Losing a critical business asset is always hard. It shouldn’t happen. Recently, when discussing our favorite topic, “Oracle EBS Reporting”, an organization confided that they suffered a serious loss. One of their KPI reports was missing. It was a complex SQL s...

      Enhancing the Blitz Report Library, committed to support and service

      Team commitment to service and support Blitz Report has a number of great features that help our EBS customers get the answers they need to make better decisions more quickly. Features like delivering the required data as native Excel files, reduced processing overhead so performance is incredibly ...

      Hands On Tutorial - Oracle EBS - SQL to Excel Reporting for Non-developers

      Hands On Tutorial Many Oracle EBS end users are intimidated by the thought of creating their own reports.  At the same time, users are often frustrated about having to wait for their IT team to fulfill their requests. In order to help demystify the report creation process, we recently hosted an on...

      Oracle E-Business Suite 12.2.9 upgrade to version 12.2.10

      Enginatics always stays up to date with the latest technology. So right after the availability of Oracle E-Business Suite was announced, our team was eager to upgrade our EBS Demo instance to the latest release, so anyone can test Blitz Report™ on the most recent software. Blitz Report™ is the ...

      Connect Oracle E-Business Suite to Vertica and other non Oracle databases

      Introduction In this post I will show how to connect Blitz Report to non-Oracle databases like Vertica, MySQL, PostgreSQL using Oracle Database Gateway and Heterogeneous Services. This can be useful if your organization has information stored in databases from different vendors and you would like t...

      Oracle Enterprise Command Center