Oracle Fusion HCM Tutorial Blog

Basic XML Publisher Report

Overview: Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. User can generate output in PDF, XML, TEXT, HTML, RTF at run time.

Pre requisite: 1) Word configured with XML Publisher Desktop

Steps:

Step 1 : Develop simple tabular RDF report using Oracle Report Builder.

Name of the Report - Test.rdf.

Place this RDF report on server $CUSTOM_TOP/reports/US.

Step 2: Create the concurrent executable for this Report.

Navigation: Application Developer Responsibility->Concurrent->Executable

Step 3: Create a concurrent Program for executable which we declared above.

Navigation: Application Developer Responsibility->Concurrent->Program

Note: 1. Make Sure Output Format should be XML

Define the Parameter as per your need.(For this Click on Parameters button and define).

Step 4 : Add this concurrent program to Custom Applications request group.

Navigation : System Administrator -> Security -> Responsibility -> Request

Step 5: Run this Test Report from the responsibility where you added this report in request group.

Navigation : View -> Requests -> Submit a New Request -> Single Request.

Step 6: Save the XML generated by above request.

Navigation : View -> Requests -> Find -> View Output (your request)

Generated XML will open in browser.

Save this XML.

Step 7: Creation of Template using word configured with XML/BI Publisher.

All Above are the static Tags.

Save this template.

Note : Template should be save with .rtf extension

Step 8: Load the XML

Load the XML which we saved in Step 5.

Navigation : Sample XML -> Browse your saved XML file -> Open

Adding repeating rows, Click on Fields.

You can see G_EMPLOYEE_NUMBER is the repeating group so need do use For Loop to fetch all employees.

Navigation : Click Repeating Group

Select the group in for each column.

Here you can see for loop tags are generated on template.

Step 9: Add remaining the tags in template

Click on Fields and select the tag which you want to insert.

Click on insert.

In the same manner you can insert rest tags in template.

We have completed our template now. To confirm the output of template we built. Click on preview option such as PDF,XLS,RTF etc(Highlighted in below screenshot).