My Oracle Support Banner

INV_ITEM_NUMBER_NO_UDPATE Error Thrown Updating Items Through WebADI (any Attribute) For Items Starting With A '\' (Escape Character) (Doc ID 2688275.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, MICC Transfer to TSC
 
When we try to update specific items starting with "\" through WebADI see error.

What has been tried
-------------------------------
Tried by Disabling PIM Rules
Tried different Display formats
Tried with an extra backslash - Item number loaded was strange - Process tries to create item \\\\AB1001

ERROR
-----------------------
TRANSACTION ID : 8450994
ORGANIZATION ID : -1
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : ITEM NUMBER
MESSAGE NAME : INV_ITEM_NUMBER_NO_UDPATE
ERROR MESSAGE : Item number update is disallowed as set in the profile (INV: Updateable item name).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Truncate interface tables

TRUNCATE TABLE INV.MTL_SYSTEM_ITEMS_INTERFACE;
TRUNCATE TABLE INV.MTL_INTERFACE_ERRORS;
TRUNCATE TABLE INV.MTL_ITEM_REVISIONS_INTERFACE;
TRUNCATE TABLE INV.MTL_ITEM_CATEGORIES_INTERFACE;
TRUNCATE TABLE EGO.EGO_ITM_USR_ATTR_INTRFC;

2. Advanced search > Download item starting with \ to excel
3. Update any attribute
 
Workaround
----------------
Updating them manually via the front end

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.