How to integrate an XML Report with Oracle


Register an RTF File with Oracle APPS:

While integrating a report in System Administrator, set the Output Format to XML


Output Format of Report should be XML


  • Go to responsibility XML Publisher Administration
XML Publisher Administration


  • Press the button “Create Data Definition”
Create Data Definition in XML Report

Give the Name and code same as RDF name of the report.  Select the application accordingly e.g. Human Resources.

  • Once Data definition is created, you need to create a template after it.
Creating Template in Xml Report Integration

Provide the name and code as reports’ RDF name. Select the data definition as you defined while creating ‘Data Definition’.

Default Output Type: Select the default Output type. E.g. EXCEL if you want to show your report in excel format.

Template File:  Browse and select the RTF file in which you created the format.

Language: Select the language accordingly.

Your feedback is much appreciated.

Value Sets in Oracle Apps

Leave a comment for any query.







0 comments: