How to Create an Excel Report in Oracle Apps

  You can follow below steps to  create Excel report in Oracle Apps

Step 1: 

Design required columns in Excel Sheet 

Step 2:

Save As the Excel sheet in XML Spreadsheet format

 

Step 3:

Get the XML code by open that in notepad/Notepad++

Step 4:

Remove field ss:ExpandedRowCount from the tag Table 

 

  

Step 5:

Create package Spec and Package body .

  

Step 6:

Create executables and concurrent program with output format in XML 

Step 7 :

 Make sure the XML file format should have the mime type excel in Viewer 

Step 8:

Assign the concurrent program to proper request group 

Step 9:

Open the output file in viewer option Microsoft Excel 

Sample Output: