3 Replies Latest reply: Jul 23, 2012 11:06 PM by 783334 RSS

    to_char not working in eText Template


      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 -


      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 ?