Sunday, October 6, 2013

Add Fonts for Financial Reporting (FR) Reports to generated in PDF


Back Again.. J

This time I will cover how to generate Financial reports in PDF format with customized/standard fonts on 11.1.2.2 …
I know there is one article available on Oracle support portal which describes how to achieve it..
How to Add Fonts so the Financial Reporting (FR) Reports Generated in PDF Preview are the Same as in Web Preview (Doc ID 1561574.1)

But this article works well on windows platform as you will see single font file (Well as much I have seen…and frankly speaking I haven’t tested the same on windows platform…Just now got this thought J)
As you all know that starting from 11.1.2.2 ..PDF generation can be run on unix as well…

When you copy font to unix box…It generates 4 files for all style separately. Like Regular, Italic, Bold Italic, Bold Regular.
Now manually updating the xdo.cfg file is tough task as you have to be careful for weight and style..

Anyhow Oracle has given the utility for this then why to do such manual had work..

Just copy the fonts to any of the font folder location..
Like MIDDLEWARE_HOME/jdk160_29/jre/lib/fonts..

Give required permission to those fonts file.
Now use FRPrintServerUtility.sh this will update your xdo.cfg file with new font entries once you add that font location (By default utility searches for the all fonts on server) .

Note: By default this utility set to “Auto ” Mod which means it will update the xdo.cfg file by its own. If  You want to take control, you can change the option by simply editing FRPrintServerUtility.properties (Auto, console, gui are the other option which can be used)
And now you are ready to test the report in PDF format..

Now Some tricks:

How To Launch Financial Reporting (FR) Batches from a Command Line in EPM 11.1.2 (Doc ID 1292512.1)

User don’t want to expose the admin password for running ScheduleBatch to generate report from command line (Asked on OTN)

You can use EncodePassword utility (Which is available at same location) to generate the encrypted password and use it so no need to worry about password leak J ..And yes you can use same encrypted password in your report xml definition as well..