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 |
---|---|---|
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. |
|
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 - 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 - 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. |
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 - 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:
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](img/i2a517932n-74f7.png)
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.