Home Discussions Questions & Answers How to replace Oracle ASCP exceptions with Blitz Report

How to replace Oracle ASCP exceptions with Blitz Report

Avatar photoCustomer May 24, 2022 at 8:36 pm

The standard Oracle ASCP planning exceptions reporting via the Planner Workbench (PWB) is too restrictive, and users struggle with extracting and analyzing the data in a usable format. Can Blitz Report effectively replace the standard ASCP exceptions interface with custom reports?

Viewing 10 reply threads
  • Author
    Replies
    • Support May 25, 2022 at 2:37 am  

      Yes, Blitz Report is specifically promoted as a tool to replace Oracle ASCP exceptions. It allows planners to create custom reports based on the underlying ASCP planning data, providing the flexibility needed for detailed analysis.

    • Avatar photoCustomer May 26, 2022 at 4:22 pm  

      What is the primary technical advantage when exporting these custom exceptions compared to the default ASCP methods?

    • Support May 27, 2022 at 12:36 am  

      The main advantage lies in the output format and data handling. Blitz Report enables the rapid export of the exception data into a structured Excel format, unlike the traditional PWB exports which may be cumbersome or suffer from data limitations. This ensures that planners can manipulate the data directly in Excel for deeper analysis.

    • Avatar photoCustomer May 28, 2022 at 11:36 pm  

      We also need reports related to ASCP pegging and key performance indicators (KPIs). Does Blitz Report cover these specific Advanced Supply Chain Planning functions?

    • Support May 30, 2022 at 3:39 pm  

      Certainly. The system is used for various advanced planning functions. You can create specific reports for ASCP pegging exports, performance metrics (KPIs), and detailed plan explanations beyond just exceptions. This capability extends into other Supply Chain areas like Inventory Planning and Work Orders.

    • Avatar photoCustomer May 31, 2022 at 2:21 pm  

      If we want to build a new planning report using SQL, is the report development process streamlined?

    • Support June 1, 2022 at 9:29 am  

      The report creation process is highly simplified. Developers or power users can take their precise SQL queries and integrate them instantly into the Blitz Report application. The system manages the EBS registration overhead automatically, allowing rapid deployment of new supply chain metrics.

    • Avatar photoCustomer June 1, 2022 at 6:45 pm  

      We need non-developers to be able to access and run these ASCP reports easily, without needing deep SQL knowledge.

    • Support June 3, 2022 at 7:09 pm  

      The focus of Blitz Report is on SQL to Excel reporting for non-developers. Once the report is created and saved, end-users access it through the familiar EBS Forms interface, enter parameters, and receive the complex ASCP data output directly as a clean Excel file.

    • Avatar photoCustomer June 5, 2022 at 7:01 am  

      Can we filter the reports based on operational aspects like specific nodes or concurrent managers involved in the planning run?

    • Support June 5, 2022 at 10:41 pm  

      Yes, advanced monitoring reports within the Blitz Report suite (like the Concurrent Request Monitoring tools) can filter requests based on various operational metrics, including the Node where the request ran or the Manager Name processing the request. This provides deep visibility into the execution environment.

Viewing 10 reply threads
  • You must be logged in to reply to this post.

Login with: