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..

Unable to Open HFR in PDF format

This is going to be a quick and short update.

 There is nothing new in this post , I think most of the people know this as of now. But yes it will help those who don't know yet.

I will start it like ....We have faced an issue with FR reports specially when user try to open it in PDF on 11.1.2.2.

After lots of testing, checking all the configuration components and registry then also we haven't got any clue for the cause of issue.

We tried to apply all the latest patches, But still no luck. In such situations, off course we have to dig further from over end  right :) and While deploying the components on other environment, we found that once we change the JVM from  jdk to JRocket, We use to get below error.

Error Detail:

We have tried to research a lot and at last got the jack pot.

Post updating the below setting on the deployment script of FR which you can get under below location.

$HOME/Oracle/Middleware/user_projects/bin/deploymentScripts.

-Dprop.PrintServers=EmbeddedPrinting -Dprop.UseClassicPrintEngine=false

" This will start the print server separately."

Issue got resolved. All thanks for the development team (We :) ) who jumped in, I really don't know if a bug has been raised with vendor for this to update the above settings in properties file in auto-generating mode rather then manual intervention.

Hope this helps to those who are willing to consider Jrocket as JVM to enhance the performance of the system.

As The headline of Blog Says: I am doing the same work :)