REP-0004: Warning: Unable to open user preference file in Oracle EBS 12.2


I would like to share one of the interesting issue which our ERP Development teams faced. They were running one RDF report and concurrent completed wiht error.

Here is the error and solution ;


Error : 

XCUSTOM CUSTOM Application: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.


Current system time is 30-OCT-2019 07:40:01

| Starting concurrent program execution…


Forcing NLS_NUMERIC_CHARACTERS to: ‘.,’ for XDO processing

APPLLCSP Environment Variable set to :

Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :



Enter Password:
REP-0004: Warning: Unable to open user preference file.

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

Solution :

Copy prefs.ora file from EBS server directory into the application user home directory. Here is my user appldev. Change the directory according to your user

cp $ORACLE_HOME/tools/admin/prefs.ora /home/appldev/



Do you want to learn Oracle E-Business Suite ( EBS ) for Junior Apps DBA, then read the following articles.

About Cihan Gedik

I am currently working as Senior Oracle Application Database Administrator. I have experienced many EBS database upgrade, migrations, Fresh EBS installations, Solaris to Linux, Windows to Linux replatform migration projects in medium and large companies and also experienced core database migration projects for one of the biggest bank of Katar.With my colleagues we decided to run this platform to share our knowledge

Leave a Reply

Your email address will not be published. Required fields are marked *