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

MOSC Banner

Assign Inventory Items to an Organization through 'Import Items'

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

Product R12.1.3.

Assign Inventory Items (Already created / Uploaded and existing in Master Items)to a newly defined Inventory Organization through uploading to 'mtl_system_items_interface' and then executing 'Import Items'.

It used to work fine before. But this time it is not working and all items are rejected with same error-message "The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE".

This is SQL Script:

---------------------------

select

a.set_process_id, --> Value = 1
a.organization_id,--> Correct ORG_ID
a.segment1 ,      --> Item Code (Existing in Mater Items)

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