How to capture Images and Logos in Excel Report Output from Oracle XML RTF Template - Oracle EBS R12

https://xmlpublishertemplate.blogspot.com/2019/01/how-to-capture-images-and-logos-in.html

How to capture Images and Logos in Excel Report Output from Oracle XML RTF Template - Oracle EBS R12

Oracle don't support image embedding for Excel output.

Please use external image reference method instead of image embedding for Excel output.

Oracle can display the logo in Excel from an RTF template by following these steps.

Copy the Picture/Image in RTF Template

Oracle Supports gif, png and jpg Formats. Please don't use JPEG Format

After Copy paste the image in RTF Template. Click the image and navigate to Picture Tools > Format > Alt Text

Copy paste the Below url as it is:

url:{'${OA_MEDIA}/IMAGE_FILE.png'}

Copy IMAGE_FILE file to $OA_MEDIA directory.

Test Report

For Office 2007, please have a look at Note:1286323.1 - How To Format the Image URL in a BI Publisher RTF Template Using MS Word 2007?

it seems that the syntax changed in Office 2007

from

    url:{'$[OA_MEDIA]/image.jpg'}

to
     url:{'${OA_MEDIA}/image.jpg'}

-->>  {} instead of []

In the above URL "IMAGE_FILE" is the File name which you will place it in the $OA_MEDIA directory with the same name. Anyhow, you can change the name as you like. But, keep the names same which you have in Alt Text box and the file you have copied in $OA_MEDIA directory.

http://oracleapps88.blogspot.com/2016/03/how-to-insert-images-and-logo-in-xml.html

How to Color a field in XML RTF Template with Condition - Oracle EBS R12

https://xmlpublishertemplate.blogspot.com/2019/01/how-to-color-field-in-xml-rtf-template.html

How to Color a field in XML RTF Template with Condition - Oracle EBS R12

Please make three Text form field Options


<?if:USER_DESC!=''?>
<xsl:attribute      xdofo:ctx="block" name="background-color">yellow    </xsl:attribute>

<?PER_AR?>  --FIELD NAME

<?end if?>

Different Colors in one Field or Cell (Please make three Text form field Options)

<?if:USER_DESC=''?> <xsl:attribute      xdofo:ctx="block" name="background-color">white    </xsl:attribute> <?end if?>

<?if:USER_DESC!=''?> <xsl:attribute      xdofo:ctx="block" name="background-color">yellow    </xsl:attribute> <?end if?>

<?PER_AR?>  --FIELD NAME

How to Hide first Character in XML RTF Template - EBS Oracle R12

https://xmlpublishertemplate.blogspot.com/2019/01/if-you-just-want-to-eliminate-first.html

If you just want to eliminate the first character of the string you can use this workaround. 

<?substring(STRING_TO_BE_TRIMMED,2)?>

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

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

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

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.