GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  AOL
Go To First  |  Previous Question  |  Next Question 
 AOL  |  Question 15 of 34    Print  
How do i recover the responsibility in apps if it is disabled?
post your answer


  
Total Answers and Comments: 6 Last Update: May 10, 2008     Asked by: devesh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 19, 2005 12:24:36   #1  
Rishi        

RE: How do i recover the responsibility in apps if it ...
If your responsibility is end dated then ask the apps dba to remove the date from Effective Date (To) field.
 
Is this answer useful? Yes | No
November 29, 2005 04:59:27   #2  
Deepthi        

RE: How do i recover the responsibility in apps if it ...
From FND_RESPONSIBILTY table. Query the table for the reponsiblity u need.The column to query is responsiblity_key. If there is a end_date and the end_date < sysdate it means the responsibilty is disabled.
 
Is this answer useful? Yes | No
February 10, 2006 02:59:08   #3  
geocove Member Since: February 2006   Contribution: 2    

RE: How do i recover the responsibility in apps if it ...
Hi Try the following:step 1:SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL FND_RESPONSIBILITY WHERE FND_RESPONSIBILITY.END_DATE > SYSDATEAND FND_RESPONSIBILITY_VL.RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID;step 2:update the end_date fields for your responsibilities (query by ID in the fnd_responsibility table).good luck!
 
Is this answer useful? Yes | No
March 16, 2006 16:15:58   #4  
Nitin Agarwal        

RE: How do i recover the responsibility in apps if it ...

We can also recover through the following steps:

Go to system administrator responsibility > Security > Responsibility > Define > Give the particular responsibility name query on it and then see the effective dates to field. If any date is there then that repsonsibility will expire on that date and if it is null then it will not expire on any date.

Cheers!

Nitin


 
Is this answer useful? Yes | No
May 02, 2006 15:00:29   #5  
Manoj        

RE: How do i recover the responsibility in apps if it ...
Please run the following concurrent program

Workflow Directory Services User/Role Validation


 
Is this answer useful? Yes | No
July 24, 2006 06:31:42   #6  
Brinda        

RE: How do i recover the responsibility in apps if it ...

Here is the API script which add the System Administrator responsibility through which you add the other responsibility.

DECLARE
CURSOR c1_cur IS SELECT u.user_name
u.user_id u.end_date u.start_date u.description
FROM fnd_user u
WHERE u.user_name IN ('subbarab')
AND (u.end_date IS NULL OR u.end_date TO_DATE('31-dec-4712' 'dd-mon-yyyy'))
ORDER BY u.user_name;

BEGIN
FOR c1 IN c1_cur LOOP
BEGIN
fnd_user_pkg.addresp(username > c1.user_name --varchar2
resp_app > 'SYSADMIN' --varchar2
resp_key > 'SYSTEM_ADMINISTRATOR' --varchar2
security_group > 'STANDARD' --varchar2
description > c1.description --varchar2
start_date > sysdate --date
end_date > c1.end_date --date
);
dbms_output.put_line('Inserted '||c1.user_name);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('ERROR '||c1.user_name|| SQLERRM);
END;
END LOOP;
COMMIT;
END;
/


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape