Oracle Application XML Reports in EXCEL

1. Create new Viewer Option

Navigate to System Administrator àInstall àViewer Options.

Add a new entry.

File Format                                         : XML

Mime Type                                         : application/vnd.ms-excel

Description                                         : XML in Microsoft Excel

Allow Native Client Encoding          : Yes(Enable)

2. Set Profile Options

Set profile àViewer: Text to Browser

Set profile àViewer: Application to XML in Microsoft Excel

3.Submit a Concurrent Request that generates Text Output File

Click on View Output

Button

You will see a LOV showing

--> Microsoft Word(.doc)

--> Excel (.xls)

--> Notepad(.txt)

When you choose Microsoft Word(.doc) , the Text File will be transferred using the Mime Type application/msword then the browser will open the Text File in Word

When you choose Excel (.xls) , the Text File will be transferred using the Mime Type application/vnd.ms-excel then the browser will open the Text File in Excel

When you choose Notepad(.txt) , the Text File will be transferred using the Mime Type text/plain then the browser will open the Text File in Notepad