Import Items Allows Incorrect Values To Be Loaded Into MTL_SYSTEM_ITEMS_B 'Web_Status'
Last updated on MAY 09, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Many Inventory Items have the incorrect web_status.
* The incorrect statuses are :
"Published" instead of "PUBLISHED"
"Unpublished" instead of "UNPUBLISHED"
"Disabled" instead of "DISABLED"
Items should have correct web_status after loading 2 item updates in a same batch
The user is able to reproduce the issue (e.g. have incorrect values accepted by "Import Items") in a very specific scenario.
To reproduce the issue the user needs to load 2 item updates in THE same batch:
The 1st one, the item is refused by the interface with two error messages (INV_ORDERABLE_ON_WEB & INV_IOI_WEB_STATUS)
The 2nd one, the item is incorrectly accepted by the interface, and the bad web_status is loaded to the base table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms