EGOIREL: Import Related Items Via Interface (Mtl_Related_Items_Interface) Fails With Error: Relationship type id 1 is not a valid relationship type (Doc ID 2043035.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Trying to create related items with interface table.

Error
Relationship type id 1 is not a valid relationship type.

What is working
Other types (like substitute item) work except type 1 / related item.

Steps
1. Insert relationship into interface.
2. Run interface (concurrent program Import Related Items).
3. Record fails with error.

Example Insert statement creating a related item between two items prompting for the part numbers (not item id but segment1), organization id, and user id:

Example output:

1    Related
2    Substitute
3    Cross-Sell
4    Up-Sell
5    Service
6    Prerequisite
7    Collateral
8    Superseded
9    Complimentary
10   Impact
11   Conflict
12   Mandatory Charge
13   Optional Charge
14   Promotional Upgrade
15   Split
16   Merge
17   Migration
18   Repair To
19   Regulatory

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms