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

R12: Executing A Report Fails With REP-0004: Warning: Unable
to open user preference file.
On an E-Business Suite Release 12.1.3 – when attempting to
execute a Report the following error occurs:
ERROR: 
 
REP-0004: Warning: Unable to open user preference file.
Cause:
In Release 11i the Environment Setting
ORACLE_LOCALPREFERENCE has been used to store this setting in the ad80ux.env
file, which has been sourced for the execution of an Concurrent Program.
In Release 12 you can find the Setting in the Contextfile,
but is has been removed to be used in the Environment file.
Published Bug 11063588 – ORACLE_LOCALPREFERENCE REMOVED IN
R12 has been created for this issue and a fix has been created but no Patch has
been released yet.
SOLUTION
To implement the solution please execute the following
steps:
Workaround :
1 – Backup file $AD_TOP/admin/template/iAS_1012_env.tmp
mv $AD_TOP/admin/template/iAS_1012_env.tmp
$AD_TOP/admin/template/iAS_1012_env.tmp.org
2 – Edit  file
$AD_TOP/admin/template/iAS_1012_env.tmp and add the following:
ORACLE_LOCALPREFERENCE=$ORACLE_HOME/tools/admin
export ORACLE_LOCALPREFERENCE
3 – Execute autoconfig
4 – Start the services and execute the failed Concurrent
Request again and verify that the Workaround worked.
  • January 4, 2018 | 28 views
  • Comments