Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
835 reports
| Description | Download | ||
|---|---|---|---|
| CST Detailed Item Cost | Detail report that lists each item and the associated costs to be recognized as part of total unit cost of producing the item. | Cost Management Enginatics |   |
| CST Historical WIP Standard Cost Adjustment | WIP standard cost adjustment details recorded by a completed standard cost update, based on Oracle's Historical WIP Standard Cost Adjustment Report (CSTCUSJA).
The report shows one line per WIP discrete job, transaction type, item or resource operation and cost element, with the old and new unit costs, adjustment quantity and adjustment value, and the WIP job's valuation and standard cost adjustment accounts.
The Cost Update parameter offers the completed standard cost updates of the selected organization that saved their adjustment details, matching Oracle's View Cost Update History form.… full description | Cost Management Enginatics | |
| CST Inventory Value - Multi-Organization (Item Costs) | Report: CST Inventory Value - Multi-Organization (Item Costs)
Description:
The Inventory Value Report can be used to report Inventory Value by
- Elemental Item Cost level
- Quantity Type (Onhand, Intransit, Receiving)
The report can be used to analyze inventory value by Ledger, Operating Unit, Organization, Subinventory, Item Category, Cost Group
The report corresponds to the following standard Oracle Reports
- Elemental Inventory Value Report
- All Inventories Value Report
The report can be run across multiple Inventory Organizations
Templates are provided that match the existing… full description | Cost Management Enginatics | |
| CST Inventory Value Report - by Subinventory (Item Cost) | Imported Oracle standard inventory value subinventory report by item cost
Source: Inventory Value Report - by Subinventory (XML)
Short Name: CSTRINVR_XML
DB package: BOM_CSTRINVR_XMLP_PKG | Cost Management Enginatics, R12 only | |
| CST Item Cost Reports | Flexible costing set of reports - analyze item costs for any cost type.
Choose from the following options:
Choose one of the following options:
Activity Summary - Report item costs by activity.
Activity by Department - Report item costs by activity and department.
Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Activity by Operation - Report item costs by activity and operation sequence number.
Element - Report item costs by cost element and cost level.
Element by Activity - Report item costs by cost element and activity.
Element by… full description | Cost Management Enginatics | |
| CST Miscellaneous Accrual Reconciliation | Imported from Concurrent Program
Application: Bills of Material
Source: Miscellaneous Accrual Reconciliation Report
Short Name: CSTACRMI
DB package: | Cost Management Enginatics, R12 only | |
| CST Period Close Subinventory Value | Summary report that lists selected operating units with corresponding sub inventory code and Inventory value on a historic basis. | Cost Management Enginatics | |
| CST Period Close Subinventory Value Summary | Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability. | Cost Management Enginatics | |
| CST Periodic Inventory Value | Imported from BI Publisher
Description: Periodic Inventory Value Report
Application: Bills of Material
Source: Periodic Inventory Value Report (XML)
Short Name: CSTRPICR_XML
DB package: BOM_CSTRPICR_XMLP_PKG | Cost Management Enginatics, R12 only | |
| CST Subinventory Account Value - Multi-Org | Report: CST Subinventory Account Value - Multi-Org
Description:
Shows onhand inventory value broken down by GL account and cost element across multiple organizations.
For each subinventory, the report unpivots inventory value into separate rows per cost element (Material, Material Overhead, Resource, Outside Processing, Overhead), each showing the GL account where that cost element is recorded.
Asset subinventories show 5 rows per item (one per cost element).
Expense subinventories show 1 row per item with total cost under the expense account.
Account determination follows Oracle standard… full description | Cost Management Enginatics, R12 only | |
| CST Supply Chain Indented Bills of Material Cost | This report is based on the (static) Oracle Supply Chain Indented Bills of Material Cost Report and merely sums up the available information from the Cost Type. It does not do a Cost Rollup and as a result, the "Extended Cost" column might not add up to the total item cost for the assembly especially if changes have been made to the bills of material, routing or item costs, since the last cost rollup. If this is the case, run a Supply Chain Cost Rollup in Pending or some other cost type (such as Current) for reporting purposes, to synchronize the cost information and then use this report,… full description | Cost Management BI Publisher, Enginatics, R12 only | |
| CST Uninvoiced Receipts | Application: Bills of Material
Description: Uninvoiced Receipts Report
Templates: Select a template to show Accruals summarized by
- PO/Release Distributions (Default)
- PO/Release Shipments
- PO/Release Lines
Each template includes a Pivot summarizing the accruals by Accrual Account and the Pivot/Sort Parameter Value (Vendor, Category, PO/Release Number)
Source: Uninvoiced Receipts Report
Short Name: CSTACREP
DB Package: XXEN_CST | Cost Management Enginatics, R12 only | |
| DBA AWR Active Session History | Active session history from the automatic workload repository | System Enginatics | |
| DBA AWR Blocking Session Summary | Summary of blocked and blocking sessions based on the active session history from the AWR.
The link to blocking sessions is deliberately nonunique without jointing to sample_id to increase the chance to fetch the blocking session's additional information such as module, action and client_id.
In some cases, such as row lock scenarios, the blocking session is idle and does not show up in the ASH.
We recommend doing further analysis with a pivot in Excel rather than by SQL, as Excel's drag- and drop is a lot faster than typing commands manually. | System Enginatics | |
| DBA AWR CPU Load (active session history) | Aggregates active sessions by snapshot time to identify times with high CPU load over a specific 'CPU Sessions From' threshold value. | System Enginatics | |
| DBA AWR CPU vs Wait Time Summary | Summary of database CPU vs. wait times and average active sessions for a specified time frame
To see data in this report based on dba_hist_sys_time_model, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ | System Enginatics | |
| DBA AWR Interconnect Traffic | Displays information about the usage of an interconnect device by instance in a RAC configuration.
ipq - Parallel query communications
dlm - Database lock management
cache - Global cache communications
All other values are internal to Oracle and are not expected to have high usage. | System Enginatics | |
| DBA AWR Latch Summary | Summary of latch statistics such as misses and wait times for a specified snapshot time interval | System Enginatics | |
| DBA AWR Latch by Time | Latch contention wait time history.
Each row shows the system-wide latch contention wait time per latch name of one AWR snapshot interval to identify high latch contention at specific times. | System Enginatics, R12 only | |
| DBA AWR PGA History | History of database PGA size and other statistics from v$pgastat in megabytes | System Enginatics | |
| DBA AWR SQL Execution Plan History | Execution plan history for a particular SQL id from the automatic workload repository | System Enginatics | |
| DBA AWR SQL Performance Summary | Database SQL performance summary from the Automatic Workload Repository (AWR) tables to give an overview of top SQL load and performance issues.
The report shows the summarized execution stats such as elapsed time and IO figures for a certain timeframe for individual SQL_ID and plan hash value combinations.
All IO figures are shown in MB.
Parameter 'Level' can be switched to aggregate data either by Module or by individual SQL and to show summarised figures or to split them by day.
The default sorting shows the most CPU intensive SQLs on top, as the tuning goal is usually server load… full description | System Enginatics | |
| DBA AWR Settings | Automatic workload repository settings such as retention period, snapshot interval and number of top SQLs to capture (from table underlying the view dba_hist_wr_control).
Note that for executing Blitz Report queries on AWR data, you require a Diagnostic pack license as explained in Oracle's note KB136730:
https://support.oracle.com/support/?kmContentId=1490798
topnsql=DEFAULT means the database captures the top 30 SQLs from 5 different categories (Elapsed Time, CPU Time, Parse Calls, Shareable Memory, Version Count) for each snapshot interval.
So the default setting would capture a maximum… full description | System Enginatics | |
| DBA AWR System Metrics Summary | Historic system statistics from the automated workload repository showing CPU load, wait time percentage, logical (buffer/RAM) and physical read and write IO figures, summarized in snapshot time intervals. All IO figures are measured in MB/s.
-CPU%: Total CPU usage percentage. If this is low, the hardware is underused and performance could potentially get improved by using it better e.g. by resolving IO bottlenecks (bigger RAM, faster storage) or parallelization of SQLs and user processes.
-WAIT%: Percentage of time that the DB process spends waiting rather than processing. If the wait% is… full description | System Enginatics | |
| DBA AWR System Time Percentages | Historic system time model values from the automated workload repository showing a breakdown of how much percent of the database time was spent e.g. on excuting SQL, PL/SQL or Java code, parsing statements etc..
To see data in this report based on dba_hist_sys_time_model, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ | System Enginatics | |
| DBA AWR System Time Summary | Historic system time model values from the automated workload repository showing how the database time was spent e.g. on excuting SQL, PL/SQL or Java code, parsing statements etc..
To see data in this report based on dba_hist_sys_time_model, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ | System Enginatics | |
| DBA AWR Tablespace Usage | Tablespace usage over time from the AWR | System Enginatics | |
| DBA AWR Wait Class by Time | Non idle session wait times by wait class over time.
Each row shows the system-wide wait time per wait class of one AWR snapshot interval to identify unusual wait events that occured at specific times.
Use the Session Type parameter to restrict either to foreground, background or all server processes.
To see data in this report based on dba_hist_system_event, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ | System Enginatics | |
| DBA AWR Wait Event Summary | Summary of wait times by wait event and event class for a specified snapshot time interval.
Use the Session Type parameter to restrict either to foreground, background or all server processes.
To see data in this report based on dba_hist_system_event, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ | System Enginatics | |
| DBA AWR Wait Event Summary (active session history) | Wait event and CPU usage summary from the AWR active session history. | System Enginatics | |
| DBA Alert Log | V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB).
You could schedule it, for example, in incremental mode to send an email with errors that occured since the last scheduled report run. | System Enginatics | |
| DBA Archive / Redo Log Rate | If the database is running in ARCHIVELOG mode, the amount of generated archive log is shown.
For databases on NOARCHIVELOG, the approximate amount of generated redo is calculated by the number of log switches per hour and log file size. Note that this log rate is just an approximated maximum as switches could also occur without the log files being full.
Redo log files are located here:
select * from sys.v_$logfile | System Enginatics | |
| DBA Blocking Sessions | Chain of currently blocking and blocked database sessions from v$wait_chains | System Enginatics | |
| DBA CPU Benchmark2 | Benchmark report to measure a database server's CPU speed, mainly for PLSQL processing.
This report generates an output file of 200000 records from dual.
As the query itself should complete in less than a second, most of the execution time is spend in PLSQL code to generate the Blitz Report output file.
To measure meaningful results, there should be enough SGA memory assigned to ensure that the execution time is entirely spent on CPU and not IO related wait events (to be confirmed using the DBA SGA Active Session History report).
example performance for different CPU… full description | System Enginatics | |
| DBA CPU Benchmark3 | This Benchmark report measures a database server's CPU performance for arithmetic calculations by calculating about 40 million square roots.
example performance for different CPU types:
seconds rows/s CPU
7 285714 AMD Ryzen 9 5950X 16-Core Processor
13 153846
12 166667 AMD EPYC 7742 64-Core Processor
31 64516 Exadata CS X8M
42 47619 Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz
42 47619 Intel(R) Xeon(R) CPU E5-2699 v4 @ 2.20GHz
41 48780 Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz
41 48780 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
43 46512 Intel(R) Xeon(R) CPU E5-2686 v4 @ 2.30GHz… full description | System Enginatics | |
| DBA Data Files | Data and temp files per tablespace with their size, free space, autoextend settings and the space still available up to the maximum size.
All sizes are shown in MB.
Available Size and Max Used Percent take autoextend into account, so they show how close a file is to its real limit. Used and free space of temp files are shown by DBA Tablespace Usage.
In Backup Mode flags data files left in hot backup mode (alter tablespace ... begin backup).
Schedule the report with Max Used Percent From, for example 90, to get an email only when a data file is close to full. | System Enginatics | |
| DBA Database Links | Database links with their owner, remote user and connect string. | System Enginatics | |
| DBA Database Parameter Validation | Replicates the database initialization-parameter validation performed by Oracle's EBS Database Performance and Statistics Analyzer (My Oracle Support Doc 2126712.1 / KB627702), so DBAs no longer need to download, install and run that analyzer to check EBS parameter compliance.
Reference: https://support.oracle.com/rs?type=doc&id=2126712.1
It compares the current instance settings in v$system_parameter2 against Oracle's required values for the running RDBMS version (11.1 / 11.2 / 12.1 / 19c) and EBS release, per My Oracle Support Doc 396009.1 / KA1002 ("Database Initialization Parameters for… full description | System Enginatics | |
| DBA Dependencies (used by) | Hierarchical report showing all database objects using the specified object, e.g. a certain table and the report shows all the views or packages that are refrencing or depending on the specified table (bottom to top) | System Enginatics | |
| DBA Dependencies (uses) | Hierarchical report showing all dependent database objects that a specified object, e.g. a view or package name uses or depends on (top to bottom) | System Enginatics | |
| DBA Directories | Database directory objects with their operating system path and the users granted read, write or execute access to them. | System Enginatics | |
| DBA Editioned Object Summary | Summary of editioned objects per edition from ADZDSHOWOBJS.sql
There is a good blog: https://www.pythian.com/blog/technical-track/adop-edition-cleanup | System Enginatics | |
| DBA Editions | Database editions, their type and status | System Enginatics, R12 only | |
| DBA External Table Creation | System Enginatics | | |
| DBA Feature Usage Statistics | Database license feature usage statistics, such as the number of times that an AWR HTML report was run | System Enginatics | |
| DBA Hierarchical Profiler Data | Excel version of Oracle's hierarchical profiler dbms_hprof PLSQL performance analysis.
PL/SQL units that have been compiled in NATIVE mode cannot be profiled.
To gather information, you must ensure that the PL/SQL code is INTERPRETED."
Before compilation of the profiled code, execute:
alter session set plsql_code_type=interpreted; Create and setup access to profiler tables as sys:
exec dbms_hprof.create_tables(force_it=>true);
create public synonym dbmshp_trace_data for sys.dbmshp_trace_data;
create public synonym dbmshp_runs for sys.dbmshp_runs;
create public synonym dbmshp_function_info… full description | System Enginatics, R12 only | |
| DBA Index Columns | System Enginatics | | |
| DBA Jobs | System Enginatics | | |
| DBA Log Switches | System Enginatics | | |
| DBA ORDS Configuration Validation | Validates the Oracle REST Data Services (ORDS) configuration for Blitz Report webservices. Checks: ORDS schema enablement and URL mapping, REST module status, PL/SQL package validity, all 27 expected endpoint handlers and their ORDS template registrations, execute grants, URL-pattern privileges that intercept xxen_webservices calls and the OAuth client's role grants (catches HTTP 401 caused by pre-existing catch-all privileges), ORDS URL profile configuration with token endpoint validation, OAuth2 client_id/secret availability, and ORDS connection pool sessions. Use this report to diagnose… full description | System Enginatics, R12 only | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…