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.
The possible cause of this error (Oracle Report Builder) is following.
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.
To resolve the warning permanently, copy the prefs.ora under user
Home file from Report Builder ($ORACLE_HOME/tools/admin).
copy prefs.ora from $ORACLE_HOME/tools/admin to $HOME
cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/prefs.ora
PRCD 1119 failed to create database while using dbca.