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
