column to be able to display up to 5 decimals in EBS Bi publisher

Dir_Pal

https://docs.oracle.com/cd/E23943_01/bi.1111/e22254/extend_func.htm#BIPRD3163

mist123

used like as you suggested but no luck.

mist123

Is this syntax <?xdofx:TO_CHAR(fieldname, '9,999,999.99')?> will display 5 decimals?  like 1,000.00000

Dir_Pal

in the Add help Text use this

<?xdofx:TO_CHAR(fieldname, '9,999,999.99')?>

or

<?xdofx:TO_CHAR('9,999,999.99')?>; might help u

Dir_Pal

In format field G= thousand separator and D = decimal separator  are you using in right way as per your requirement <?format-number:fieldname;’999G999D99′?>

mist123

Thank you Violeta,

It was printing if  the LINE_AMOUNT is like 200, but it is not working if i have 2,000.00(the generated XML data tag)

FYA...if the XML data tag generated  2400.52  then it will be working for me(2400.52000), but the data was generated like 2,400.52.

Please let me know if any questions

mist123

Thank you for help!

Have u tried to_char () in ur orginal query????

No, i can't

PO_STANDARD_PO.xsd is the source file which is having xml code.

Sample code: <xs:element ref="LINE_AMOUNT" minOccurs="0"/>

I used <?format-number(LINE_AMOUNT, '#,##0.00', 'myFMT')?> in rtf template but getting

Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert 14,589.52 to number.

@Kevin ​,​