How to Create Manufacturing Items when Uploaded from Excel ? (Engineering Item Flag set to Yes by Default)

(Doc ID 882505.1)

Last updated on OCTOBER 02, 2016

Applies to:

Oracle Advanced Product Catalog - Version: and later   [Release: 11.5 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; 


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