Opening of Report output in Excel format in Oracle Apps

Problem:

Normally in Oracle applications client want to open the report in excel format.

Solution

Step1:

Create a two profile options

EXCEL_DELIMITER –It may be ‘|’ or ‘.’ .User can set globally the value

EXCEL_TEXT_QUALIFIER— It is used for text characters

Sample code

G_QUALIFIER || rOnhand.subinventory_code   || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.locator_code        || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.item_number         || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || vItemRev                    || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.item_description    || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.uom_code            || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.lot_number          || G_QUALIFIER || G_DELIMITER ||

G_QUALIFIER || rOnhand.onhand_quantity     || G_QUALIFIER

Cheers

Share on Google Plus

About sekhar

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.