Run the following query and check if the source values are still there, if source values are there, then update with the cloned environment values or unset ICX forms launcher profile on site level.
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', v.level_id) 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 n.language = 'US'
AND upper(p.profile_option_name) = ('ICX_FORMS_LAUNCHER')
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;
No comments:
Post a Comment