My Oracle Support Banner

FA:SCM:PIM:Trading Partner Item Does Not Exist (Doc ID 2735597.1)

Last updated on AUGUST 08, 2023

Applies to:

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


For a given PIM item, on the Item Page -> Relationships -> Trading Partner Item Relationships there is one row corresponding to a given relationship/trading partner yet when querying the DB, the result shows more relationships for the same trading partner

This was identified when a discrepancy was noticed between an order confirmation email and the data in the UI e.g. the email was referencing a TPI that was not visible in the UI.

This can cause potential auditing issues for customers because data in UI does not appear to be consistent with the data in the DB

The issue can be reproduced at will with the following steps:
1. Navigate to PIM -> Manage Items -> search for the master item and access it
2. Navigate to Relationships -> Trading Partner Items -> query by example on trading partner
3. Notice that only one result is returned
4. Navigate to Tools -> Reports and Analytics -> Browse Catalog -> Data Model -> create a new SQL Data Set w/ Data Source: ApplicationDB_FSCM and input the following query

FROM egp_trading_partner_items ETPI,
         egp_item_relationships_b EIR,
AND ETPI.trading_partner_id= <enter TPID>
AND EIR.tp_item_id=ETPI.tp_item_id
and esi.inventory_item_id=EIR.inventory_item_id
and esi.item_number= <enter ItemNumber>

5. Notice that it returns more than one entry


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.