End date Responsibility [message #186759] |
Wed, 09 August 2006 06:52 |
anna.suntha
Messages: 5 Registered: July 2006
|
Junior Member |
|
|
Hi
Iwould like to know how can I end date a particular responsibility for group of users. Like to know an automated process for this
Regards
Anna
|
|
|
|
Re: End date Responsibility [message #186837 is a reply to message #186765] |
Wed, 09 August 2006 15:25 |
anna.suntha
Messages: 5 Registered: July 2006
|
Junior Member |
|
|
Hi Ananth
Thanks for your reply. Yes I can do it but do it manually for morethan 200 users is bit tedious. I like to know whether we can automate this process by writing a script
Regards
|
|
|
|
|
Re: End date Responsibility [message #186958 is a reply to message #186838] |
Thu, 10 August 2006 05:25 |
David.K.Dickson
Messages: 413 Registered: October 2005 Location: Surrey, England
|
Senior Member |
|
|
ngouadjeu wrote on Wed, 09 August 2006 21:47 | The following script works on 11.03
update FND_USER
set end_date=sysdate-1
where <<group of users>>;
commit;
|
This will end-date the users. The question was how to end-date a users' access to one responsibility.
Ananth's answer looks better (although I have not tested it myself).
David
|
|
|
Re: End date Responsibility [message #187052 is a reply to message #186958] |
Thu, 10 August 2006 12:27 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
You are right David.
Anna wanted to inactivate one responsibility
ANANTH are talking of FND_USER_RESP_GROUPS table ?
Anna note that user_id and responsibilty_id can be the result on one select
|
|
|