Not All Instances Are Shown After Applying OU Access Restrictions
Last updated on OCTOBER 25, 2016
Applies to:Oracle Installed Base - Version 11.5.10 and later
Information in this document applies to any platform.
After Install Base access restrictions are applied based on Operating Unit to responsibilities linked to the CSI_NORMAL_USER role, some item instances that are expected to be shown are no longer showing up in query results done in Install Base.
The instances that are no longer shown do not have a record in CSI_I_ORG_ASSIGNMENTS table and therefore are not shown. The instances that do not show are instances that are 'loaners' so are internally owned.
Expect to be able to query up Install Base instances for 'loaners' when user access is restricted based on Operating Unit.
Steps To Reproduce:
1. SYSADMIN > CRM HTML Administration > Setup : Settings : Security : Access Controls : Roles
Apply following setup:
a) Add CSI_OP_UNIT_RESTRICTION to CSI_NORMAL_USER
b) Remove CSI_OP_UNIT_ALL from CSI_NORMAL_USER.
c) Ensure CSI_NORMAL_USER has the following privileges:
d) Ensure CSI_NORMAL_USER has the following restrictions:
2. In Inventory create a Miscellaneous Transaction to create the item instance in Install Base.
a) Inventory > Transactions > Miscellaneous Transactions
b) Enter Miscellaneous Transaction:
Type: Account alias receipt
Source: MISC RECEIPT
c) Click on 'Transaction Lines'
d) Enter the Miscellaneous Transaction Lines:
Sub-inventory / Locator: 'LOANERS / LOANERS' (internally owned instances)
UOM: EA (Each)
e) Enter the Lot / Serial information: Example
Serial Number From: TEST_01
Serial Number To: TEST_10
f) Click on 'Done'
g) Save Changes from screen.
After the changes, the Available and On Hand quantities are updated to 20.
3. Installed Base User responsibility
Check instances created in Install Base. These instances created cannot be viewed.
When restriction is removed they show.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms