REP-0004

REP-0004: Warning: Unable to open user preference file

Metalink id:

R12: Request Logs Contain the Message "REP-0004: Warning: Unable to open user preference file" [ID 1120529.1]

Symptoms:

All concurrent requests that run REPORTS are printing the following warning in the request log.

REP-0004: Warning: Unable to open user preference file.

Cause:

This message occurs when the concurrent process attempts to open the Oracle Reports executable and your local preference file cannot be found or opened. This is just a warning, so the request will continue to run even if this occurs.

Solution:

To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.

Example:

Copy of the file prefs.ora in the directory /apps/prod/apps/tech_st/10.1.2/tools/admin/ to the directory  /home/applprod/.

[applprod@sujeet ~]$ cd /apps/prod/apps/tech_st/10.1.2/tools/admin/

[applprod@sujeet  admin]$ ls
prefs.ora  

[applprod@sujeet  admin]$ cp prefs.ora /home/applprod/

Note: Bounce apache service.

Issue resolved.

NOTE:
For a report developed by xml publisher getting the same error, create /HDDATA/xml_tmp directory (environment dependent) on the system server after checking Administration from XML Publisher Administrator responsibility -> Configuration -> General -> Temporary directory column is /HDDATA/xml_tmp.