Rishi

• Nov 19th, 2005

 

If your responsibility is end dated then ask the apps dba to remove the date from Effective Date (To) field. 

Deepthi

• Nov 29th, 2005

 

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.

geocove

 Profile Answers by geocove 

• Feb 10th, 2006

 

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!

Nitin Agarwal

• Mar 16th, 2006

 

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

Manoj

• May 2nd, 2006

 

Please run the following concurrent program

Workflow Directory Services User/Role Validation

Brinda

• Jul 24th, 2006

 

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;
/