Assign Role (Permission) on Oracle EBS R12

By -

 In Oracle E-Business Suite (EBS) R12.3, you can create roles using the "Role Maintenance" form. Roles are used to define responsibilities and access privileges for users in the system. Here's a step-by-step guide to creating roles in Oracle EBS R12.3:


Step 1: Navigate to the Role Maintenance Form


Log in to Oracle EBS R12.3 with appropriate user credentials.

Navigate to the System Administrator responsibility (typically named "System Administrator").

Under the "Security" tab, select "Responsibility" and then click on "Define."


Step 2: Create a New Role


In the "Roles" form, click on the "Create" button (or use the menu path File > New) to create a new role.


Step 3: Enter Role Information


In the "Role" field, enter a unique name for the role you want to create.

In the "Description" field, provide a meaningful description of the role.


Step 4: Assign Responsibilities to the Role


Go to the "Responsibility" tab to assign relevant Oracle responsibilities to the role. You can search for responsibilities based on their names or descriptions and add them to the role.

Use the "Add" button to search for responsibilities and then click "Select" to add them to the role.


Step 5: Define Data Access (Optional)


If required, go to the "Data Access" tab to set up data access privileges for the role. This step is applicable if you want to restrict the data visible to users assigned to the role.

Define the data access rules based on criteria such as organizations, operating units, or other attributes.


Step 6: Review and Save the Role


Review all the information entered for the role to ensure it is accurate and complete.

Click on the "Save" button to save the role.


Step 7: Assign Users to the Role (Optional)


Once the role is created successfully, you can assign users to the role. This step is essential for users to access the responsibilities and data allowed by the role.

In the "Roles" form, go to the "Users" tab and add the relevant users by entering their usernames.


Step 8: Test the Role


After creating the role and assigning users (if applicable), test the role by logging in as a user assigned to the role and verifying that the responsibilities and data access are working as intended.


Comments

Post a Comment

Popular posts from this blog

Oracle DBA Queries

By -
 Useful Queries for Checking Concurrent Requests and Programs  Hi DBAs, As an Apps DBA we have to monitor the Concurrent jobs status and details frequently,This can be done with the help of the below queries. -- Concurrent Program Queries for Apps DBA: -- Query 1:For checking the locks in concurrent jobs  SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,inst_id,id1, id2, lmode, request, type FROM gV$LOCK  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request>0) ORDER BY id1,request; -- Query 2:For checking the concurrent programs running currently with Details of Processed time-- and Start Date  SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,  a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,  (a.actual_start_date-a.request_date)*24*60*60 AS lag...
Read more

Setup of BOM (Bill of Material) on Oracle EBS R12

By -
Setting up Bill of Material (BOM) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up BOM in Oracle EBS R12.3: Step 1: Define BOM Parameters Navigation: Bills of Material > Setup > Parameters Define BOM parameters, such as the default BOM type, effective date, and organization. Step 2: Define BOM Item Attributes Navigation: Bills of Material > Setup > Attributes Define BOM item attributes, such as item categories and planning attributes. Step 3: Define BOM Structures Navigation: Bills of Material > Setup > BOM Structures Define BOM structures to represent different types of BOMs (e.g., Engineering, Production). Step 4: Create Bill of Material (BOM) Navigation: Bills of Material > Engineer > Bills > Bills Create the BOM by entering the header data (e.g., assembly item, BOM type) and adding the components along with their quantities and item attributes. Step 5: Define Compo...
Read more

Interview Questions and Answers on O2C (Order to cash) in Oracle EBS R12

By -
  Order-to-Cash (O2C) Basics: What is the Order-to-Cash (O2C) cycle, and what is its significance in Oracle EBS? Answer: The O2C cycle represents the end-to-end process of receiving customer orders, processing them, delivering goods or services, and receiving payments. It is a critical business process in Oracle EBS for revenue generation. What are the key components of the O2C cycle in Oracle EBS? Answer: The key components include Order Management, Pricing, Shipping, Invoicing, Receivables, and Cash Management. Order Management: Explain the role of Order Management in the O2C cycle, and how does it handle order creation, modification, and processing? Answer: Order Management is responsible for creating, modifying, and processing customer orders. It ensures that orders are accurate, fulfillable, and meet customer requirements. What are the various order types in Oracle Order Management, and how are they used within the O2C cycle? Answer: Order types include standard orders, sa...
Read more