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

MOSC Banner

INV_IOI_ERR when loading into Child org

edited Aug 4, 2017 5:01AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

Hi,

We are trying to import new items into Master Org and Child Orgs. Items are loaded into Master Org without any issues. BUt when we try to load into child org, we come across "INV_IOI_ERR" error without any error message. Here are the columns that we are populating for master and child orgs.

insert into mtl_system_items_interface

(segment1,

  description,

  transaction_type,

  organization_id,

  process_flag,

  set_process_id

  ,TEMPLATE_NAME

  )

  values

  ('xitem',

  'xitem_desc',

  'CREATE',

  102,

  1,

  1

  'SVC buy'

  );

Master and child have different templates. The transaction_type is "CREATE"  and we are submitting the import to create new items. Is there anything I am missing here?

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