Assign responsibility to multiple user in oracle apps from backend

Assign responsibility to multiple user in oracle apps from backend

In this post , We will be discuss about , how to Assign responsibility to multiple user in oracle apps from backend. I will share the Oracle Standard API to assign responsibility to multiple user in oracle apps from backend. This is one of the Standard API provided by oracle to mass assign the responsibility to multiple users in oracle apps. I will share the complete PLSQL script which helps to Assign responsibility to multiple user in oracle apps from backend. This helps to create the mass users in oracle apps from backend. Here below is the detail about how to Assign responsibility to multiple user in oracle apps from backend.

Important API to Assign responsibility to multiple user in oracle apps from backend

1.fnd_user_pkg.addresp

Detail PLSQL Script to assign responsibility to multiple user in oracle apps from backend

Declare 

  cursor get_user 

   is 

     select user_name

    from  fnd_user

     where user_name in ( ‘USER1' , ‘USER2', ‘USER3', ‘USER4', ‘USER5', ‘USER6') ; 

   cursor create_responsibilities 

   is 

     select resp.responsibility_key 

           ,resp.responsibility_name 

           ,app.application_short_name       

     from  fnd_responsibility_vl resp 

          ,fnd_application       app 

     where resp.application_id = app.application_id  

     and   resp.responsibility_name in ( 'Application Developer' ) ; 

 begin 

   for c_user in get_user  loop 

   for get_resp in create_responsibilities  

   loop 

     fnd_user_pkg.addresp (

                username        => c.user_name 

               ,resp_app        => get_resp.application_short_name 

               ,resp_key        => get_resp.responsibility_key 

               ,security_group  => 'STANDARD' 

               ,description     => null 

               ,start_date      => sysdate 

               ,end_date        => null); 

     dbms_output.put_line('Responsibility '||get_resp.responsibility_name||' added !!!!!!');   

   end loop; 

end loop;

   commit; 

 exception 

   when others then 

   dbms_output.put_line ('Exception : '||SUBSTR(SQLERRM, 1, 500)); 

   rollback; 

 end;

Assign responsibility to multiple user in oracle apps from backend