This discussion is archived
11 Replies Latest reply: Oct 9, 2012 2:24 PM by Hussein Sawwan-Oracle RSS

Disable Oracle apps user accounts

Sivamani Newbie
Currently Being Moderated
Hi,

i have a list of oracle apps user account that is tied up with inactive users using the following query

select * from fnd_user a where employee_id not in (select distinct person_id from per_all_people_F a where trunc(sysdate) between trunc(EFFECTIVE_START_DATE) and trunc(EFFECTIVE_END_DATE) and current_employee_flag = 'Y')

Now i want to disable all the users (from the above query) at a single movement.Please tell me how i can do this.


Using this (fnd_user_pkg.updateuser(x_user_name=>'JJJJJ',x_owner=>'CUST',x_end_date=>SYSDATE); ) i can disable one by one ..But i want to disable for around 250 users..Please tell your suggestions


Thanks

Edited by: Ayyapan on Oct 8, 2012 10:41 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points