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 /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory /home/appprod/.
appdev@ctssd $ pwd
/u01/erpapp/10.1.2/tools/admin
appdev@ctssd $ cp prefs.ora /export/home/apptest
Note: Bounce apache service.
After doing above steps issue resolved.
Comments
Tags: #dba_immam, #dbaimmam, #immam_dba, #immamDba, #oracle, #woesofdba, Checking Tablespace Utilization In Oracle, Oracle DBA, REP-0004, REP-0004: Warning, REP-0004: Warning: Unable to open user preference file, Tablespace Utilization In Oracle, Unable to open user preference file