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 FEBRUARY 21, 2019
Applies to:Oracle Product Hub - Version 12.2.6 and later
Information in this document applies to any platform.
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 .
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