Unable To Authenticate Session in R12

Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance

ERROR
———————–
“Unable to authenticate session”

This can happen after the instance is cloned or any changes happened to the system with wrong parameter

The first log which you should check in case of this error is

$INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

Here are some common errors which you might see

Error 1

html: chain failed  javax.servlet.ServletException: java.lang.RuntimeException: Unable to create user session. Please contact your System Administrator.
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:780)

Error 2

oracle.apps.fnd.framework.OAException: Could not load application module
‘oracle.apps.fnd.sso.login.server.MainLoginPageAM’.
Detail 0 ##

oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: ICX_SESSION_FAILED.

 

How to solve the issue

  1.  First check if the R12.0/R12.1  is in maintenance Mode .If it is still in Maintainance mode.

Disable it

sqlplus apps/apps ${ORACLE_SID} apps` @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

Bounce all the services

$ADMIN_SCRIPTS_HOME/adopmnctl.sh stopall$ADMIN_SCRIPTS_HOME/adopmnctl.sh startall

 

2.   Check the database for error in alert_log.it might be possible some APPS% tablespace are full and session creation is a failing

check for free space

select sum(BYTES/1024/1024) from dba_free_space where TABLESPACE_NAME like ‘&1’;

Add the space

alter tablespace <tablespace name> add datafile ‘+DATA’ size 1000M;
  1. Guest user may be end-dated
SELECT user_name,TO_CHAR(start_date,’DD-MON-YYYY’),TO_CHAR(end_date,’DD-MON-YYYY’) FROM FND_USER WHERE user_name = ‘GUEST’;

If it is end dated, remove it  and bounce the services

You might also want to check if GUEST user is working fine

select fnd_web_sec.validate_login(‘GUEST’,’ORACLE’) from dual;
  1. The profile Initialization SQL Statement – Custom  may be wrongly set. Please check the profile at the site level,user level
set linesize 140
set pagesize 132
column SHORT_NAME format A30
column NAME format A40
column LEVEL_VAL format 999999999
column VALUE format A60 wrap
set lines 200;
col SHORT_NAME format a30;
col NAME format a35;
col VALUE format a30;
select
p.profile_option_name SHORT_NAME,
n.user_profile_option_name NAME,
decode(v.level_id,
10001,’Site’,
10002,’Application’,
10003,’Responsibility’,
10004,’User’,
10005,’Server’,
10006,’Organization’,
‘UnDef’) LEVEL_SET,
v.level_value LEVEL_VAL,
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(n.user_profile_option_name) like upper(‘%&profile_name%’)
and v.level_id= &LEVEL;
  1. Look for invalid in the database
set lines 120
set pages 5000
select owner,object_name,status
from dba_objects
where status !=’VALID’;

Compile the APPS schema using adadmin utility and bounce the services

6.  Try compiling jsp

cd $COMMON_TOP/_pages
find . -name “*” -exec rm -rf {} \;cd $FND_TOP/patch/115/bin
./ojspCompile.pl –compile –flush -p 5
logfile set: /xyz/ojspc_error.log
starting…(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
enumerating jsps…8000
parsing jsp…8000
writing deplist…8000
initializing compilation:
eliminating children…5912 (-2088)
translating and compiling:
translating jsps…5912/5912 in 1m40s
compiling jsps…5912/5912 in 4m19s
Finished!

7.  Look into FND_NODES and check if we have duplicate entries for SERVER_IP

select NODE_NAME, SERVER_ID, NODE_ID
from FND_NODES;
  1. Check the DBC in $FND_SECURE and find out if it is correct

Sometimes APPLSYSPUB password may be wrong in dbc files. correct it and bounce the services and try again

9.  Look for all the Important schema name and their password

APPS

APPLSYS

APPLSYSPUB

You can try login into these schema with the password and verify them

10.  If it is some configuration issue. Autoconfig might help. Try running autoconfig  and check the result again

I hope this helps in solving the issue with problem .Please do let me know if I can help in some way

Related Articles

How to assign User management Responsibility to user in R12

Guest User password in 11i/R12

APPLSYSPUB schema

Step by Step resolution for the problem oacore not coming up in R12

R12.2/R12/11i Common log file locations

User Preferences of your E-Business Suite homepage

JRE not found message while running runInstaller

Leave a Reply