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