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 11.5.10.2 and later
Information in this document applies to any platform.

Goal

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; 

Solution

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
Goal
Solution

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