How to develop proven EBS reports using Oracle Enterprise Command Center SQLs in under 5 minutes

Customer April 16, 2021 at 6:23 pm

We utilize the Oracle Enterprise Command Center (ECC) Framework extensively, but often need to pull the detailed data behind the dashboards into static, formatted reports for distribution. Is there a fast method to re-use the proven ECC SQLs for traditional EBS reporting?

Viewing 10 reply threads

Author
Replies
- Support April 17, 2021 at 3:57 pm
  Yes, Blitz Report enables rapid report development using the standardized Oracle ECC SQL queries. You can develop proven EBS reports using Oracle Enterprise Command Center SQLs in under 5 minutes. This capability is highly relevant for developers, supporting consultants, and business users needing reports based on the same logic as the ECC dashboards.
- Customer April 19, 2021 at 1:41 am
  Why is using Blitz Report significantly faster than building a traditional Concurrent Program report around ECC SQL?
- Support April 19, 2021 at 5:38 am
  The speed stems from bypassing the conventional EBS report registration process, which is complex and time-consuming. Blitz Report is already integrated and simply requires pasting the validated ECC SQL into the Blitz Report form. The tool handles version control, parameters, and access assignment instantly.
- Customer April 21, 2021 at 5:41 am
  If we modify an ECC dashboard, for example, by adding custom data from an underlying table, can Blitz Report export that enriched dashboard data?
- Support April 22, 2021 at 10:29 pm
  Yes, Blitz Report is capable of exporting the enriched dashboard data to Excel. Furthermore, even if you are extending existing ECC dashboards with additional data, Blitz Report can export the underlying Oracle standard ECC data to Excel. This supports granular administration and analysis of ECC data sets.
- Customer April 23, 2021 at 1:53 am
  What is the primary output format when extracting ECC data via Blitz Report, and how does it handle large datasets?
- Support April 24, 2021 at 4:50 am
  The primary output format is native, perfectly formatted Excel. Blitz Report boasts reduced processing overhead and incredibly fast performance, meaning that even time-critical reports and mass data exports originating from ECC data sets are handled efficiently, without the usual export limitations.
- Customer April 26, 2021 at 1:20 am
  We are planning to upgrade our ECC Framework. We are currently on an older version and looking ahead to ECC V11. Does Blitz Report offer tools useful during these complex upgrades?
- Support April 27, 2021 at 6:33 pm
  For ECC upgrades (such as to V4, V5, V6, V7, V9, or V11) , the Project Implementation and Upgrade Toolkit within Blitz Report provides essential tools. This includes Database Health and Tuning reports, alerts for critical processes, and easy data extracts (BR100s), which are vital for validation and rollback preparation during complex ECC patches and configurations.
- Customer April 29, 2021 at 3:49 pm
  We need to ensure that the ECC data exports respect our security policies, specifically Virtual Private Database (VPD).
- Support April 30, 2021 at 4:07 pm
  Blitz Report respects your established security architecture. Since it operates within EBS and accesses the database via standard interfaces, it honors standard Oracle Virtual Private Database (VPD) security policies, enforcing row-level and column-level access controls on the data being reported, even during mass exports.
Author
Replies