WebADI Structure Upload Template Does Not Show List Of Values for Item Type, Unit Of Measure, Item Status fields ?
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.
On : 12.2.6 version, Catalog items
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.
Item Type, Transaction Type, Assembly Type -- Other fields should have built-in LOV validations like the item template.
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 .
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