How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™

Customer July 28, 2020 at 12:05 am

We need to implement a critical Order Management metric: Delivery in Full On Time (DIFOT). We struggle to derive this KPI using standard tools. What is the process using Blitz Report to create a Delivery in Full On Time metric in Oracle E-Business Suite?

Viewing 10 reply threads

Author
Replies
- Support July 28, 2020 at 7:53 am
  Creating the DIFOT metric involves understanding your promised date and order date types as the first step. You should start by copying a seeded Order Header and Lines Blitz Report to leverage existing joins and then modifying the copied report.
- Customer July 29, 2020 at 7:58 am
  Once the report is copied, what steps are needed to focus the output specifically on the DIFOT KPI?
- Support July 30, 2020 at 10:00 am
  First, modify the Blitz Report copy and give it a meaningful name, such as ‘ONT DIFOT’. Second, revise the underlying query to incorporate the logic for DIFOT calculation, and test the revised SQL. Third, modify the user template to show only the specific columns required for the DIFOT metric, improving readability and focus.
- Customer July 31, 2020 at 12:48 pm
  We are concerned about changes to the original promise date, as this affects the integrity of the DIFOT calculation. Can we track who modified the promise date fields?
- Support August 2, 2020 at 1:47 pm
  Yes. If your system tracks changes to the promise date (assuming the necessary audit setup parameters are configured), you can review the Audit capability using Blitz Report. This allows you to track master data changes accurately, providing governance over the source data used for the KPI calculation.
- Customer August 2, 2020 at 4:49 pm
  If we define this DIFOT report, can we ensure that the development process itself is fully compliant with internal change control procedures?
- Support August 4, 2020 at 3:02 pm
  Blitz Report facilitates internal change control. It automatically records the necessary change control information whenever applicable during the report modification process, maintaining an audit trail and version history within EBS.
- Customer August 6, 2020 at 2:24 pm
  How can we quickly test the new DIFOT report once finalized?
- Support August 8, 2020 at 4:19 am
  After adding your new calculated columns to the user template, you can make the report available immediately for testing. Furthermore, reports can be assigned to a specific user or responsibility for immediate testing and validation before general rollout.
- Customer August 9, 2020 at 2:43 am
  Can this DIFOT report be exported in a format ready for pivot table analysis for deep dive performance reviews?
- Support August 9, 2020 at 4:34 pm
  Yes, since the output is perfectly formatted, native Excel , the data is immediately usable for advanced analysis tools like pivot tables, suitable even for financial performance reviews.
Author
Replies