Home » Applications » Oracle Fusion Apps & E-Business Suite » End date Responsibility
End date Responsibility [message #186759] Wed, 09 August 2006 06:52 Go to next message
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 #186765 is a reply to message #186759] Wed, 09 August 2006 07:19 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi anna.suntha,

u can fix the end date by following navigation

login into Sysadmin Responsibility > Security > User > Define

call the user name and fix the end date at header level and line level


Regards,
B.T.S.Ananth

Re: End date Responsibility [message #186837 is a reply to message #186765] Wed, 09 August 2006 15:25 Go to previous messageGo to next message
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 #186838 is a reply to message #186837] Wed, 09 August 2006 15:47 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
The following script works on 11.03
update FND_USER
set end_date=sysdate-1
where <<group of users>>;
commit;
Re: End date Responsibility [message #186869 is a reply to message #186759] Thu, 10 August 2006 00:14 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

HI

THE ABOVE STATEMENT WILL UPDATE FOR ALLTHE RESPONSIBILITY FOR A SELECTED RESPONSIBILITY USE THE BELOW ONE

UPDATE FND_USER_RESP_GROUPS_DIRECT
SET END_DATE=' ' ------ GIVE THE END DATE HERE
WHERE RESPONSIBILITY_ID=' ' -----ENTER THE RESPONSIBILITY ID
AND USER_ID=' ' ---- HERE MENTION THE LIST OF USERS U WANT FIX THE END DATE, SEPERATING BY COMMAS

COMMIT



REGARDS,
ANANTH
Re: End date Responsibility [message #186958 is a reply to message #186838] Thu, 10 August 2006 05:25 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: crm_service contracts
Next Topic: MS Project Integration with Oracle Projects
Goto Forum:
  


Current Time: Fri Dec 09 06:12:25 CST 2016

Total time taken to generate the page: 0.16285 seconds