EGOIOIMP - User With Item Org Assign Privilege Not Able To Do This Using Import From Excel (INV_IOI_NOT_CATALOG_USER)
(Doc ID 1207273.1)
Last updated on AUGUST 08, 2021
Applies to:Oracle Product Hub - Version 188.8.131.52 and later
Information in this document applies to any platform.
Executable:EGOIOIMP - Item Org Import
Users with "Edit Item Organization Assignments" Privilege cannot use the Import from Excel (or APIs) for organization assignment due to the following error.
Expect that with "Edit Item Organization Assignments" Privilege that the users could assign organizations.
Users do not have full Catalog Category permissions, but instead only have Item Org Assign, or Edit Item, or Edit for specific attribute groups for specific organizations or specific Catalog Categories. Without "Item Catalog Category User" setting at the Catalog Category level in the Setup Workbench, the user appears to be unable to do any org assignment, or specific attribute group updates in the master organization via the "Import from Excel" or API interfaces. But those tasks are successful within the APC items form.
1. Give user Edit Item privilege but NOT Catalog Category permissions.
2. Update an item assignment via the form.
3. Works fine.
4. Import item assignment from Excel
*Importing Item Org Assignments*.
TRANSACTION ID : 28896312
ORGANIZATION ID : 2649
TABLE NAME : MTL_SYTEM_ITEMS_INTERFACE
COLUMN NAME : ITEM_CATALOG_GROUP_ID
MESSAGE NAME : INV_IOI_NOT_CATALOG_USER
ERROR MESSAGE : User cannot use this item catalog category, does not have appropriate role to use it.
TRANSACTION ID : 28896313
ORGANIZATION ID : 2649
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.
*Import Item Org Assignments Completed*
1. Users with full item privileges ("Item Catalog Category User") have no issues.
2. This worked fine on PLM E13 (Before applying PLM E18).
3. Users can update the organization assignments using the PLM forms.
What was already tried?
Tried the <Patch 8654030> from <Note 979768.1> - "Privilege Error INV_IOI_ITEM_ORGASSIGN_PRIV" but the issue remained.
Users unable to do work. Must request a different user with different permissions to do tasks.
Or do Item org assignments manually, one item at a time instead of import from Excel for multiple items. Takes much longer to do this way.
Recently applied PLM (Product Lifecycle Management) Rollup patch E18 (from E13).
Before the patches, users assigned the "Edit Item Organization Assignments" Privilege in Advanced Product Catalog were able to assign items to new organizations in both the APC Item Catalog form as well as via Import from Excel and custom forms that utilize the item Import APIs. Now, after PLM rollup E18 is applied, users can only do organization assignments via the Item Catalog form, and not via Import from Excel.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document