Technology Stack - EBS (MOSC)

MOSC Banner

Invalid Item Number Warning while doing Item Import

edited Aug 20, 2021 11:22AM in Technology Stack - EBS (MOSC) 7 commentsAnswered
 Hi,
I am trying to import Items and categories using Item Import Interface. I populate the mtl_system_items_interface and mtl_item_categories_interface table with the appropriate data. When I run the Item Import it ends with warning. Following is the error:

Message Name: INV_ICOI_INVALID_ITEM_NUMBER
Table Name: MTL_ITEM_CATEGORIES_INTERFACE
Column Name: ITEM_NUMBER
Error Message: Item number 51_A1003|1001 is invalid.

Now the item Number in both MSII and MICI table is identical, still I get this error.

Any pointers will be a great help.

Thanks,
Kumar

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