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.