Import Items Allows Incorrect Values To Be Loaded Into MTL_SYSTEM_ITEMS_B 'Web_Status' (Doc ID 2101585.1)

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.

Symptoms

ACTUAL BEHAVIOR

 Many Inventory Items have the incorrect web_status.

* The incorrect statuses are :
"Published" instead of "PUBLISHED"
"Unpublished" instead of "UNPUBLISHED"
"Disabled" instead of "DISABLED"

EXPECTED BEHAVIOR
 
Items should have correct web_status after loading 2 item updates in a same batch

STEPS

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.

Note: The issue is not reproducible in case when using separate batches - the system is working as expected.

Changes

 

Cause

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