Wednesday, 15 August 2018

Formatting Numbers to avoid appearing in Exponential Form - Oracle EBS R12

https://xmlpublishertemplate.blogspot.com/2018/08/oracle-bi-publisher-how-to-format.html

Formatting Numbers to avoid appearing in Exponential Form

Ref#1:
https://stackoverflow.com/questions/18335486/oracle-bi-publisher-how-to-format-numbers-as-text-so-that-leading-zeroes-dont

Ref#2: http://oracleappsdna.com/2013/07/how-to-display-leading-zeros-in-xmlp-report-excel-output/





In BI Publisher properties for the field check Force LTR option
enter image description here
or you can put the following in form field help text

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?YOUR_TEL_FIELD?></fo:bidi-override>

or you can put the following in form field help text

<?xdofx:CHAISE_NUMBER||'3 spaces here'?>

No comments:

Post a Comment