Troubleshooting Details
BACKGROUND:
When rows fail the Import Items process due to an INV_IOI_MASTER_CHILD_1n error, it means that one or more master controlled attributes do not have the same value in the master organization item as in the child organization item. Since the Import Items process re-edits every attribute upon an update to one attribute, the mismatch of attribute values may be within the Item Master (MTL_SYSTEM_ITEMS_B). Otherwise, the mismatch can be introduced with the update being made via the MTL_SYSTEM_ITEMS_INTERRFACE table.
Currently, the INV_IOI_MASTER_CHILD errors range from INV_IOI_MASTER_CHILD_1A to INV_IOI_MASTER_CHILD_1K. Each individual error message denotes a specific set of attributes.
If you have error_messages that are not documented below, dump the contents of INVPVM1B.pls to see all error_messages and associated attributes. This .pls file can be found in directory $INV_TOP/patch/115/sql.
SOLUTION:
Resolving INV_IOI_MASTER_CHILD errors involves three(3) general steps:
1) For the encountered error, first determine which of the effected attributes are controlled at the master level for your company.
2) Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
3) Options for Correcting INV_IOI_MASTER_CHILD
a) If the master item attribute value is correct, reload the child item (with corrected values) into MTL_SYSTEM_ITEMS_INTERRFACE and rerun Item Import.
b) If the child item attribute value is correct, update the master item online (Navigation: Inventory / Items / Master Items) and all values will be changed for all organizations. You may also load corrections to the master item into MTL_SYSTEM_ITEMS_INTERRFACE and run the Item Import process in UPDATE mode.
STEP 1 and STEP 2
---------------------
Following are the SQL Scripts, by specific error message, needed to complete steps 1 and 2 above. Step 3, correcting the master organization item, will be presented at the end of the document.
NOTE: When performing step 2, you may comment out any attributes that are not master controlled by placing two dashes (--) in front of the line. Make sure that the last attribute selected does not end with a comma after the description.
example:
--m.EAM_ITEM_TYPE mst_EAM_ITEM_TYPE,
--c.EAM_ITEM_TYPE ch_EAM_ITEM_TYPE,
m.SUBSCRIPTION_DEPEND_FLAG mst_SUBSCRIPTION_DEPEND_FLAG,
c.SUBSCRIPTION_DEPEND_FLAG ch_SUBSCRIPTION_DEPEND_FLAG
A) For error: INV_IOI_MASTER_CHILD_1A
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ( 'BUYER_ID',
'ACCOUNTING_RULE_ID',
'INVOICING_RULE_ID',
'PURCHASING_ITEM_FLAG',
'SHIPPABLE_ITEM_FLAG',
'CUSTOMER_ORDER_FLAG',
'INTERNAL_ORDER_FLAG',
'INVENTORY_ITEM_FLAG');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.BUYER_ID mst_BUYER_ID,
c.BUYER_ID ch_BUYER_ID,
m.ACCOUNTING_RULE_ID mst_ACCOUNTING_RULE_ID ,
c.ACCOUNTING_RULE_ID ch_ACCOUNTING_RULE_ID ,
m.INVOICING_RULE_ID mst_INVOICING_RULE_ID,
c.INVOICING_RULE_ID ch_INVOICING_RULE_ID,
m.PURCHASING_ITEM_FLAG mst_PURCHASING_ITEM_FLAG,
c.PURCHASING_ITEM_FLAG ch_PURCHASING_ITEM_FLAG,
m.SHIPPABLE_ITEM_FLAG mst_SHIPPABLE_ITEM_FLAG,
c.SHIPPABLE_ITEM_FLAG ch_SHIPPABLE_ITEM_FLAG,
m.CUSTOMER_ORDER_FLAG mst_CUSTOMER_ORDER_FLAG,
c.CUSTOMER_ORDER_FLAG ch_CUSTOMER_ORDER_FLAG,
m.INTERNAL_ORDER_FLAG mst_INTERNAL_ORDER_FLAG,
c.INTERNAL_ORDER_FLAG ch_INTERNAL_ORDER_FLAG,
m.INVENTORY_ITEM_FLAG mst_INVENTORY_ITEM_FLAG,
c.INVENTORY_ITEM_FLAG ch_INVENTORY_ITEM_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1A')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
B) For error: INV_IOI_MASTER_CHILD_1B
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('STOCK_ENABLED_FLAG',
'BOM_ENABLED_FLAG',
'BUILD_IN_WIP_FLAG',
'REVISION_QTY_CONTROL_CODE',
'ITEM_CATALOG_GROUP_ID',
'CHECK_SHORTAGES_FLAG',
'WEB_STATUS',
'INDIVISIBLE_FLAG');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.STOCK_ENABLED_FLAG mst_STOCK_ENABLED_FLAG,
c.STOCK_ENABLED_FLAG ch_STOCK_ENABLED_FLAG,
m.BOM_ENABLED_FLAG mst_BOM_ENABLED_FLAG ,
c.BOM_ENABLED_FLAG ch_BOM_ENABLED_FLAG ,
m.BUILD_IN_WIP_FLAG mst_BUILD_IN_WIP_FLAG,
c.BUILD_IN_WIP_FLAG ch_BUILD_IN_WIP_FLAG,
m.REVISION_QTY_CONTROL_CODE mst_REV_QTY_CONTROL_CODE,
c.REVISION_QTY_CONTROL_CODE ch_REV_QTY_CONTROL_CODE,
m.ITEM_CATALOG_GROUP_ID mst_ITEM_CATALOG_GROUP_ID,
c.ITEM_CATALOG_GROUP_ID ch_ITEM_CATALOG_GROUP_ID,
m.CHECK_SHORTAGES_FLAG mst_CHECK_SHORTAGES_FLAG,
c.CHECK_SHORTAGES_FLAG ch_CHECK_SHORTAGES_FLAG,
m.WEB_STATUS mst_WEB_STATUS,
c.WEB_STATUS ch_WEB_STATUS,
m.INDIVISIBLE_FLAG mst_INDIVISIBLE_FLAG,
c.INDIVISIBLE_FLAG ch_INDIVISIBLE_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1B')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
C) For error: INV_IOI_MASTER_CHILD_1C
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('PURCHASING_ENABLED_FLAG',
'CUSTOMER_ORDER_ENABLED_FLAG',
'INTERNAL_ORDER_ENABLED_FLAG',
'SO_TRANSACTIONS_FLAG',
'MTL_TRANSACTIONS_ENABLED_FLAG');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.PURCHASING_ENABLED_FLAG mst_PURCHASING_ENABLED_FLAG,
c.PURCHASING_ENABLED_FLAG ch_PURCHASING_ENABLED_FLAG,
m.CUSTOMER_ORDER_ENABLED_FLAG mst_CUST_ORDER_ENABLED_FLAG ,
c.CUSTOMER_ORDER_ENABLED_FLAG ch_CUST_ORDER_ENABLED_FLAG ,
m.INTERNAL_ORDER_ENABLED_FLAG mst_INT_ORDER_ENABLED_FLAG,
c.INTERNAL_ORDER_ENABLED_FLAG ch_INT_ORDER_ENABLED_FLAG,
m.SO_TRANSACTIONS_FLAG mst_SO_TRANSACTIONS_FLAG,
c.SO_TRANSACTIONS_FLAG ch_SO_TRANSACTIONS_FLAG,
m.MTL_TRANSACTIONS_ENABLED_FLAG mst_MTL_TRANS_ENABLED_FLAG,
c.MTL_TRANSACTIONS_ENABLED_FLAG ch_MTL_TRANS_ENABLED_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1C')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
D) For error: INV_IOI_MASTER_CHILD_1D
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ( 'CATALOG_STATUS_FLAG' ,
'RETURNABLE_FLAG' ,
'DEFAULT_SHIPPING_ORG' ,
'COLLATERAL_FLAG' ,
'TAXABLE_FLAG' ,
'PURCHASING_TAX_CODE' ,
'QTY_RCV_EXCEPTION_CODE' ,
'ALLOW_ITEM_DESC_UPDATE_FLAG' ,
'INSPECTION_REQUIRED_FLAG' ,
'RECEIPT_REQUIRED_FLAG' ,
'MARKET_PRICE');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.CATALOG_STATUS_FLAG mst_CATALOG_STATUS_FLAG,
c.CATALOG_STATUS_FLAG ch_CATALOG_STATUS_FLAG,
m.RETURNABLE_FLAG mst_RETURNABLE_FLAG ,
c.RETURNABLE_FLAG ch_RETURNABLE_FLAG ,
m.DEFAULT_SHIPPING_ORG mst_DEFAULT_SHIPPING_ORG,
c.DEFAULT_SHIPPING_ORG ch_DEFAULT_SHIPPING_ORG,
m.COLLATERAL_FLAG mst_COLLATERAL_FLAG,
c.COLLATERAL_FLAG ch_COLLATERAL_FLAG,
m.PURCHASING_TAX_CODE mst_PURCHASING_TAX_CODE,
c.PURCHASING_TAX_CODE ch_PURCHASING_TAX_CODE,
m.QTY_RCV_EXCEPTION_CODE mst_QTY_RCV_EXCEPTION_CODE,
c.QTY_RCV_EXCEPTION_CODE ch_QTY_RCV_EXCEPTION_CODE,
m.ALLOW_ITEM_DESC_UPDATE_FLAG mst_ALLOW_ITEM_DESC_UPD_FLAG ,
c.ALLOW_ITEM_DESC_UPDATE_FLAG ch_ALLOW_ITEM_DESC_UPD_FLAG ,
m.INSPECTION_REQUIRED_FLAG mst_INSPECTION_REQUIRED_FLAG,
c.INSPECTION_REQUIRED_FLAG ch_INSPECTION_REQUIRED_FLAG,
m.RECEIPT_REQUIRED_FLAG mst_RECEIPT_REQUIRED_FLAG,
c.RECEIPT_REQUIRED_FLAG ch_RECEIPT_REQUIRED_FLAG,
m.MARKET_PRICE mst_MARKET_PRICE,
c.MARKET_PRICE ch_MARKET_PRICE
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1D')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
E) For error: INV_IOI_MASTER_CHILD_1E
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('HAZARD_CLASS_ID',
'RFQ_REQUIRED_FLAG',
'QTY_RCV_TOLERANCE',
'LIST_PRICE_PER_UNIT',
'UN_NUMBER_ID',
'PRICE_TOLERANCE_PERCENT',
'ASSET_CATEGORY_ID',
'ROUNDING_FACTOR',
'UNIT_OF_ISSUE',
'ENFORCE_SHIP_TO_LOCATION_CODE');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.HAZARD_CLASS_ID mst_HAZARD_CLASS_ID,
c.HAZARD_CLASS_ID ch_HAZARD_CLASS_ID,
m.RFQ_REQUIRED_FLAG mst_RFQ_REQUIRED_FLAG,
c.RFQ_REQUIRED_FLAG ch_RFQ_REQUIRED_FLAG,
m.QTY_RCV_TOLERANCE mst_QTY_RCV_TOLERANCE,
c.QTY_RCV_TOLERANCE ch_QTY_RCV_TOLERANCE,
m.LIST_PRICE_PER_UNIT mst_LIST_PRICE_PER_UNIT,
c.LIST_PRICE_PER_UNIT ch_LIST_PRICE_PER_UNIT,
m.UN_NUMBER_ID mst_UN_NUMBER_ID,
c.UN_NUMBER_ID ch_UN_NUMBER_ID,
m.PRICE_TOLERANCE_PERCENT mst_PRICE_TOLERANCE_PERCENT,
c.PRICE_TOLERANCE_PERCENT ch_PRICE_TOLERANCE_PERCENT,
m.ASSET_CATEGORY_ID mst_ASSET_CATEGORY_ID,
c.ASSET_CATEGORY_ID ch_ASSET_CATEGORY_ID,
m.ROUNDING_FACTOR mst_ROUNDING_FACTOR ,
c.ROUNDING_FACTOR ch_ROUNDING_FACTOR ,
m.UNIT_OF_ISSUE mst_UNIT_OF_ISSUE,
c.UNIT_OF_ISSUE ch_UNIT_OF_ISSUE,
m.ENFORCE_SHIP_TO_LOCATION_CODE mst_ENFORCE_SHIP_TO_LOC_CD,
c.ENFORCE_SHIP_TO_LOCATION_CODE ch_ENFORCE_SHIP_TO_LOC_CD
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1E')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
F) For error: INV_IOI_MASTER_CHILD_1F
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
'ALLOW_UNORDERED_RECEIPTS_FLAG',
'ALLOW_EXPRESS_DELIVERY_FLAG',
'DAYS_EARLY_RECEIPT_ALLOWED',
'DAYS_LATE_RECEIPT_ALLOWED');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.ALLOW_SUBSTITUTE_RECEIPTS_FLAG mst_ALLW_SUBSTITUTE_RCPTS_FLAG,
c.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ch_ALLW_SUBSTITUTE_RCPTS_FLAG,
m.ALLOW_UNORDERED_RECEIPTS_FLAG mst_ALLW_UNORDERED_RCPTS_FLAG,
c.ALLOW_UNORDERED_RECEIPTS_FLAG ch_ALLW_UNORDERED_RCPTS_FLAG,
m.DAYS_EARLY_RECEIPT_ALLOWED mst_DAYS_EARLY_RCPT_ALLOWED,
c.DAYS_EARLY_RECEIPT_ALLOWED ch_DAYS_EARLY_RCPT_ALLOWED,
m.DAYS_LATE_RECEIPT_ALLOWED mst_DAYS_LATE_RCPT_ALLOWED,
c.DAYS_LATE_RECEIPT_ALLOWED ch_DAYS_LATE_RCPT_ALLOWED
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1F')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
G) For error: INV_IOI_MASTER_CHILD_1G and INV_IOI_MASTER_CHILD_4G
INV_IOI_MASTER_CHILD_nG, has two known values at the time this note was created:
INV_IOI_MASTER_CHILD_1G
RECEIPT_DAYS_EXCEPTION_CODE,
RECEIVING_ROUTING_ID,
INVOICE_CLOSE_TOLERANCE,
RECEIVE_CLOSE_TOLERANCE,
AUTO_LOT_ALPHA_PREFIX,
DESCRIPTION
INV_IOI_MASTER_CHILD_4G
WIP_SUPPLY_TYPE,
WIP_SUPPLY_SUBINVENTORY,
PRIMARY_UOM_CODE,
ALLOWED_UNITS_LOOKUP_CODE,
COST_OF_SALES_ACCOUNT,
SALES_ACCOUNT
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('RECEIPT_DAYS_EXCEPTION_CODE',
'RECEIVING_ROUTING_ID',
'INVOICE_CLOSE_TOLERANCE',
'RECEIVE_CLOSE_TOLERANCE',
'AUTO_LOT_ALPHA_PREFIX',
'DESCRIPTION');
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('WIP_SUPPLY_TYPE',
'WIP_SUPPLY_SUBINVENTORY',
'PRIMARY_UOM_CODE',
'ALLOWED_UNITS_LOOKUP_CODE',
'COST_OF_SALES_ACCOUNT',
'SALES_ACCOUNT');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.RECEIPT_DAYS_EXCEPTION_CODE mst_RECEIPT_DAYS_EXCEPT_CODE,
c.RECEIPT_DAYS_EXCEPTION_CODE ch_RECEIPT_DAYS_EXCEPT_CODE,
m.RECEIVING_ROUTING_ID mst_RECEIVING_ROUTING_ID,
c.RECEIVING_ROUTING_ID ch_RECEIVING_ROUTING_ID,
m.INVOICE_CLOSE_TOLERANCE mst_INVOICE_CLOSE_TOLERANCE,
c.INVOICE_CLOSE_TOLERANCE ch_INVOICE_CLOSE_TOLERANCE,
m.RECEIVE_CLOSE_TOLERANCE mst_RECEIVE_CLOSE_TOLERANCE,
c.RECEIVE_CLOSE_TOLERANCE ch_RECEIVE_CLOSE_TOLERANCE,
m.AUTO_LOT_ALPHA_PREFIX mst_AUTO_LOT_ALPHA_PREFIX,
c.AUTO_LOT_ALPHA_PREFIX ch_AUTO_LOT_ALPHA_PREFIX,
m.DESCRIPTION mst_DESCRIPTION,
c.DESCRIPTION ch_DESCRIPTION
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1G')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
********
NOTE: If your message is INV_IOI_MASTER_CHILD_1G and this script. provides no direction, it is possible that the DESCRIPTION field has trailing spaces in the master organization item.
Run the following scripts to detect the trailing space problem:
select count(*) from mtl_system_items_b
where description != ltrim(rtrim(description));
select count(*) from mtl_system_items_tl
where description != ltrim(rtrim(description));
If either of these scripts return a count > 0, use Note:156716.1 to remove the trailing spaces.
BE SURE TO PERFORM. the datafix in a TEST instance first and to take a BACKUP before running the cleanup scripts.
If you have any questions/concerns log a new Service Request with Oracle Support / Items
********
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.WIP_SUPPLY_TYPE mst_WIP_SUPPLY_TYPE,
c.WIP_SUPPLY_TYPE ch_WIP_SUPPLY_TYPE,
m.WIP_SUPPLY_SUBINVENTORY mst_WIP_SUPPLY_SUBINVENTORY,
c.WIP_SUPPLY_SUBINVENTORY ch_WIP_SUPPLY_SUBINVENTORY,
m.PRIMARY_UOM_CODE mst_PRIMARY_UOM_CODE,
c.PRIMARY_UOM_CODE ch_PRIMARY_UOM_CODE,
m.ALLOWED_UNITS_LOOKUP_CODE mst_ALLOWED_UNITS_LOOKUP_CODE,
c.ALLOWED_UNITS_LOOKUP_CODE ch_ALLOWED_UNITS_LOOKUP_CODE,
m.COST_OF_SALES_ACCOUNT mst_COST_OF_SALES_ACCOUNT,
c.COST_OF_SALES_ACCOUNT ch_COST_OF_SALES_ACCOUNT,
m.SALES_ACCOUNT mst_SALES_ACCOUNT,
c.SALES_ACCOUNT ch_SALES_ACCOUNT
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_4G')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
H) For error: INV_IOI_MASTER_CHILD_1H
Sometimes this error is broken up into multiple errors. We will reasearch them as one.
INV_IOI_MASTER_CHILD_1HA
OVERCOMPLETION_TOLERANCE_TYPE,
OVERCOMPLETION_TOLERANCE_VALUE,
OVER_SHIPMENT_TOLERANCE,
UNDER_SHIPMENT_TOLERANCE,
OVER_RETURN_TOLERANCE
INV_IOI_MASTER_CHILD_1HB
UNDER_RETURN_TOLERANCE,
EQUIPMENT_TYPE,
RECOVERED_PART_DISP_CODE,
DEFECT_TRACKING_ON_FLAG,
USAGE_ITEM_FLAG
INV_IOI_MASTER_CHILD_1HC
EVENT_FLAG, ELECTRONIC_FLAG,
DOWNLOADABLE_FLAG,
VOL_DISCOUNT_EXEMPT_FLAG,
COUPON_EXEMPT_FLAG
INV_IOI_MASTER_CHILD_1HD
COMMS_NL_TRACKABLE_FLAG,
ASSET_CREATION_CODE,
COMMS_ACTIVATION_REQD_FLAG,
ORDERABLE_ON_WEB_FLAG,
BACK_ORDERABLE_FLAG
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('OVERCOMPLETION_TOLERANCE_TYPE',
'OVERCOMPLETION_TOLERANCE_VALUE',
'OVER_SHIPMENT_TOLERANCE',
'UNDER_SHIPMENT_TOLERANCE',
'OVER_RETURN_TOLERANCE',
'UNDER_RETURN_TOLERANCE',
'EQUIPMENT_TYPE',
'RECOVERED_PART_DISP_CODE',
'DEFECT_TRACKING_ON_FLAG',
'USAGE_ITEM_FLAG',
'EVENT_FLAG',
'ELECTRONIC_FLAG',
'DOWNLOADABLE_FLAG',
'VOL_DISCOUNT_EXEMPT_FLAG',
'COUPON_EXEMPT_FLAG',
'COMMS_NL_TRACKABLE_FLAG',
'ASSET_CREATION_CODE',
'COMMS_ACTIVATION_REQD_FLAG',
'ORDERABLE_ON_WEB_FLAG',
'BACK_ORDERABLE_FLAG');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.OVERCOMPLETION_TOLERANCE_TYPE mst_OVERCOMP_TOLERANCE_TYPE,
c.OVERCOMPLETION_TOLERANCE_TYPE ch_OVERCOMP_TOLERANCE_TYPE,
m.OVERCOMPLETION_TOLERANCE_VALUE mst_OVERCOMP_TOLERANCE_VALUE,
c.OVERCOMPLETION_TOLERANCE_VALUE ch_OVERCOMP_TOLERANCE_VALUE,
m.OVER_SHIPMENT_TOLERANCE mst_OVER_SHIPMENT_TOLERANCE,
c.OVER_SHIPMENT_TOLERANCE ch_OVER_SHIPMENT_TOLERANCE,
m.UNDER_SHIPMENT_TOLERANCE mst_UNDER_SHIPMENT_TOLERANCE,
c.UNDER_SHIPMENT_TOLERANCE ch_UNDER_SHIPMENT_TOLERANCE,
m.OVER_RETURN_TOLERANCE mst_OVER_RETURN_TOLERANCE,
c.OVER_RETURN_TOLERANCE ch_OVER_RETURN_TOLERANCE,
m.UNDER_RETURN_TOLERANCE mst_UNDER_RETURN_TOLERANCE,
c.UNDER_RETURN_TOLERANCE ch_UNDER_RETURN_TOLERANCE,
m.EQUIPMENT_TYPE mst_EQUIPMENT_TYPE,
c.EQUIPMENT_TYPE ch_EQUIPMENT_TYPE,
m.RECOVERED_PART_DISP_CODE mst_RECOVD_PART_DISP_CODE,
c.RECOVERED_PART_DISP_CODE ch_RECOVD_PART_DISP_CODE,
m.DEFECT_TRACKING_ON_FLAG mst_DEFECT_TRACKING_ON_FLAG,
c.DEFECT_TRACKING_ON_FLAG ch_DEFECT_TRACKING_ON_FLAG,
m.USAGE_ITEM_FLAG mst_USAGE_ITEM_FLAG,
c.USAGE_ITEM_FLAG ch_USAGE_ITEM_FLAG,
m.EVENT_FLAG mst_EVENT_FLAG,
c.EVENT_FLAG ch_EVENT_FLAG,
m.ELECTRONIC_FLAG mst_ELECTRONIC_FLAG,
c.ELECTRONIC_FLAG ch_ELECTRONIC_FLAG,
m.DOWNLOADABLE_FLAG mst_DOWNLOADABLE_FLAG,
c.DOWNLOADABLE_FLAG ch_DOWNLOADABLE_FLAG,
m.VOL_DISCOUNT_EXEMPT_FLAG mst_VOL_DISCNT_EXMPT_FLAG,
c.VOL_DISCOUNT_EXEMPT_FLAG ch_VOL_DISCNT_EXMPT_FLAG,
m.COUPON_EXEMPT_FLAG mst_COUPON_EXEMPT_FLAG,
c.COUPON_EXEMPT_FLAG ch_COUPON_EXEMPT_FLAG,
m.COMMS_NL_TRACKABLE_FLAG mst_COMMS_NL_TRACK_FLAG,
c.COMMS_NL_TRACKABLE_FLAG ch_COMMS_NL_TRACK_FLAG,
m.ASSET_CREATION_CODE mst_ASSET_CREATION_CODE,
c.ASSET_CREATION_CODE ch_ASSET_CREATION_CODE,
m.COMMS_ACTIVATION_REQD_FLAG mst_COMMS_ACT_REQD_FLAG,
c.COMMS_ACTIVATION_REQD_FLAG ch_COMMS_ACT_REQD_FLAG,
m.ORDERABLE_ON_WEB_FLAG mst_ORDERABLE_ON_WEB_FLAG,
c.ORDERABLE_ON_WEB_FLAG ch_ORDERABLE_ON_WEB_FLAG,
m.BACK_ORDERABLE_FLAG mst_BACK_ORDERABLE_FLAG,
c.BACK_ORDERABLE_FLAG ch_BACK_ORDERABLE_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name LIKE 'INV_IOI_MASTER_CHILD_1H%')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
I) For error: INV_IOI_MASTER_CHILD_1I
Sometimes this error is broken up into multiple errors. We will reasearch them as one
INV_IOI_MASTER_CHILD_1IA
DIMENSION_UOM_CODE,
UNIT_LENGTH,
UNIT_WIDTH,
UNIT_HEIGHT,
BULK_PICKED_FLAG,
LOT_STATUS_ENABLED,
DEFAULT_LOT_STATUS_ID
INV_IOI_MASTER_CHILD_1IB
SERIAL_STATUS_ENABLED,
DEFAULT_SERIAL_STATUS_ID,
LOT_SPLIT_ENABLED,
LOT_MERGE_ENABLED
INV_IOI_MASTER_CHILD_1IC
INVENTORY_CARRY_PENALTY,
OPERATION_SLACK_PENALTY,
FINANCING_ALLOWED_FLAG
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('DIMENSION_UOM_CODE',
'UNIT_LENGTH',
'UNIT_WIDTH',
'UNIT_HEIGHT',
'BULK_PICKED_FLAG',
'LOT_STATUS_ENABLED',
'DEFAULT_LOT_STATUS_ID',
'SERIAL_STATUS_ENABLED',
'DEFAULT_SERIAL_STATUS_ID',
'LOT_SPLIT_ENABLED',
'LOT_MERGE_ENABLED',
'INVENTORY_CARRY_PENALTY' ,
'OPERATION_SLACK_PENALTY',
'FINANCING_ALLOWED_FLAG');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.DIMENSION_UOM_CODE mst_DIMENSION_UOM_CODE,
c.DIMENSION_UOM_CODE ch_DIMENSION_UOM_CODE,
m.UNIT_LENGTH mst_UNIT_LENGTH,
c.UNIT_LENGTH ch_UNIT_LENGTH,
m.UNIT_WIDTH mst_UNIT_WIDTH,
c.UNIT_WIDTH ch_UNIT_WIDTH,
m.UNIT_HEIGHT mst_UNIT_HEIGHT,
c.UNIT_HEIGHT ch_UNIT_HEIGHT,
m.BULK_PICKED_FLAG mst_BULK_PICKED_FLAG,
c.BULK_PICKED_FLAG ch_BULK_PICKED_FLAG,
m.LOT_STATUS_ENABLED mst_LOT_STATUS_ENABLED,
c.LOT_STATUS_ENABLED ch_LOT_STATUS_ENABLED,
m.DEFAULT_LOT_STATUS_ID mst_DEFAULT_LOT_STATUS_ID,
c.DEFAULT_LOT_STATUS_ID ch_DEFAULT_LOT_STATUS_ID,
m.SERIAL_STATUS_ENABLED mst_SERIAL_STATUS_ENABLED ,
c.SERIAL_STATUS_ENABLED ch_SERIAL_STATUS_ENABLED ,
m.DEFAULT_SERIAL_STATUS_ID mst_DEFAULT_SERIAL_STATUS_ID,
c.DEFAULT_SERIAL_STATUS_ID ch_DEFAULT_SERIAL_STATUS_ID,
m.LOT_SPLIT_ENABLED mst_LOT_SPLIT_ENABLED,
c.LOT_SPLIT_ENABLED ch_LOT_SPLIT_ENABLED,
m.LOT_MERGE_ENABLED mst_LOT_MERGE_ENABLED,
c.LOT_MERGE_ENABLED ch_LOT_MERGE_ENABLED,
m.INVENTORY_CARRY_PENALTY mst_INV_CARRY_PENALTY,
c.INVENTORY_CARRY_PENALTY ch_INV_CARRY_PENALTY,
m.OPERATION_SLACK_PENALTY mst_OPERATION_SLACK_PENALTY,
c.OPERATION_SLACK_PENALTY ch_OPERATION_SLACK_PENALTY,
m.FINANCING_ALLOWED_FLAG mst_FINANCING_ALLOWED_FLAG,
c.FINANCING_ALLOWED_FLAG ch_FINANCING_ALLOWED_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name LIKE 'INV_IOI_MASTER_CHILD_1I%')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
J) For error: INV_IOI_MASTER_CHILD_1J
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('EAM_ITEM_TYPE',
'EAM_ACTIVITY_TYPE_CODE',
'EAM_ACTIVITY_CAUSE_CODE',
'EAM_ACT_NOTIFICATION_FLAG',
'EAM_ACT_SHUTDOWN_STATUS',
'DUAL_UOM_CONTROL',
'SECONDARY_UOM_CODE',
'DUAL_UOM_DEVIATION_HIGH',
'DUAL_UOM_DEVIATION_LOW',
'SERVICE_ITEM_FLAG',
'USAGE_ITEM_FLAG',
'CONTRACT_ITEM_TYPE_CODE',
'SUBSCRIPTION_DEPEND_FLAG') ;
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.EAM_ITEM_TYPE mst_EAM_ITEM_TYPE,
c.EAM_ITEM_TYPE ch_EAM_ITEM_TYPE,
m.EAM_ACTIVITY_TYPE_CODE mst_EAM_ACTIVITY_TYPE_CODE,
c.EAM_ACTIVITY_TYPE_CODE ch_EAM_ACTIVITY_TYPE_CODE,
m.EAM_ACTIVITY_CAUSE_CODE mst_EAM_ACTIVITY_CAUSE_CODE,
c.EAM_ACTIVITY_CAUSE_CODE ch_EAM_ACTIVITY_CAUSE_CODE,
m.EAM_ACT_NOTIFICATION_FLAG mst_EAM_ACT_NOTIFICATION_FLAG,
c.EAM_ACT_NOTIFICATION_FLAG ch_EAM_ACT_NOTIFICATION_FLAG,
m.EAM_ACT_SHUTDOWN_STATUS mst_EAM_ACT_SHUTDOWN_STATUS,
c.EAM_ACT_SHUTDOWN_STATUS ch_EAM_ACT_SHUTDOWN_STATUS,
m.DUAL_UOM_CONTROL mst_DUAL_UOM_CONTROL,
c.DUAL_UOM_CONTROL ch_DUAL_UOM_CONTROL,
m.SECONDARY_UOM_CODE mst_SECONDARY_UOM_CODE,
c.SECONDARY_UOM_CODE ch_SECONDARY_UOM_CODE,
m.DUAL_UOM_DEVIATION_HIGH mst_DUAL_UOM_DEVIATION_HIGH,
c.DUAL_UOM_DEVIATION_HIGH ch_DUAL_UOM_DEVIATION_HIGH,
m.DUAL_UOM_DEVIATION_LOW mst_DUAL_UOM_DEVIATION_LOW,
c.DUAL_UOM_DEVIATION_LOW ch_DUAL_UOM_DEVIATION_LOW,
m.SERVICE_ITEM_FLAG mst_SERVICE_ITEM_FLAG,
c.SERVICE_ITEM_FLAG ch_SERVICE_ITEM_FLAG,
m.USAGE_ITEM_FLAG mst_USAGE_ITEM_FLAG,
c.USAGE_ITEM_FLAG ch_USAGE_ITEM_FLAG,
m.CONTRACT_ITEM_TYPE_CODE mst_CONTRACT_ITEM_TYPE_CODE,
c.CONTRACT_ITEM_TYPE_CODE ch_CONTRACT_ITEM_TYPE_CODE,
m.SUBSCRIPTION_DEPEND_FLAG mst_SUBSCRIPTION_DEPEND_FLAG,
c.SUBSCRIPTION_DEPEND_FLAG ch_SUBSCRIPTION_DEPEND_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1J')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
K) For error: INV_IOI_MASTER_CHILD_1K
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('SERV_REQ_ENABLED_CODE',
'SERV_BILLING_ENABLED_FLAG',
'PLANNED_INV_POINT_FLAG',
'LOT_TRANSLATE_ENABLED',
'DEFAULT_SO_SOURCE_TYPE',
'CREATE_SUPPLY_FLAG',
'SUBSTITUTION_WINDOW_CODE',
'SUBSTITUTION_WINDOW_DAYS') ;
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.SERV_REQ_ENABLED_CODE mst_SERV_REQ_ENABLED_CODE,
c.SERV_REQ_ENABLED_CODE ch_SERV_REQ_ENABLED_CODE,
m.SERV_BILLING_ENABLED_FLAG mst_SERV_BILLING_ENABLED_FLAG,
c.SERV_BILLING_ENABLED_FLAG ch_SERV_BILLING_ENABLED_FLAG,
m.PLANNED_INV_POINT_FLAG mst_PLANNED_INV_POINT_FLAG,
c.PLANNED_INV_POINT_FLAG ch_PLANNED_INV_POINT_FLAG,
m.LOT_TRANSLATE_ENABLED mst_LOT_TRANSLATE_ENABLED,
c.LOT_TRANSLATE_ENABLED ch_LOT_TRANSLATE_ENABLED,
m.DEFAULT_SO_SOURCE_TYPE mst_DEFAULT_SO_SOURCE_TYPE,
c.DEFAULT_SO_SOURCE_TYPE ch_DEFAULT_SO_SOURCE_TYPE,
m.CREATE_SUPPLY_FLAG mst_CREATE_SUPPLY_FLAG,
c.CREATE_SUPPLY_FLAG ch_CREATE_SUPPLY_FLAG,
m.SUBSTITUTION_WINDOW_CODE mst_SUBSTITUTION_WINDOW_CODE,
c.SUBSTITUTION_WINDOW_CODE ch_SUBSTITUTION_WINDOW_CODE,
m.SUBSTITUTION_WINDOW_DAYS mst_SUBSTITUTION_WINDOW_DAYS,
c.SUBSTITUTION_WINDOW_DAYS ch_SUBSTITUTION_WINDOW_DAYS
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_1K')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
L) For error INV_IOI_MASTER_CHILD_7A
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('NEGATIVE_MEASUREMENT_ERROR',
'ENGINEERING_ECN_CODE',
'ENGINEERING_ITEM_ID',
'ENGINEERING_DATE',
'SERVICE_STARTING_DELAY',
'VENDOR_WARRANTY_FLAG',
'SERVICEABLE_COMPONENT_FLAG') ;
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.NEGATIVE_MEASUREMENT_ERROR mst_NEGATIVE_MEASURE_ERROR,
c.NEGATIVE_MEASUREMENT_ERROR ch_NEGATIVE_MEASURE_ERROR,
m.ENGINEERING_ECN_CODE mst_ENGINEERING_ECN_CODE,
c.ENGINEERING_ECN_CODE ch_ENGINEERING_ECN_CODE,
m.ENGINEERING_ITEM_ID mst_ENGINEERING_ITEM_ID,
c.ENGINEERING_ITEM_ID ch_ENGINEERING_ITEM_ID,
m.ENGINEERING_DATE mst_ENGINEERING_DATE,
c.ENGINEERING_DATE ch_ENGINEERING_DATE,
m.SERVICE_STARTING_DELAY mst_SERVICE_STARTING_DELAY,
c.SERVICE_STARTING_DELAY ch_SERVICE_STARTING_DELAY,
m.VENDOR_WARRANTY_FLAG mst_VENDOR_WARRANTY_FLAG,
c.VENDOR_WARRANTY_FLAG ch_VENDOR_WARRANTY_FLAG,
m.SERVICEABLE_COMPONENT_FLAG mst_SERVICE_COMPONENT_FLAG,
c.SERVICEABLE_COMPONENT_FLAG ch_SERVICE_COMPONENT_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_7A')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
M) For error INV_IOI_MASTER_CHILD_7C
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('TIME_BILLABLE_FLAG',
'MATERIAL_BILLABLE_FLAG',
'EXPENSE_BILLABLE_FLAG',
'PRORATE_SERVICE_FLAG',
'COVERAGE_SCHEDULE_ID',
'SERVICE_DURATION_PERIOD_CODE',
'SERVICE_DURATION',
'WARRANTY_VENDOR_ID') ;
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.TIME_BILLABLE_FLAG mst_TIME_BILLABLE_FLAG,
c.TIME_BILLABLE_FLAG ch_TIME_BILLABLE_FLAG,
m.MATERIAL_BILLABLE_FLAG mst_MATERIAL_BILLABLE_FLAG,
c.MATERIAL_BILLABLE_FLAG ch_MATERIAL_BILLABLE_FLAG,
m.EXPENSE_BILLABLE_FLAG mst_EXPENSE_BILLABLE_FLAG,
c.EXPENSE_BILLABLE_FLAG ch_EXPENSE_BILLABLE_FLAG,
m.PRORATE_SERVICE_FLAG mst_PRORATE_SERVICE_FLAG,
c.PRORATE_SERVICE_FLAG ch_PRORATE_SERVICE_FLAG,
m.COVERAGE_SCHEDULE_ID mst_COVERAGE_SCHEDULE_ID,
c.COVERAGE_SCHEDULE_ID ch_COVERAGE_SCHEDULE_ID,
m.SERVICE_DURATION_PERIOD_CODE mst_SERVICE_DURATION_PER_CODE,
c.SERVICE_DURATION_PERIOD_CODE ch_SERVICE_DURATION_PER_CODE,
m.SERVICE_DURATION mst_SERVICE_DURATION,
c.SERVICE_DURATION ch_SERVICE_DURATION,
m.WARRANTY_VENDOR_ID mst_WARRANTY_VENDOR_ID,
c.WARRANTY_VENDOR_ID ch_WARRANTY_VENDOR_ID
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_7C')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
N) For error INV_IOI_MASTER_CHILD_7E
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN('AUTO_REL_TIME_FENCE_CODE',
'AUTO_REL_TIME_FENCE_DAYS',
'CONTAINER_ITEM_FLAG',
'CONTAINER_TYPE_CODE',
'INTERNAL_VOLUME',
'MAXIMUM_LOAD_WEIGHT',
'MINIMUM_FILL_PERCENT',
'VEHICLE_ITEM_FLAG') ;
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.AUTO_REL_TIME_FENCE_CODE mst_AUTO_REL_TIME_FNC_CD,
c.AUTO_REL_TIME_FENCE_CODE ch_AUTO_REL_TIME_FNC_CD,
m.AUTO_REL_TIME_FENCE_DAYS mst_AUTO_REL_TIME_FNC_DYS,
c.AUTO_REL_TIME_FENCE_DAYS ch_AUTO_REL_TIME_FNC_DYS,
m.CONTAINER_ITEM_FLAG mst_CONTAINER_ITEM_FLAG,
c.CONTAINER_ITEM_FLAG ch_CONTAINER_ITEM_FLAG,
m.CONTAINER_TYPE_CODE mst_CONTAINER_TYPE_CODE,
c.CONTAINER_TYPE_CODE ch_CONTAINER_TYPE_CODE,
m.INTERNAL_VOLUME mst_INTERNAL_VOLUME,
c.INTERNAL_VOLUME ch_INTERNAL_VOLUME,
m.MAXIMUM_LOAD_WEIGHT mst_MAXIMUM_LOAD_WEIGHT,
c.MAXIMUM_LOAD_WEIGHT ch_MAXIMUM_LOAD_WEIGHT,
m.MINIMUM_FILL_PERCENT mst_MINIMUM_FILL_PERCENT,
c.MINIMUM_FILL_PERCENT ch_MINIMUM_FILL_PERCENT,
m.VEHICLE_ITEM_FLAG mst_VEHICLE_ITEM_FLAG,
c.VEHICLE_ITEM_FLAG ch_VEHICLE_ITEM_FLAG
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_7E')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
O) For error INV_IOI_MASTER_CHILD_4H
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN (
'DEFAULT_INCLUDE_IN_ROLLUP_FLAG',
'INVENTORY_ITEM_STATUS_CODE',
'INVENTORY_PLANNING_CODE',
'PLANNER_CODE',
'PLANNING_MAKE_BUY_CODE',
'FIXED_LOT_MULTIPLIER',
'ROUNDING_CONTROL_TYPE',
'CARRYING_COST');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.DEFAULT_INCLUDE_IN_ROLLUP_FLAG mst_DEFAULT_INC_IN_ROLLUP_FLAG,
c.DEFAULT_INCLUDE_IN_ROLLUP_FLAG ch_DEFAULT_INC_IN_ROLLUP_FLAG,
m.INVENTORY_ITEM_STATUS_CODE mst_INVENTORY_ITEM_STATUS_CODE ,
c.INVENTORY_ITEM_STATUS_CODE ch_INVENTORY_ITEM_STATUS_CODE ,
m.INVENTORY_PLANNING_CODE mst_INVENTORY_PLANNING_CODE,
c.INVENTORY_PLANNING_CODE ch_INVENTORY_PLANNING_CODE,
m.PLANNER_CODE mst_PLANNER_CODE,
c.PLANNER_CODE ch_PLANNER_CODE,
m.PLANNING_MAKE_BUY_CODE mst_PLANNING_MAKE_BUY_CODE,
c.PLANNING_MAKE_BUY_CODE ch_PLANNING_MAKE_BUY_CODE,
m.FIXED_LOT_MULTIPLIER mst_FIXED_LOT_MULTIPLIER,
c.FIXED_LOT_MULTIPLIER ch_FIXED_LOT_MULTIPLIER,
m.ROUNDING_CONTROL_TYPE mst_ROUNDING_CONTROL_TYPE,
c.ROUNDING_CONTROL_TYPE ch_ROUNDING_CONTROL_TYPE,
m.CARRYING_COST mst_CARRYING_COST,
c.CARRYING_COST ch_CARRYING_COST
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_4H')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
P) For error INV_IOI_MASTER_CHILD_4L
1. Identify which of the effected attributes are controlled at the master level for your company.
SELECT ATTRIBUTE_NAME,
decode(control_level,1,'master',2,'org',3,'view only')
FROM MTL_ITEM_ATTRIBUTES
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('AUTO_CREATED_CONFIG_FLAG',
'CYCLE_COUNT_ENABLED_FLAG',
'ITEM_TYPE',
'MODEL_CONFIG_CLAUSE_NAME',
'SHIP_MODEL_COMPLETE_FLAG',
'MRP_PLANNING_CODE',
'RETURN_INSPECTION_REQUIREMENT',
'ATO_FORECAST_CONTROL');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.AUTO_CREATED_CONFIG_FLAG mst_AUTO_CREATED_CONFIG_FLAG,
c.AUTO_CREATED_CONFIG_FLAG ch_AUTO_CREATED_CONFIG_FLAG,
m.CYCLE_COUNT_ENABLED_FLAG mst_CYCLE_COUNT_ENABLED_FLAG ,
c.CYCLE_COUNT_ENABLED_FLAG ch_CYCLE_COUNT_ENABLED_FLAG ,
m.ITEM_TYPE mst_ITEM_TYPE,
c.ITEM_TYPE ch_ITEM_TYPE,
m.MODEL_CONFIG_CLAUSE_NAME mst_MODEL_CONFIG_CLAUSE_NAME,
c.MODEL_CONFIG_CLAUSE_NAME ch_MODEL_CONFIG_CLAUSE_NAME,
m.SHIP_MODEL_COMPLETE_FLAG mst_SHIP_MODEL_COMPLETE_FLAG,
c.SHIP_MODEL_COMPLETE_FLAG ch_SHIP_MODEL_COMPLETE_FLAG,
m.MRP_PLANNING_CODE mst_MRP_PLANNING_CODE,
c.MRP_PLANNING_CODE ch_MRP_PLANNING_CODE,
m.RETURN_INSPECTION_REQUIREMENT mst_RTN_INSPECTION_REQUIREMENT,
c.RETURN_INSPECTION_REQUIREMENT ch_RTN_INSPECTION_REQUIREMENT,
m.ATO_FORECAST_CONTROL mst_ATO_FORECAST_CONTROL,
c.ATO_FORECAST_CONTROL ch_ATO_FORECAST_CONTROL
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_4L')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
Q) For error INV_IOI_MASTER_CHILD_4C
1. Identify which of the effected attributes are controlled at the master level for your company.
select attribute_name,
decode(control_level,1,'master',2,'org',3,'view only')
from mtl_item_attributes
WHERE SUBSTR(ATTRIBUTE_NAME,18) IN ('VOLUME_UOM_CODE',
'UNIT_VOLUME',
'RESTRICT_LOCATORS_CODE',
'LOCATION_CONTROL_CODE',
'SHRINKAGE_RATE',
'ACCEPTABLE_EARLY_DAYS',
'PLANNING_TIME_FENCE_CODE');
2. Determine by failed item which attribute(s) has values that are different between the master organization item and the child organization
item.
select m.organization_id masterorg,
c.organization_id childorg,
m.inventory_item_id item_id,
m.segment1 itemname,
m.VOLUME_UOM_CODE mst_VOLUME_UOM_CODE,
c.VOLUME_UOM_CODE ch_VOLUME_UOM_CODE,
m.UNIT_VOLUME mst_UNIT_VOLUME,
c.UNIT_VOLUME ch_UNIT_VOLUME,
m.RESTRICT_LOCATORS_CODE mst_RESTRICT_LOCATORS_CODE,
c.RESTRICT_LOCATORS_CODE ch_RESTRICT_LOCATORS_CODE,
m.LOCATION_CONTROL_CODE mst_LOCATION_CONTROL_CODE,
c.LOCATION_CONTROL_CODE ch_LOCATION_CONTROL_CODE,
m.SHRINKAGE_RATE mst_SHRINKAGE_RATE,
c.SHRINKAGE_RATE ch_SHRINKAGE_RATE,
m.ACCEPTABLE_EARLY_DAYS mst_ACCEPTABLE_EARLY_DAYS,
c.ACCEPTABLE_EARLY_DAYS ch_ACCEPTABLE_EARLY_DAYS,
m.PLANNING_TIME_FENCE_CODE mst_PLANNING_TIME_FENCE_CODE,
c.PLANNING_TIME_FENCE_CODE ch_PLANNING_TIME_FENCE_CODE
from mtl_system_items_interface c,
mtl_system_items_b m
where c.transaction_id IN (select transaction_id from mtl_interface_errors
where message_name = 'INV_IOI_MASTER_CHILD_4C')
and c.inventory_item_id = m.inventory_item_id
and m.organization_id = (select master_organization_id from mtl_parameters p
where c.organization_id = p.organization_id);
STEP 3
----------
Updates to the Inventory Item Master (MTL_SYSTEM_ITEMS_B) table are made via the Master Items Form. or via Open Item Interface.
Development rarely provides a data fix for this table and only when the data cannot be changed online or by the interface.
To implement the solution, please execute the following steps:
1. ONLINE Correction of the Master Organization Item:
Go into the responsibility: Inventory.
Navigate to Items / Master Items
Locate the attributes that show different values across organizations and change the attributes to the desired value and save.
2. CORRECTIONS via OPEN ITEM INTERFACE
Load UPDATE transactions in mtl_system_items_interface for the master organization item.
Load CREATE or UPDATE transactions in mtl_system_items_interface for the child organization item.
Those needing help with this step should see note: <<268968.1>> Understanding Item Import & Debugging problems with item.
3. Retest the issue.
4. Migrate the solution as appropriate to other environments.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15225049/viewspace-660923/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/15225049/viewspace-660923/
1893
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
