How to make XML Reports? (Create XML Reports / Create RTF Report )

How to develop XML Reports?

You can integrate and use these XML Reports in Oracle EBS.

Step 1: Write Query in Report Builder.

Step 2: Generate XML File.

Select File > Generete to > XML. It will ask you to save this XML file.

Step 3: Create a RTF File and Load XML File.

Open word and create new document with Rich Text Format.

Add-Ins > Data > Load XML Data

Step 4: Formatting XML Report.

If you want to insert all fields then follow this navigation: 

Add-Ins > Insert > All Fields.

If you want to insert a single field then follow this navigation: 

Add-Ins > Insert > Field.

Remove Spacing between lines.

After using basic word formatting:

Step 5: XML Report Preview.

You can export your xml report in following formats Excel, Rich Text Format (RTF), Power Point, PDF and HTML.

Sample Output in MS Excel:

Sample Output in MS Word: