Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, January 20, 2009

Junk Characters in PDF reports in R12 using UTF8 Characterset

This was a biggest issue we were facing at the point of implementation. We were getting the reports designed in Developer and all are displayed as JUNK while submitted thro Concurrent manager in R12. Please note the errors coming out only for Custom Reports. We did the following to correct the issue.. I did it.. it worked well... these are all the steps.

In order to fix this error, execute the following steps :
  1. Take a backup of the "/uifont.ali" file.
  2. Open the '/uifont.ali' file and go to the "[ Global ]" section.
  3. Add the "Font Aliasing" entry of the 'Verdana' font in the above section by adding the following line :-

    verdana = Verdana

  4. Save the aforesaid change made in the '/uifont.ali' file.
  5. Take a backup of the '/PPD/screenprinter.ppd' file.
  6. Open the '/PPD/screenprinter.ppd' file and go to the section that contains the following lines :-

    *Font Verdana-Bold: Standard "(001.004S)" Standard ROM
    *Font Verdana-BoldItalic: Standard "(001.004S)" Standard ROM
    *Font Verdana-Italic: Standard "(001.004S)" Standard ROM
    *Font Verdana: Standard "(001.004S)" Standard ROM
  7. Modify the entry of the 'Verdana' font in the above excerpt by editing the following lines :-

    *Font Verdana-Bold: Standard "(001.004S)" Standard ROM
    *Font Verdana-BoldItalic: Standard "(001.004S)" Standard ROM
    *Font Verdana-Italic: Standard "(001.004S)" Standard ROM
    *Font Verdana: Standard "(001.004S)" Standard ROM

    as follows :-

    *Font Verdana: Standard "(001.004S)" Standard ROM
    *Font Verdana-Bold: Standard "(001.004S)" Standard ROM
    *Font Verdana-BoldItalic: Standard "(001.004S)" Standard ROM
    *Font Verdana-Italic: Standard "(001.004S)" Standard ROM

  8. Save the aforesaid change made in the '/PPD/screenprinter.ppd' file.

    Note : In case you are using any other PPD file, you need to make the changes mentioned in step nos. 5 - 8 in that PPD file.

  9. Restart the "Reports Server".

    [Note : In case the "In-Process Reports Server" is used to run the report, restart the "OC4J_BI_Forms" and the 'In-Process Reports Server'.]

  10. Now run the report designed using both 'Verdana' and 'Verdana-Bold' fonts to generate the PDF output and it will work properly

3 comments:

Anonymous said...

I am facing the same problem with Times New Roman characters in pdf. It is there in correct manner as you have described but I am not able to solve the problem

Balaji Srinivasan said...

Could you please explain me about your Pasta Configuration?

Anonymous said...

Hi,

I am facing same problem while using Times New Roman Fonts in my report. My oracle reports version is 10.1.0.2. I have followed the above steps but no success. I am not using PASTA fonts configuration.

Regs,

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments