This discussion is archived
3 Replies Latest reply: Jul 23, 2012 9:06 PM by 783334 RSS

to_char not working in eText Template

user11972136 Newbie
Currently Being Moderated
hi,

i am building a eText Outbound template for Payments in EBS R12 using BI Publisher plugin (rtf file) and am trying to use the to_char fn as follows -

to_char(to_number(PaymentAmount/Value),’00000000000000000.00’)

i also tried without the to_number ie

to_char(PaymentAmount/Value,’00000000000000000.00’) , but the output is always just the number as it appeared in the xml.

eg if the paymentamt in the xml is 120, i want it to be shown in the rtf output as 00000000000000120.00

any suggestions ?
Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points