Steps For Getting The Output in Excel Format in Oracle APPS

Steps For Getting The Output in Excel Format in Oracle APPS

Logon to Oracle Applications , use System Administrator Responsibility and Navigate as :-
Install -> Viewer Options
to open the Form “Viewer Options”

Then do the entry as shown below :-

File format - Mime Type --Description
-------------------------------------------
Text - application/msword - Microsoft Word(.doc)
Text - application/vnd.ms-excel - Excel (.xls)
Text - Notepad(.txt)

Ensure that the profile option
Viewer: Application for Text
is set to
BLANK
at the Site Level

Then ensure that the profile option
Viewer: Text
is set to
Browser
at the Site Level

Then restart the Concurrent Processing Server

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
, so 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
, so 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
, so the browser will open the Text File in Notepad