EGOIREL: Import Related Items Via Interface (Mtl_Related_Items_Interface) Fails With Error: Relationship type id 1 is not a valid relationship type
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
Trying to create related items with interface table.
Relationship type id 1 is not a valid relationship type.
What is working
Other types (like substitute item) work except type 1 / related item.
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:
12 Mandatory Charge
13 Optional Charge
14 Promotional Upgrade
18 Repair To
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms