PL-SQL code to add responsibility to application user

PL-SQL code to add responsibility to application user
Oracle apps EBS add responsibility to user from backend
Script to add responsibility to user

--
--
BEGIN
   fnd_user_pkg.AddResp ('<User Name>',
                         '<Resp Appl Short Name>',
                         '<Responsibility Key>',
                         '<Security Group>',
                         NULL,
                         NULL,
                         NULL);

   COMMIT;
END;


--Example:

BEGIN
fnd_user_pkg.AddResp ('AMOL',
                      'SYSADMIN',
                      'SYSTEM_ADMINISTRATOR',
                      'STANDARD',
                      NULL,
                      NULL,
                      NULL);

COMMIT;
END;
/

Related posts:

• PTD and YTD balances query in Oracle R12
• Register a test concurrent program from backend in Oracle EBS
• Supervisor Hierarchy and Approval Limits in Oracle EBS R12
• Sales order line status query in Oracle apps
• Query to find all Expense report entry delegations
• Query to find vacation rules in Oracle R12
• Purchase Order Receipt details query in Oracle apps
• Oracle apps query to find approval limits
• View accounting query in oracle apps R12
• Query to get AR invoice SLA and GL details
• Accounting entries not transferred to the General Ledger
• View java class source in oracle database
• Load Java source code in oracle database
• Query to get price list details in Oracle EBS
• Query to find all APIs of Oracle Apps modules
• Oracle R12 shipping status query
• OAF customizations queries
• Oracle apps list of concurrent programs in a Request Set
• R12 AR cash receipt SLA and GL details query
• Oracle apps AR Applications and SLA details
• Oracle EBS query to get AP Invoice SLA Details
• Oracle EBS query to get AR Invoice SLA Details
• Query to get Organization Hierarchy in Oracle apps
• Oracle apps query to find incompatible programs blocking a concurrent request
• Oracle AR Remit to address query
• Oracle Apps iExpense credit card details query
• Form function attached to which responsibility and user
• E-Business suite tax rates and accounts query
• Query to get customer tax registration details in R12
• Query to get Sales order and lines details in Oracle Apps
• Purchase Requisition Vertex debug xml query in Oracle EBS
• Purchase Order Vertex debug xml query in Oracle EBS
• AP Invoice Vertex debug xml query in Oracle EBS
• AR Invoice Vertex debug xml query in Oracle EBS
• Query to find AP invoice workflow item key in oracle apps
• Query to find the responsibility attached to user in oracle apps
• How to enable debug log in Oracle apps EBS
• Query to find and remove Oracle database locks
• PL SQL full form
• Oracle Apps Procure To Pay Cycle (P2P Cycle)
• Oracle Apps Order Management Tables
• How to add AME role and responsibility to user
• Oracle form attached to which responsibility
• Query to get workflow details
• Oracle SQL PLSQL Interview Questions
• Query to find serial number material transactions details
• SQL query to get MIME type for file extension
• Oracle EBS – Order Management Interview Questions
• Oracle Forms and Reports – Practice Questions
• Oracle Forms and Reports – Practice Questions -2
• Oracle Forms and Reports – Practice Test
• Oracle Forms and Reports – Practice Questions
• Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions
• Query to get concurrent program and executable details
• Query to get responsibility level profile option values
• Query to validate migration of XML/BI Publisher Template and Data Definition
• Query to get details of XML/BI Publisher Template and Data Definition
• Query to get Site level and Organization level Profile Option Value
• Query to get attribute values of Inventory Item Template
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
• Query to find Sales Orders that are shipped but not invoiced
• Query to get details of WIP discrete jobs
• Query to get Customer Bank Account Details
• Query to get description of GL Code Combination
• PL-SQL code to add responsibility to application user
• PL-SQL code to reset application user password
• PL-SQL code to write a file
• PL-SQL code to read a file
• Query to find second and third highest value
• PL-SQL Procedure to send email with attachment
• PL-SQL to delete Concurrent Program and Executable
• Query to get the details of the lock in the database
• PL-SQL code to delete XML/BI Publisher template and Data Definition
• Query to find Purchase Order and Invoice Details
• Query to find AP Invoices matched with receipts
• Query to find Table size
• Query to find Form Personalization
• Query to find Supplier Bank Details
• Query to find Credit Memos on an AP invoice
• Query to find the AP invoices that are applied to multiple Purchase Orders
• Query to find profile option values
• Query to get details of concurrent program parameters
• PL-SQL Code to find Menu Hierarchy of a responsibility
• Query to find details of Flex value sets
• Query to find concurrent program Responsibility and Request Group
• Query to find BOM and Routings data
• Concurrent program SQL statement currently running in background
• AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
• Query to find shipset and fulfilment set
• Query to find scheduled concurrent programs
• Query to kill database session for a concurrent request
• Query to get DFF (Descriptive Flex Field) Details

Upload your own post and refer it anywhere anytime: