The value (hostname or ip_address) in their browser cookie(s) (domain field) should match the value (hostname or ip_address) in the database table icx_parameters column session_cookie_domain.
Not required to change in profiles.
Kill all active inactive sessions of user. Reset password of user.
Sample code for kill session is below -
2 str varchar2(100);
4 for S in (select sid,serial# from v$session where username is not null
5 and username != 'SYS')
7 str := 'alter system kill session '||chr(39)||S.sid||','||S.serial#||chr(39);
8 execute immediate str;
9 end loop;
Hope it resolve your issue.
There is no inactive and active sessions from the particular client identifier the in gv$session.
Thanks for the replies..
it was the browser issue. The user is accessing the EBS application through citrix and the browser's bad cache's and cookies are not cleared properly in citrix. It's been resolved once the citrix for the user has been reset.
Thanks for all your recommendations.