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

mist123

Summary

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

Content

Hi All,

 

I have number column in rtf template, column to be able to display up to 5 decimals

 

Using this Tex to display: 9,999,999.00 & Format: #,##0.00, but it is printing as 7,295.67

 

I want 7,295.67000

 

Could you please help me?

Dir_Pal

try this

<?format-number:fieldname;’999G999D99′?>

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2566

Dir_Pal

Use it in ur sql query

Dir_Pal

<span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">TO_CHAR</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">(<span style="font-weight: bold; font-size: 12px; font-family: Arial, Tahoma, Verdana; background-color: #f5f5f5; color: #000000;"><span class="hiddenSpellError" style="font-weight: inherit; font-style: inherit; font-family: inherit;">fieldname</span></span></span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="str" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">'9,999,999.99'</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">);</span>

Dir_Pal

Or u can format in sql data model by using

https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/sql_elem.htm#34512

mist123

How to use to-char?

Dir_Pal

<?format-number(Line_number, '#,##0.00', 'myFMT')?>

Dir_Pal

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

mist123

Hi Experts,

Could you please help me on this?

mist123

I have used

<?format-number:LINE_AMOUNT;'999G999D99999'?>

But still it is showing like this.

14,589.52

FYA...old code for LINE_AMOUNT

Could you please help me?

Violeta F

Hi,

You can generate more than 2 decimals only for .xlsx output, For the other formats, maximum number of decimals is 2.

Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it.

Regards,

Violeta

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 ​,​