Saturday, June 29, 2019

1. Please run the following sql query in the eBiz database to check the relevant profile options and provide the sso_profiles.csv:

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 

3 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete