Editing Data Errors in the Item Loader Staging Tables

View and modify the item data that is staged in the Item Loader staging tables by using the Data Definition Maintenance component. The Item Loader process flags any records with data errors that have an Error status. From the Data Definition Maintenance component, you can access the Item Loader Data Maintenance pages, correct errors, and edit the staged item data.

After correcting the data errors, you can rerun the Item Loader process to populate the master data tables with the corrected item records.

The error is also found in the item loader error table (ITEMLOAD_ERR).

Page Name

Definition Name

Usage

Data Def Maint Page

EO_EIP_CTL_MAINT

Access the data definition maintenance - stage table data. The page provides information such as: the EIP control ID, the transaction type, reference data, the publishing node, the channel name, the last update date and time, and the process instance number.

Data Definition Maintenance - Errors Page

IN_EIP_ITEM_MAINT

Access the error details of Item Loader data. Access other pages where fields for specific segments of the Item Loader data can be edited.

Data Definition Maintenance - Item Definition - General: Common Page

IN_EIPITM_DEF1

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Errors Page

Data Definition Maintenance - Item Definition - General: Classifications Page

IN_EIPITM_DEF4

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - General: Dimensions Page

IN_EIPITM_DEF3

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - General: Usage Page

IN_EIPITM_DEF8

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - General: Related Language Page

PV_EIPITM_DEF1

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - Inventory: Tracking/Description Page

IN_EIPITM_DEF2

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - Inventory: Shipping/Handling Page

IN_EIPITM_DEF5

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item Definition - Inventory: Related Language Page

PV_EIPITM_DEF2

Edit item definition fields in the SetID-level segment of staged Item Loader data.

Data Definition Maintenance - Item UOM (item unit of measurement) - Item UOM Page

IN_EIPITEM_UOM

Edit item definition fields in the item UOM segment of staged Item Loader data.

Data Definition Maintenance - Errors Page

Data Definition Maintenance - Item UOM - Item UOM Weight Volume Page

IN_EIPITEM_UOM_WVL

Edit item definition fields in the item UOM segment of staged Item Loader data.

Data Definition Maintenance - Item Revision - Item Revision Page

MG_EIPEN_REVISION

Edit item definition fields in the item revision segment of staged Item Loader data.

Data Definition Maintenance - Item Revision - Revision Text Page

MG_EIPEN_REV_TEXT

Edit item definition fields in the item revision segment of staged Item Loader data.

Data Definition Maintenance - Manufacturers Page

IN_EIP_ITEM_MFG

Edit item definition fields in the item manufacturer segment of staged Item Loader data.

Data Definition Maintenance - Errors Page

Date Definition Maintenance - Universal Item Identifiers Page

IN_EIP_ITEM_UPN

Maintain data in the universal item identifiers segment on the item stage tables.

Data Definition Maintenance - BU Attributes (business unit attributes) - General: Common Page

IN_EIPBU_GEN_ATTR

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - Errors Page

Data Definition Maintenance - BU Attributes - General: Usage Page

IN_EIPBU_MATRL_USG

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - General: Export Information Page

IN_EIPBU_GATTR_EXP

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - Inventory: Shipping/Handling Page

IN_EIPBU_OVRD_ATTR

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - Inventory: Replenishment Page

IN_EIPBU_RPLN_ATTR

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - Inventory: Weight/Volume Page

IN_EIPBU_WTVL_ATTR

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - Manufacturing: General Page

IN_EIPBU_MFG_ATTR

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - BU Attributes - Manufacturing: WIP Replenishment Page

IN_EIPBU_MFG_ATTR2

Edit item definition fields in the business unit and item definition segment of staged Item Loader data.

Data Definition Maintenance - PO Attributes - Purchasing Attributes Page

PO_EIPITM_TBL_PUR

Edit item definition fields in the item purchasing attributes segment of staged Item Loader data.

Data Definition Maintenance - PO Attributes - Purchasing Controls Page

PO_EIPITM_TBL_PUR2

Edit item definition fields in the item purchasing attributes segment of staged Item Loader data.

Data Definition Maintenance - PO Attributes - Purchasing Controls 2 Page

PO_EIPITM_TBL_PUR3

Edit item definition fields in the item purchasing attributes segment of staged Item Loader data.

Data Definition Maintenance - PO Attributes - Related Language Page

PV_EIPITM_DEF4

Edit item definition fields in the item purchasing attributes segment of staged Item Loader data.

Data Definition Maintenance - Categories Page

PV_EIPITEM_CAT

Edit item definition fields in the item category segment of staged Item Loader data.

Data Definition Maintenance - Item Supplier - Item Suppliers Page

PO_EIPITEM_VENDOR1

Edit item definition fields in the item supplier segment of staged Item Loader data.

Data Definition Maintenance - Item Supplier - Locations Page

PO_EIPITEM_VENDOR2

Edit item definition fields in the item supplier segment of staged Item Loader data.

Data Definition Maintenance - Item Supplier - UOM Page

PO_EIPITM_VND_UOM1

Edit item definition fields in the item supplier segment of staged Item Loader data.

Data Definition Maintenance - Item Supplier - UOM Price Page

PO_EIPITM_VND_UOM2

Edit item definition fields in the item supplier segment of staged Item Loader data.

Data Definition Maintenance - Item Mfg GPO Errors Page

IN_EIPITM_MFG_GPO

Edit item definition fields in the item manufacturer GPO segment of staged Item Loader data.

Use the Data Definition Maintenance - Errors page (IN_EIP_ITEM_MAINT) to access the error details of Item Loader data.

Access other pages where fields for specific segments of the Item Loader data can be edited.

Navigation:

SCM Integrations > Transaction Error Handling > Transaction Error Data Defn

Select the ITEM transaction type, and click the Search button.

Click the Show Detail Entry button for the desired row to view the error.

This example illustrates the fields and controls on the Data Definition Maintenance - Errors page. You can find definitions for the fields and controls later on this page.

 Data Definition Maintenance - Errors page

If the staged Item Loader data contains errors, each field with an error appears in the Errors scroll area. The field name appears along with message text describing the problem and a record description. Click the Detail button to access the page where you can correct the error.

Click the links at the bottom of the page to access pages where you can modify the fields that are included in each segment of the message.

Note: If the Item Loader data for an item does not contain a specific message segment, you cannot access the corresponding pages.