CANNOT IMPORT ITEMS
I am trying to update lead time for some 2000 existing items in 11i. The process followed is described below:
1. Insert the record in interface table MTL_SYSTEM_ITEMS_INTERFACE as
example: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE (SEGMENT1,POSTPROCESSING_LEAD_TIME,SET_PROCESS_ID,PROCESS_FLAG,TRANSACTION_TYPE,ORGANIZATION_ID)
VALUES ('ABC123',50,12345,1,'UPDATE',2222);
2. Run the Import Item program as
Inventory > Items > Import > Import Items
ISSUE:
I am getting the following errors for different items:
a. Error Message : INV_IOI_SUP_LOC_ID_MANDATORY Column Name : WIP_SUPPLY_LOCATOR_ID
b. Error Message :INV_IOI_PUR_TAX_CODE Column Name : PURCHASING_TAX_CODE