Could you please confirm if the same issue is encountered when application is accessed via local login?
1. Please run the following sql query in the eBiz database to check the relevant profile options and provide the sso_profiles.csv:
set echo on
set feedback on
set pagesize 400
set linesize 500
column SHORT_NAME format A40
column NAME format A50
column LEVEL_SET format a15
column CONTEXT format a30
column VALUE format A60
spool sso_profiles.csv
select p.profile_option_name SHORT_NAME,
decode(v.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
'UnDef') LEVEL_SET,
decode(to_char(v.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'UnDef') "CONTEXT",
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(p.profile_option_name) in (
'APPS_SSO',
'APPS_SERVLET_AGENT',
'APPS_AUTH_AGENT',
'APPS_SSO_HINT_COOKIE_NAME',
'APPLICATIONS_HOME_PAGE',
'APPS_LOCAL_LOGIN_URL',
'APPS_PORTAL',
'APPS_PORTAL_LOGOUT',
'APPS_SSO_AUTO_LINK_USER',
'APPS_SSO_LINK_SAME_NAMES',
'APPS_SSO_ALLOW_MULTIPLE_ACCOUNTS',
'APPS_SSO_LOCAL_LOGIN',
'APPS_LOCAL_CHANGE_PWD_URL',
'APPS_SSO_CHANGE_PWD_URL',
'APPS_SSO_LDAP_SYNC',
'APPS_SSO_OID_IDENTITY',
'APPS_SSO_FORGOT_PWD_URL',
'APPS_SSO_LISTENER_TOKEN',
'APPS_DATABASE_ID',
'PASSWORD_CASE_OPTION','SIGNON_PASSWORD_CASE')
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
order by user_profile_option_name, level_set;
spool off
1. Please run the following sql query in the eBiz database to check the relevant profile options and provide the sso_profiles.csv:
set echo on
set feedback on
set pagesize 400
set linesize 500
column SHORT_NAME format A40
column NAME format A50
column LEVEL_SET format a15
column CONTEXT format a30
column VALUE format A60
spool sso_profiles.csv
select p.profile_option_name SHORT_NAME,
decode(v.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
'UnDef') LEVEL_SET,
decode(to_char(v.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'UnDef') "CONTEXT",
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(p.profile_option_name) in (
'APPS_SSO',
'APPS_SERVLET_AGENT',
'APPS_AUTH_AGENT',
'APPS_SSO_HINT_COOKIE_NAME',
'APPLICATIONS_HOME_PAGE',
'APPS_LOCAL_LOGIN_URL',
'APPS_PORTAL',
'APPS_PORTAL_LOGOUT',
'APPS_SSO_AUTO_LINK_USER',
'APPS_SSO_LINK_SAME_NAMES',
'APPS_SSO_ALLOW_MULTIPLE_ACCOUNTS',
'APPS_SSO_LOCAL_LOGIN',
'APPS_LOCAL_CHANGE_PWD_URL',
'APPS_SSO_CHANGE_PWD_URL',
'APPS_SSO_LDAP_SYNC',
'APPS_SSO_OID_IDENTITY',
'APPS_SSO_FORGOT_PWD_URL',
'APPS_SSO_LISTENER_TOKEN',
'APPS_DATABASE_ID',
'PASSWORD_CASE_OPTION','SIGNON_PASSWORD_CASE')
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
order by user_profile_option_name, level_set;
spool off
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete