How to show text format output in Excel in Oracle Applications

While defining any concurrent program, the default output format is ‘Text’ as shown below, so the program will open the report output in browser.

If we want to take the report output in Excel format, though the output format is 'Text', we need to do the following steps.

Go to System Administrator à  Profile à System

Query for ‘Viewer%’

Go to Install à Viewer Options

Click on Text -> Add one more line with Text and give Mime Type as ‘application/vnd.ms-excel’ and description as ‘Microsoft Excel’ and check “Allow Native Client Encoding” check box and save it. This will allow us to take the Text format output either in ‘Browser’ or ‘Excel’.

For testing, run any report and view the output, Tools -> Copy File, it will give the Viewer Options LOV as shown below:

Note: The above illustration is for the programs which we write in PL\SQL Program and report output format is in Text in concurrent program definition.