How to replace Oracle ASCP exceptions with Blitz ReportBy Glen Whelan|April 5th, 2020| Planning by Exception1.1 ASCP Plan Exception Messages Examples2 Adding Blitz Report to the Planner Workbench2.1 Launching Blitz Report from the PWB2.2 Supply and Demand Export Report Example2.3 User Report Layouts2.4 Pegging Report Example3 SummaryPlanning by Exception The daily job of planners is responding to [...]
How to add Blitz Report™ to your favorite formBy Glen Whelan|March 31st, 2020| Adding Blitz Report to an Oracle form 1 Using Forms Personalization 2 Setup Steps 3 Summary and Tutorial Adding Blitz Report to an Oracle form To optimize the user experience, it is possible to add Blitz Report to any form menu using a forms [...]
How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™By Glen Whelan|March 31st, 2020| Why measure your supply chain performance? 1 How to create DIFOT in Sales Order Management 2 Seeded Blitz Report - Order Headers and Lines 3 Adding additional queries to the Blitz Report 4 Copy and rename your report 5 Modifying the report query 6 [...]
Hyperlinks in Blitz Report™By Artem Nesterko|August 17th, 2019| Hyperlinks can be embedded in Blitz Report excel output files using the syntax: HYPERLINK("URL to the location", "alternate text") Here is an example: select hp.party_number, 'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name, hp.party_type from hz_parties hp where hp.url is not [...]