How to define a PATH for Oracle Reports Server 11G

Hello guys,

Today I am going to help you to define the Reports PATH for Oracle Reports Server 10G and 11G. Sometimes you can set up a report, but then you can get the message:

REP-52005: The specified key for the report does not exist in the keymap file

That means that the cgicmd.dat file does not have the mapping for your report. So, you need to add it like this:

E.g.:

Online Report (Thiago) Reports
THIAGO_REPORT: report=THIAGO_REPORT.rdf userid=tleoncio/***@thg destype=cache desformat=pdf %P

; Online Overtime
OP_REP: report=OP.rdf userid=tleoncio/***@thg destype=cache desformat=pdf %P

Then if you do the mapping properly, you can probably start getting these other errors:

REP-110: Unable to open file 'THIAGO_REPORT.RDF' 

REP-1070: Error while opening or saving a document. 

REP-0110: Unable to open file 'THIAGO_REPORT.RDF'

This is because now you need to define the reports path that is mapped into your cgicmd.dat file. So, you have to options:

1-It is going to your reports.sh file and add the path that your Oracle report is and save it.

2- The second option is more elegant, where you define it based on the reports server EM below.

Go to EM:
1-Open the following URL for Enterprise Manager console of 11G Forms and Reports.
HTTP://<ip-address:7002>/em

2-From the left panel, click on Report server name, e.g., rep_ag1.

3-Expand the Reports from the top and expand Administration and click on Advanced configuration.

4-Edit the value of the Report Source Directory and Reports Temp Directory.
Report Source Directory= Path to the directory where the reports are placed.
Report Temp Directory=Path to the directory where you want to create the temporary files of reports at runtime.

5-Expand the Reports from the top expand Administration and click on Basic configuration.

6-On the next window, there is an Environment Configuration Box. Give Environment name in the Add a new Environment Field, & click on Add Environment button.
Give the REPORTS_PATH variable in the name field and give the path in the value And then click on the apply button.

7- Note: If you choose this option, don't give the path in reports.sh file, as the path is defined during this process.

8-After make changes restart the report server.

9- Test the reports, please. It now should work just fine.

Have fun and happy coding.

Thiago Leoncio.