Oracle Report Builder warning in r12 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) are 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

No comments:

Post a Comment

Thanks for reading till end. I hope this will help you more to improve your knowledge.

Now it's your turn!

What do you think? Share your experience in the comments box and subscribe for more interesting post.