GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

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



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape