热词
Item Import Error Details
INV_IOI_MASTER_CHILD Errors in Item Import [ID 429924.1] 2010-04-27 20:49:14
Post completion of the 'Item Import' Program, all the successfully imported record gets into mtl_system_items_b however all the errored out record gets into mtl_interface_errors,
Below SQL which joins mtl_interface_errors with mtl_system_items_interface to fetch all the details relevant to the records errored out.
Below SQL which joins mtl_interface_errors with mtl_system_items_interface to fetch all the details relevant to the records errored out.
SELECT msii.segment1
,mie.column_name
,mie.error_message
FROM apps.mtl_interface_errors mie
,apps.mtl_system_items_interface
msii
WHERE mie.organization_id = 1417
AND mie.transaction_id = msii.transaction_id
AND mie.column_name LIKE 'MASTER_CHILD%'
AND msii.set_process_id IN (:set_process_id)
ORDER BY msii.segment1;
Troubleshooting Details
The most common error is INV_IOI_MASTER_CHILD error, which means there is conflict between master and child organization, as one or more master controlled attributes do not have the same value for an item across master and child organization . 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.
INV_IOI_MASTER_CHILD errors have a range from INV_IOI_MASTER_CHILD_1A to INV_IOI_MASTER_CHILD_1K. Each individual error message relevant to a specific set of attributes.
If there are 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 have a very basic steps:
SOLUTION:
Resolving INV_IOI_MASTER_CHILD errors have a very basic steps:
1) For the encountered error, first determine
which of the effected attributes are controlled at the master level/child
level/view only.
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
- If the master item attribute value is correct, reload the child item (with corrected values) into MTL_SYSTEM_ITEMS_INTERRFACE and rerun Item Import.
- 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
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
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
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
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
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
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
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'
);
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
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
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
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
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
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.
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. ********
BE SURE TO PERFORM. ********
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
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
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
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
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
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
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
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 m.organization_id masterorg
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 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);
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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.
No comments:
Post a Comment