This guide details the steps to create an Inventory Management View Only Role using Oracle Security Console. This is a custom role that application administrators can create to provide view only access to users.
The role will provide access to two separate tasks in Inventory
Management.
Manage Item Quantities: The first task is Manage Item Quantities. This page allows users to view available item quantity within an inventory organization.
Review Completed Transactions: The second task is Review Completed Transactions. This task allows users to view completed inventory transactions within an inventory organization. Once the role is successfully created, application administrators can provision the role to users as needed.
Create Inventory View Only Job Role
1. The first step in the process is to create a custom job role for Inventory Inquiry. In order to create a new job role, you must navigate to Oracle Security Console. To access Oracle Security Console, navigate to the main menu navigator and select ‘Security Console’ under ‘Tools.’
2. Click the ‘Create Role’ button to create a new job role.
You need to complete the basic information when defining a new job role. Enter the Role Name, Role Code, Role Category, and Description. The Role Category Name is SCM – Job Roles. In the example, the role name ‘Inventory View Only Job Role’ has been entered as the role name. The role name should be intuitive and reflect the access provided to the user by assigning the job role.
3. The next step is to assign the newly create job role to the appropriate users.
Create Inventory View Only Duty Role
1. Once the job role has been created successfully, the next step in the process is to create a new duty role. The duty role is created in Oracle Security Console. You need to complete the basic information when defining a new duty role. Enter the Role Name, Role Code, Role Category, and Description. The Role Category is SCM – Duty Roles. In the example, the role name ‘Inventory View Only Duty Role’ has been entered as the role name. The role name should be intuitive and reflect the access provided to the user by assigning the job role.
2. In this worked example, three privileges will be assigned to the duty role:
Manage On-Hand Quantity – This privilege will provide access to the Manage Item Quantities page.
Monitor Inventory Work Area – This privilege will provide access to the Inventory Management work area.
Review Completed Inventory Transaction – This privilege will provide access to the Review Completed Transactions page.
3. The next step is to create the data security policy. Fill in the following fields below.
Policy Name: User-defined name.
Database Resource – Inventory Organization
Data Set – Select by key
ORGANIZATION_ID – Enter organization id associated with the inventory organization
Actions – Manage On-Hand Quantity
4. Complete Role Hierarchy by ensuring the duty role is assigned to the job role.
5. Navigate to the last step ‘Summary and Impact Report’ and click the ‘Save and Close’ button.
Validate View Only Access
The last step in the process is to validate the changes in the Inventory work area.
Login to Inventory Management with the user assigned the view only job role.
Navigate to the Inventory work area
The Manage Item Quantities page is the default page for the Inventory work area
Open the task drawer and you will see two tasks Review Completed Transactions and Review Consumption Advice Exceptions
The Review Consumption Advice Exceptions page shares the same entitlement as the Review Completed Transactions page.
At Inlab Ltd, we provide comprehensive Oracle Fusion Cloud implementation services across all modules, including: