How to format number in IBYDE_CTX_en.rtf file
Hi,
EBS 12.1.3
I am new to formatting the data for using electronic payments. There is a requirement where the amount column with 0 value should be displayed with 2 decimal values with leading 0 (zeroes) i.e. 0000000.00 format. I used the below functions to format the data but only a single 0 is displayed in the file. However the below function works fine in SQL.
TRIM(TO_CHAR(DiscountTaken/Amount/Value, ‘000000009.99’))
Also is there a guide or some sort of documentation which tells the statements, functions etc that can be used.
Thanks.