ITEM IMPORT - INCOIN
Pre-requisites:
* Creating an Organization
* Code Combinations
* Templates
* Defining Item Status Codes
* Defining Item Types
Interface tables:
1. MTL_SYSTEM_ITEMS_INTERFACE
2. MTL_ITEM_REVISIONS_INTERFACE (If importing revisions)
3. MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)
4. MTL_INTERFACE_ERRORS (View Fallouts after import)
Concurrent Programs:
1. Import Items
Parameters :
Process Set (Null for All) - Set_Process_Id = Some Number - Non-Required numeric value set
Create or Update Items = CREATE New Items or UPDATE Existing Items
Validate Items = Yes or No
Process Items = Yes or No
Delete Processed Rows = Yes or No
Gather Statistics = Yes or No
Base Table:
1. MTL_SYSTEM_ITEMS_B
2. MTL_ITEM_REVISIONS_B
3. MTL_CATEGORIES_B
4. MTL_CATEGORY_SETS_B
5. MTL_ITEM_STATUS
6. MTL_ITEM_TEMPLATES
Validation:
1. Check for valid item type. (FND_LOOKUP_TYPES_VL where LOOKUP_TYPE = 'ITEM_TYPE')
2. Check for valid part_id/segment of the source table. (MTL_SYSTEM_ITEMS_B)
3. Validate part_id/segment1 for master org. (MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS)
4. Validate and translate template id of the source table. (MTL_ITEM_TEMPLATES)
5. Check for valid template id. (Attributes are already set for items, default attributes for that template, i.e., purchasable, stockable, etc )
6. Check for valid item status.
7. Validate primary uom of the source table.
8. Validate attribute values.
9. Validate other UOMs of the source table.
10. Check for unique item type. Discard the item, if part has non-unique item type.
11. Check for description, inv_um uniqueness
12. Validate Inventory Organization id.
13. Load master records and category records only if all Load child record if no error found.
Some important columns that need to populated in the MTL_SYSTEM_ITEMS_INTERFACE tables
1. PROCESS_FLAG = 1 (1= Pending, 2= Assign Complete, 3= Assign/Validation Failed, 4= Validation succeeded; Import failed, 5 = Import in Process, 7 = Import succeeded)
2. TRANSACTION_TYPE = ‘CREATE’, ‘UPDATE’
3. SET_PROCESS_ID = 1
4. ORGANIZATION_ID
5. DESCRIPTION
6. ITEM_NUMBER and/or SEGMENT (n)
7. MATERIAL_COST
8. REVISION
9. TEMPLATE_ID
10. SUMMARY_FLAG
11. ENABLED_FLAG
12. PURCHASING_ITEM_FLAG
13. SALES_ACCOUNT (defaulted from MTL_PARAMETERS.SALES_ACCOUNT)
14. COST_OF_SALES_ACCOUNT (defaulted from MTL_PARAMETERS.COST_OF_SALES_ACCOUNT)
Pre-requisites:
* Creating an Organization
* Code Combinations
* Templates
* Defining Item Status Codes
* Defining Item Types
Interface tables:
1. MTL_SYSTEM_ITEMS_INTERFACE
2. MTL_ITEM_REVISIONS_INTERFACE (If importing revisions)
3. MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)
4. MTL_INTERFACE_ERRORS (View Fallouts after import)
Concurrent Programs:
1. Import Items
Parameters :
Process Set (Null for All) - Set_Process_Id = Some Number - Non-Required numeric value set
Create or Update Items = CREATE New Items or UPDATE Existing Items
Validate Items = Yes or No
Process Items = Yes or No
Delete Processed Rows = Yes or No
Gather Statistics = Yes or No
Base Table:
1. MTL_SYSTEM_ITEMS_B
2. MTL_ITEM_REVISIONS_B
3. MTL_CATEGORIES_B
4. MTL_CATEGORY_SETS_B
5. MTL_ITEM_STATUS
6. MTL_ITEM_TEMPLATES
Validation:
1. Check for valid item type. (FND_LOOKUP_TYPES_VL where LOOKUP_TYPE = 'ITEM_TYPE')
2. Check for valid part_id/segment of the source table. (MTL_SYSTEM_ITEMS_B)
3. Validate part_id/segment1 for master org. (MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS)
4. Validate and translate template id of the source table. (MTL_ITEM_TEMPLATES)
5. Check for valid template id. (Attributes are already set for items, default attributes for that template, i.e., purchasable, stockable, etc )
6. Check for valid item status.
7. Validate primary uom of the source table.
8. Validate attribute values.
9. Validate other UOMs of the source table.
10. Check for unique item type. Discard the item, if part has non-unique item type.
11. Check for description, inv_um uniqueness
12. Validate Inventory Organization id.
13. Load master records and category records only if all Load child record if no error found.
Some important columns that need to populated in the MTL_SYSTEM_ITEMS_INTERFACE tables
1. PROCESS_FLAG = 1 (1= Pending, 2= Assign Complete, 3= Assign/Validation Failed, 4= Validation succeeded; Import failed, 5 = Import in Process, 7 = Import succeeded)
2. TRANSACTION_TYPE = ‘CREATE’, ‘UPDATE’
3. SET_PROCESS_ID = 1
4. ORGANIZATION_ID
5. DESCRIPTION
6. ITEM_NUMBER and/or SEGMENT (n)
7. MATERIAL_COST
8. REVISION
9. TEMPLATE_ID
10. SUMMARY_FLAG
11. ENABLED_FLAG
12. PURCHASING_ITEM_FLAG
13. SALES_ACCOUNT (defaulted from MTL_PARAMETERS.SALES_ACCOUNT)
14. COST_OF_SALES_ACCOUNT (defaulted from MTL_PARAMETERS.COST_OF_SALES_ACCOUNT)
