How to Create Manufacturing Items when Uploaded from Excel ? (Engineering Item Flag set to Yes by Default)
Last updated on OCTOBER 02, 2016
Applies to:Oracle Advanced Product Catalog - Version: 220.127.116.11
Information in this document applies to any platform.
MTL_SYSTEM_ITEMS_B.ENG_ITEM_FLAG is set to 'Y' by Default for all items uploaded from Excel.
-- Use the below code to confirm if the items are engineering items, eng_item_flag would be 'Y'
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;
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