Oracle BI Publisher Process Flow

As you have seen a brief introduction to BI/XML Publisher in my last post, today let us see the steps involved in processing a report using BI/XML Publisher.

1.Run the desired concurrent program.
2.The concurrent program calls the data template using the XDO (Extensible
data object) engine.
3.The data template calls the SQL query.
4.The query runs in the database and output is converted to XML.
5.XML output is generated by XML engine.
6.The OPP (Output post processor) formats the output based on the XML Publisher
template you have chosen and creates the final output like pdf, word, excel
and web page.
7.Output delivered to the User.

BI/XML Publisher XDO data engine plays an important role in generating the reports.The XMLP Report business service is the interface to this logical component that initiates the Java services to load the JAR files to the JVM. The Oracle BI Publisher XDO Engine then processes the XML data, XSL template to generate the report. We can also configure the XDO engine to create log files that can capture detail information and errors while generating the reports. The log files are more helpful in determining the cause of problems with the JAR files or the Oracle BI/XML Publisher layout templates.