A day in the life of an Oracle Applications Consultant

Printing Reports in PDF format with Oracle Applications

This post explains how you can modify an Oracle Applications report output format so that it displays as a PDF document. It also outlines how to fix a recent error I received when trying to generate PDF reports.

Oracle Applications allows you to print your reports in a variety of formats. To change the report output format you will need to have access to system administrator responsibility and navigate as follows: - Concurrent > Program > Define. Using the Query or find facilities retrieve the report name you would like to print in PDF format. In the “Output” area of the form as displayed in Fig.1 you will notice a drop down box which gives you the following options: -

  • HTML
  • PCL (HP’s Printer Control Language)
  • PDF
  • PostScript
  • Text
  • XML

It should be noted that if you choose HTML or PDF as the output type with Oracle Reports Programmes, you should use a printer driver that handles HTML or PDF files. Selecting PDF as the format output will ensure that the next time you print the report and view the output, it generates in PDF format (you will only be able to view it if you have Acrobat PDF Reader installed on your PC).

Figure 1: How to modify your report output format to print a PDF Document

Click to view an enlarged image of where you should choose the report output format

Personally, I quite like this option to view output in a PDF document type since it looks a lot “prettier” than looking at the report in plain text or HTML format. You also have the option of saving a copy of the file to your local PC in much the save way as you could save the text or HTML output locally.

One thing I would like to know from any readers that have utilised this feature is whether it’s possible to make use of the security features of Acrobat (such as controlling content copying or extraction) within Oracle Applications so that when the report is generated you have control over the content and form of the document.

Fixing an error received on PDF generation

Last week I received a bizarre error message when trying to view the output of a report whose format was PDF. The error message was - File does not begin with ‘%PDF-’. Considering I was not encountering this message when using other PC’s it became clear to me that the problem was related specifically to my PC. A quick search on Metalink revealed note 206727.1 which made me realise that somewhere along the line I needed to change my browser settings for Internet Explorer. I made the following changes to my brower options which rectified the problem.

Selected Tools > Internet Options > General tab > Settings. Under “Check for newer versions of stored pages” there were four possible selections: -

  • Every visit to the page
  • Every time you start Internet Explorer
  • Automatically
  • Never

I had “Every visit to the page” selected and discovered that choosing any of the other three options would now successfully generate my PDF report within IE when choosing to view report output.

Posted by Richard Byrom on 08/16 at 09:28 PM
  1. Hi,

    I am facing problems regarding showing a logo (.bmp) file in cognos (PDF) report.
    Is there a way to insert an image into a PDF file?  I have a GIF file I’d like to insert.


    Posted by .(JavaScript must be enabled to view this email address)  on  10/10  at  01:18 AM
  2. Hi,

    Very insteresting options indeed. Now would it be possible to have the USER select which outputs he/she wants everytime the report is ran?

    Posted by .(JavaScript must be enabled to view this email address)  on  12/21  at  11:56 PM
  3. i’m wondering if you’ve found a methodology for applying this process to the use of a PDF overlay? i’ve got a purchase order form that get’s printed out on expensive po paper since oracle just spits out the data. we would like to see if it would be possible for it to “print” the po directly to a pdf overlay that looks exactly like the PO paper that we’re using. we email A LOT of our POs (and the rest get faxed from the PC) but the purchasing girl has to print the PO first, then scan it back in before she can do any of this so that it gets on the proper layout. if there were a way for the PO to print out in the proper format then we’d save the print/scan steps

    Posted by .(JavaScript must be enabled to view this email address)  on  03/19  at  11:23 PM
  4. David, you should be able to achieve what you want to do using Oracle Reports

    Posted by Richard Byrom  on  11/18  at  03:10 AM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: