Blog / Category
Profile Option
3 articles in this category
Oracle Application Blog
Oracle SQL to get Profile Option Values at Responsibility level
SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name, fpov.profile_option_value FROM fnd_profile_options_…
Oracle Application Blog
API to Update Profile Value – SSO to Local
DECLARE L_SUCCESS BOOLEAN; CURSOR uid is SELECT user_name,user_id from fnd_user where user_name in (select user_name from apps.fnd_user where email_address in (…
Oracle Application Blog
API to Update Profile Value – Local to SSO
DECLARE L_SUCCESS BOOLEAN; CURSOR uid is SELECT user_name,user_id from fnd_user where user_name in (select user_name from apps.fnd_user where email_address in (…