@add_resp

Quickly add new responsibilities. This script will present a list of all responsibilities in use by anybody but you. You need to execute the add_resp.sql and copy/paste executions for those responisibilities you want. This script is using the FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT package to add responsibility. Also check the “User & Responsibilties” template here. SQL> @add_resp xxtlq XX   XX HR MANAGER                     -- @add_resp2 999 21624 800 41 XX00 Desktop Integration          -- @add_resp2 999 53061 231 0 XX01 AP Super User                -- @add_resp2 999 52964 200 0 XX01 CRM Administrator            -- @add_resp2 999 53041 690 0 XX01 Discrete Inventory           -- @add_resp2 999 52961 401 0 XX01 Global Pricing Manager       -- @add_resp2 999 53001 661 0 XX01 HR Manager                   -- @add_resp2 999 52966 800 41 SQL>   Syntax:  @add_resp <username> <partial respname>   @add_resp (0 downloads)   

Leave a Reply