Thursday, 22 November 2018

How to do Calculation in RTF

https://xmlpublishertemplate.blogspot.com/2018/11/how-to-do-calculation-in-rtf.html

<?xdofx: round(FIELD_NAME div 3) ?>

How to Format Amount in Millions in RTF

https://xmlpublishertemplate.blogspot.com/2018/11/how-to-format-amount-in-millions-in-rtf.html

<?xdofx: round(FIELD_NAME div 1000000) ?>

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'?>

Sunday, 11 February 2018

How to use Page Break in XML publisher (RTF) report based on a RDF - Oracle EBS R12

https://xmlpublishertemplate.blogspot.com/2018/02/how-to-use-page-break-in-xml-publisher.html

How to use Page Break in XML publisher (RTF) report based on a RDF

Try using <?split-by-page-break:?> in the field directly before the final "End For Each." That worked for me. Hopefully for you too. I am having issues though that it for some reason just stops mid way through and stops inserting the page break. 
Just to add a little more. I found a work around for the issue I was having where it would decided it would page break half the document but not the entire thing. Instead of the page break place your cursor directly before the group closing. Then Press CTRL+ENTER. This should work. You will end up with a blank page at the end of the document but that can be lived with.