Errors Encountered when Creating a Trading Partner Relationship using FBDI Import (Doc ID 2291600.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Fusion Product and Catalog Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On Fusion Product Hub Cloud Service : 11.12.1.0.0
When attempting to create a Trading Partner Relationship via FBDI, the following errors occurs.

-- Errors
ITEMCONV09(TRC_PO_INV_ORG) :
  ITEMCONV09 : SUPPLIER_ITEM_XREF : 40709-02 : , null - One of the values entered for Trading Partner Item Number, Trading Partner Number or Trading Partner Item Identifier is invalid.
  null, CONTEXT_CODE - You must provide a value for the attribute group that is associated at the item supplier address level.
  null, CONTEXT_CODE - You must provide a value for the attribute group that is associated at the item supplier address level.
  null, null - The values specified for Trading Partner Type, Trading Partner Item Number or Trading Partner Number are invalid.

-- Expected Behaviour
Expect to be able to successfully create Trading Partner Relationships via FBDI Import

 -- Steps
The issue can be reproduced at will with the following steps.
1. Populate data in the following tabs of the Item Import Template
  a. EGP_SYSTEM_ITEMS_INTERFACE
  b. EGP_ITEM_RELATIONSHIPS_INTF
  c. EGO_ITEM_SUPPLIER_INTF_EFF_B
  d. EGO_ITEM_SUPPLIER_INTF_EFF_TL
  e. EGP_TRADING_PARTNER_ITEMS_INTF
2. Generate CSV File
3. Upload File to UCM
4. Run Load Interface File for Import Process
5. Run Item Import Process -> Error Occurs

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot create Trading Partner Relationships via FBDI Import

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