REP-0004 Warning Unable to open user preference file.

Introduction: – 

 
The Likely cause of this issue is prefs.ora file is missing in Application user’s $HOME. We need to copy this to $HOME. Oracle Report Builder warning in r12 REP-0004 Warning Unable to open user preference file.
 
 

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

 
 
Error: – Showing in concurrent request log while ran Oracle Report in E- Business Suite.
 
 
REP-0004 : Warning: Unable to open user preference file.
 
Cause :-
 
The possible cause of this error (Oracle Report Builder) is following.
 
 
Cause 1:
 
The file prefs.ora was not found under the specified name in the specified location (User $HOME).
 

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

Solution:-

 
To resolve the warning permanently, copy the prefs.ora under user
 
Home file from Report Builder ($ORACLE_HOME/tools/admin).
 
 

Example:-

 
copy prefs.ora from $ORACLE_HOME/tools/admin to $HOME
 
cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/prefs.ora
 

Useful Posts:-

https://readmeout.com/how-to-run-autoconfig-on-patch-file-system-in-r12-2/

PRCD 1119 failed to create database while using dbca.

Leave a Comment