Search This Blog

Friday, April 27, 2012

“REP-0004: Warning: Unable to open user preference file” while running reports.

=*=*=*=*=* Error: REP-0004
Text: Warning - "Unable to open user preference file". while running reports.


Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.
The possible causes of this error include the following:

Case 1: The file was not found under the specified name in the specified location.

Case 2: You lacked the necessary privileges to open the file.

Case 3: A system error made it impossible to open the file.


You can take the following actions to rectify this error:

Case 1: Make sure the file prefs.ora is located in your "home" directory.

Case 2: Make sure that you have the privileges necessary to access the file. If you don't, change your privileges accordingly.

Case 3: Consult your operating system documentation or contact your system administrator.


The preferences file referred to above is:

ORACLE_HOME\CAUPREFS.ORA (user preferences)
ORACLE_HOME\CAGPREFS.ORA (global preferences)

your_home_directory/prefs.ora (user preferences)
$ORACLE_HOME/tools/admin/prefs.ora (global preferences)

Simple Way:

Check whether u have prefs.ora file in your application user's home

eg: prefs file should be in /home/applmg/prefs.ora

if not please copy prefs.ora file from  $ORACLE_HOME/tools/admin/prefs.ora  to /home/applmg/prefs.ora location.

Run your concurrent request/program.

*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=* =*=*=*=*=* =*=*=*=*=* =*=*=*=*=* =*=*=*=*=* =*=*