Wednesday, August 31, 2022

How to remove spaces in RTF Based Excel Output in Oracle APPS(XML Publisher Report)

Standard Trial Balance report output is Text. So client wanted to convert this report output to Excel. After converting standard Trial Balance report to excel we found issue like amount columns having leading and trailing spaces.


With this user unable to do SUM and other mathematical calculations. 

To remove spaces use below xdo function.
<?xdoxslt:trim(DISP_BEGIN_BALANCE)?>

This will remove leading and trailing spaces in Excel Output File.

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...