Introduction:

This Post illustrates the steps required to Change the Employee User accounts to ‘SSO’ from ‘LOCAL’ in Oracle EBS .

Script:

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 (
SELECT email_address
FROM apps.per_all_people_f
WHERE 1 = 1
AND employee_number IN (‘WAM245’)));
BEGIN
DBMS_OUTPUT.put_line
(‘—————-Applications SSO Login Types Profile Updated to LOCAL————-‘
);
DBMS_OUTPUT.put_line
(‘————————-Profile Updatation Started  —————————–‘
);

FOR i IN UID
LOOP
–L_SUCCESS := FND_PROFILE.SAVE(‘APPS_SSO_LOCAL_LOGIN’,’LOCAL’,’USER’,i.user_id);
l_success :=
fnd_profile.SAVE (‘APPS_SSO_LOCAL_LOGIN’, ‘SSO’, ‘USER’, i.user_id);

IF l_success
THEN
DBMS_OUTPUT.put_line (i.user_name || ‘==>’ || ‘Success’);
ELSE
DBMS_OUTPUT.put_line ( ‘Profile Update Failed . Error:’
|| SQLERRM
|| i.user_name
);
END IF;

COMMIT;
END LOOP;

DBMS_OUTPUT.put_line
(‘————————–Profile Updatation Completed——————————‘
);
END;

Queries

Do drop a note by writing us at venkatesh.b@doyensys.com or use the comment section below to ask your questions

 

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search