Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

CANNOT IMPORT ITEMS

edited Mar 29, 2015 10:00AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 8 commentsAnswered
HI All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center