Thursday, October 30, 2014

End Date all users in EBS 11i after cloning

End Date all users in EBS 11i after cloning

select count(*) from fnd_user;

create table fnd_user_bkp as select * from fnd_user;


DECLARE
CURSOR cur1
IS
SELECT user_name
FROM fnd_user
WHERE user_name NOT IN ('SYSADMIN', 'GUEST')
AND (end_date IS NULL OR TRUNC(end_date) > TRUNC (SYSDATE));
BEGIN
FOR all_user IN cur1
LOOP
fnd_user_pkg.updateuser (x_user_name => all_user.user_name,
x_owner => 'SYSADMIN',
x_end_date => SYSDATE
);
COMMIT;
END LOOP;
END;


How to End-Date/Delete an Applications User (Doc ID 1064798.1)

No comments:

Post a Comment

Some Tips About FNDLOAD

Data Synchronization  Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...