My Oracle Support Banner

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 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.

-- 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; 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.