Blitz Report™ Toolkits
Smart project implementation and upgrade toolkits for Oracle E-Business Suite
The Blitz Report Toolkits are aimed at consulting and analytical teams with the common aim of expediting project and support tasks; they allow users to manage critical processes and export data from any EBS functional area using familiar commands and concurrent request functionality. In addition to our library of proven reports, users can create their own ad-hoc reports in minutes, and Blitz Report will deliver the correct data type and column size in Excel output without any data limitations.
Blitz Report™ delivers 5 toolkits of valuable reports, including:
If you have any questions or require any further assistance regarding Blitz Report Toolkits, the easiest way to reach us is through the chat or you can send us an email to [email protected] or call us at +41445528765
The standard Automatic Workload Repository (AWR) reports are difficult to read and challenging to interpret. Blitz Report provides an alternative suite of reports using the AWR data combined with additional EBS information to simplify the analysis. For example, when analyzing under performing SQL’s the report includes the name of the package and the code line creating the issue. This makes it much easier for a DBA or developer to identify, locate and correct the issue.
This toolkit includes reports that will:
- Wait events to identify problems
- Time model statistics indicating the amount of DB time associated with a process from the time model views
- Active Session History (ASH) statistics from the active session views
- Some system and session statistics from the statistical views
- Object usage statistics
- Resource intensive SQL statements
This topic is covered in more detail in our blog here
Supporting business users and related processes 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 support or upgrade toolkit to take care of the project tasks such as BR100 extracts for setup and data migration, and alerts for critical processes such as integrations and concurrent requests.
Blitz Report is an easy to use add on for EBS which resides in Oracle forms meaning that there are no new commands to learn. There are no data limits for the output size which makes it very fast to export and migrate data. Whether you have 5 million records or just a few thousand, it will generate perfectly formatted Excel or CSV files.
Support consultants can create new or ad hoc reports quickly and efficiently with just a few clicks. Or users can paste existing proven SQL scripts directly into Blitz Report and start sharing with the rest of the teams, and with full version control. Reports, are provided to track any setup or master data changes but without the complexity of implementing or licencing the GRC data governance and compliance module. For example: if someone has made changes to a billing address, bank account details or it can detect any setup changes with a setup of less than 5 minutes per object to be tracked.
For security requirements, the central admin teams can control what tables Blitz Report is able to access through Oracle Virtual Private Database (VPD) security policies, making it a simple and viable tool for keeping your data private and secure.
All reports run from EBS forms which means there are minimal training requirements. Once a new report had been delivered to the business user, they have the capability to hide, display and re-order columns in a similar method as form folders, thereby reducing dependency on IT personnel for minor changes.
There is an extensive portfolio of operational reports provided with Blitz Report including: Record to Report,Purchase to Pay, Supply Chain and Order to Cash. There are also reports to handle data governance, e.g. who changed what when together with the capability to build fast metrics such as the DIFOT (delivered in full and on time)
New reports can be quickly developed by IT teams using the import or export functions. For example, developers can re-use BI Publisher, Concurrent or Discoverer reports as a baseline to build from by importing and adding the additional requirements.
Our users have found that the development cycle is typically one tenth of the typical EBS report development path, since there are no new concurrent programs to register, whilst parameters can be selected from a list and re-used between reports. Version control is all available within Blitz Report and new reports can be automatically exported and imported from one platform to another thereby simplifying the development cycle progress from UAT to production delivery.
The default method for export of data is a fully formatted Excel sheet delivered by the concurrent request mechanism, except there are no record size limitations as per BI Publisher reports, nor does it suffer the same performance limitations.
Typically, Oracle E-Business Suite (EBS) implementations have many security, auditing and compliance related requirements. For example: if someone has changed a billing address, bank account, or a system profile. More recently with the introduction of the Enterprise Command Centers (ECC) it becomes important to manage data out of EBS to ensure that the dashboards are up to date and users are working with the correct data sets.
For customers not wishing to implement or licence the Governance Risk & Compliance module, monitoring master data can be a significant challenge. This toolkit allows audit on any master data element and critical data sets to ECC. Our audit reports are based on the standard Audit functionality defined in sysadmin and the reports identify changes on any columns that you need to track. Reports allow the selection of related tables too, for example: if you need to track an important attribute on the Item Master such as “Cost of Goods Sold Account” and also wish to report on the items organization code.
The ECC reporting suite allow you to manage the data sets from each module that populate the Command Center dashboards, and hence allow you to readily monitor this data, ensuring that the data is sent on time and without error, thereby keeping the business community informed.
Doug Volz is the global leader in cost management solutions for Oracle EBS and cloud applications. He has adopted Blitz Report™ as the recommended reporting tool for his clients and included several of his specialized reports in the Enginatics report library. For over twenty years, Doug has offered these reports to the Oracle community as SQL’s. Now, these reports are pre-configured for Blitz Report™ enabling Finance and Cost Accountants to use immediately without the IT development overhead.
The report toolkit addresses common inventory & manufacturing reconciliation challenges:
- Inventory reconciliation (Onhand, Intransit, Receiving, WIP)
- Profit in inventory tracking and elimination
- Stuck transactions
- Period control for multiple inventory organizations
- Better multi-organization inventory value, transaction variance, and item cost reports
- Subledger accounting reconciliation
Example reports supplied with Blitz Report
The full library is available here
Examples
- FND (application foundation) extracts, including values sets, account hierarchies, profiles, menus and key flexfields for setup tracking
- Master data extracts for chart of accounts, ledgers, items, suppliers and customers
- Setup (BR100) tracking, for Invoice and Sales Order transaction types, ASCP sourcing rules, Sub-inventories, Locators, etc
- Audit and data governance for setup and master data using the standard EBS audit setup but with clear reporting of delta changes and inclusion of none tracked columns which allow users to make sense of the reports but without the need for the GRC module
- Monitoring of interfaces, including AR Autoinvoice, Material transactions, AP Invoices, etc
- Period close transactional checks, speed up month end with daily alerts on any critical interface
- Monitor database health with a suite of AWR reports that remove the challenge of understanding the standard AWR
- Exports for Invoices (AP/AR), Sales Orders, Price Lists, Approved supplier lists, etc
- Track patches that have been applied by adpatch
- Workflow monitoring and status alerts
These are just a few examples of our available reports, new reports can be created within minutes. Or you can import BI Publisher or Discoverer reports complete with their assignments and parameters, speeding up the development process without administration overheads. Reports can be migrated from each EBS instance that they are developed on, making the implementation process straight-forward without version challenges.