Home › Discussions › Questions & Answers › How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™

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

Avatar photoCustomer August 30, 2022 at 6:45 pm

We need to start tracking our Delivery in Full On Time (DIFOT) KPI, which is complex because it relies on accurate order and shipping dates within Order Management. How can Blitz Report simplify the definition and calculation of this critical supply chain metric?

Viewing 4 reply threads
  • Author
    Replies
    • Support September 1, 2022 at 4:05 am  

      Blitz Report is an ideal tool for creating complex custom metrics like DIFOT. The methodology starts by utilizing existing components: you should first copy the seeded Order Header and Lines Blitz Report. You then modify this copy and rename it meaningfully, such as ‘ONT DIFOT’.

    • Avatar photoCustomer September 1, 2022 at 5:22 pm  

      Once the report is copied, what are the next technical steps required to calculate the metric accurately?

    • Support September 2, 2022 at 4:26 am  

      You must define the logic clearly, starting with a strong understanding of your promise date and order date types. You then create and test the revised query containing your DIFOT logic and save it back into the copied Blitz Report. Remember to modify the user template to show only the necessary columns for the KPI output.

    • Avatar photoCustomer September 4, 2022 at 2:13 am  

      We often have manual adjustments to promise dates. Is there a way to track that change history to ensure data integrity for the DIFOT calculation?

    • Support September 5, 2022 at 4:14 pm  

      Yes, if configuration or promise dates are subject to changes, you can leverage the Audit capability of Blitz Report, details of which are available on our YouTube channel, to track these modifications and maintain data governance.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123737

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19778

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14607

How to check if a patch is applied in Oracle EBS 12.2 14378

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11961

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9896

Migration to Java Web Start in Oracle EBS 12.2 instance 9886

Securing sensitive data with Oracle VPD 7790

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6444

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018