Getting the concurrent output into Excel Sheet

-- ---------------------------------------------------------------------------------
-- Purpose : Steps to get the concurrent output into Excel Sheet
-- Date      : 20.May.2009
-- Created by : Chaitanya
-- .....
-- ---------------------------------------------------------------------------------

1. To get the output in the excel format from concurrent output we need to modify any Viewer Options like (PCL).

Navigation path System Administrator à Install à Viewer Options

2. The below is the update statement which will change the PCL viewer
option to excel. After this updates the concurrent programs whichever is having
output type as PCL will open directly in ExcelSheet.

Statement: update fnd_mime_types_tl

set mime_type = 'application/vnd.ms-excel'

,description = 'Excel (SYLK) used to be application/vnd.hp-PCL: Printer Control Language'

,last_update_date = sysdate

where file_format_code = 'PCL'

and mime_type = 'application/vnd.hp-PCL';

commit;

Viewer Options Screen.

3. Run the concurrent program which is having the output type as PCL to test the excel output.

==============================================