3 Replies Latest reply on Jul 24, 2012 4:06 AM by 783334

    to_char not working in eText Template

    user11972136
      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.