How to quickly create or modify Oracle E-Business Suite BI Publisher based reports

Customer June 2, 2022 at 1:11 am

Modifying or quickly prototyping reports based on Oracle BI Publisher data definitions, especially those utilizing complex XML data, is a lengthy process. How can we use Blitz Report to quickly create or modify Oracle E-Business Suite BI Publisher based reports?

Viewing 10 reply threads

Author
Replies
- Support June 2, 2022 at 9:08 pm
  Blitz Report allows you to essentially ‘fast track’ this development process. You can convert and deploy BI Publisher-based reports in as little as 5 simple steps, primarily by extracting the core SQL logic from the BI Publisher data definition and integrating it directly into the Blitz Report form.
- Customer June 4, 2022 at 6:42 am
  Can you provide an example of a complex BI Publisher report this process works well for, especially one relying on an XML Data Template?
- Support June 5, 2022 at 11:54 am
  A perfect example is the All Inventories Value Report (CSTRAIVR), which relies on CSTRAIVR_XML. Blitz Report easily converts this report, extracting the data set logic to provide immediate, formatted Excel output, solving the core issues associated with BI Publisher’s complex template requirements.
- Customer June 6, 2022 at 2:17 pm
  What is the main output benefit compared to the original BI Publisher output, assuming the underlying logic is the same?
- Support June 8, 2022 at 1:19 am
  The primary output benefit is the perfectly formatted Excel report creation in under 10 minutes. Additionally, Blitz Report overcomes the painful technical limitation where BI Publisher output in EBS 12.1.3 generates XLS instead of XLSX, capping the rows at 65,536.
- Customer June 9, 2022 at 9:59 pm
  Does converting a BI Publisher report also automatically enable us to utilize the Blitz Report features like integration into EBS forms via Zoom?
- Support June 11, 2022 at 11:43 pm
  Once the report logic is defined within Blitz Report, yes. Any report created can be leveraged immediately for features such as seamlessly integrating reports into EBS forms using Zoom , providing users with contextual access to the converted BI Publisher data when reviewing transactions.
- Customer June 13, 2022 at 5:57 am
  If the BI Publisher report uses multiple data sets or complex parameter logic, how does Blitz Report handle retaining that input functionality?
- Support June 13, 2022 at 12:14 pm
  Blitz Report supports defining and managing complex parameters. When converting a BI Publisher report, you replicate the core parameter functionality in the Blitz Report setup, allowing users to input criteria before execution. The tool supports assigning parameters with customized List of Values (LOVs).
- Customer June 13, 2022 at 3:24 pm
  We need assurance that the development process itself is tracked and audited.
- Support June 14, 2022 at 7:05 am
  The underlying architecture enforces accountability. When a developer or consultant uses Blitz Report to create or modify a report, it utilizes full version control with audit comments tracked directly in the EBS instance.
Author
Replies