How to Create Manufacturing Items when Uploaded from Excel ? (Engineering Item Flag set to Yes by Default)
(Doc ID 882505.1)
Last updated on MAY 15, 2019
Applies to:Oracle Product Hub - Version 18.104.22.168 and later
Information in this document applies to any platform.
While creating items by uploading from Excel, see that the engineering item flag is always set to 'Yes' . This is the existing behavior.
MTL_SYSTEM_ITEMS_B.ENG_ITEM_FLAG is set to 'Y' by Default for all items uploaded from Excel.
select mp.organization_code, msi.segment1, msi.eng_item_flag
from mtl_system_items_b msi, mtl_parameters mp
where segment1 = '&item_number'
and mp.organization_code = '&organization_code'
and msi.organization_id = mp.organization_id;
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