WebADI Structure Upload Template Does Not Show List Of Values for Item Type, Unit Of Measure, Item Status fields ?

(Doc ID 2399584.1)

Last updated on MAY 21, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Catalog items

ACTUAL BEHAVIOR
---------------
LOV Validations Missing in WebADI for Structure upload template

In EGO BulkLoad Integrator, Users are entering wrong information for fields like item_type because there is no LOV for this field. Records get uploaded fine in excel , but later get stuck in mtl_system_items_interface table. This causes a lot of rework for the users as they need to fix the errors and run the import again. It would be beneficial to have these as LOVs so that users do not make typos entering values.

EXPECTED BEHAVIOR
-----------------------
Item Type, Transaction Type, Assembly Type -- Other fields should have built-in LOV validations like the item template.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create item with incorrect transaction type, item type.
2. No errors are shown by WebADI during upload .
3. Organization Code seems to be an LOV .

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