Report Generation from BI through APEX

  • Oracle APEX is user friendly for designing part as well as client side data entry and validation related things.
  • Oracle BI Publisher is good for report output; it will give the output files like PDF, XLS etc, Very big advantage in BI Publisher is that can produce multiple output files as a report. With the option of Bursting.
  • Bursting will be scheduled with the particular time interval, or can schedule by the time as per the report need.
  • Template file is base for required output report. Because output will be produced based on the input template design.
  • In APEX, under Shared components there is an option called Report Layouts, that is getting the input template file for report designing.
  • That same navigation having the link called Report Queries, which is getting the query from user to generating report based on template and query.
  • When the user clicking on the designed button, then the Report file will be generated based on template and query.
  • The button option should be Download printable Report Query, and then only that printable option will work.
  • December 24, 2018 | 19 views
  • Comments