Total Pageviews

February 5, 2015

2/05/2015 01:48:00 AM

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_QUALIFIERIt 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