My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

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


STEPS
-----------------------
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


SELECT ETPI.*
FROM egp_trading_partner_items ETPI,
         egp_item_relationships_b EIR,
         EGP_SYSTEM_ITEMS_B ESI
WHERE 1=1
AND ETPI.trading_partner_id= <enter TPID>
AND EIR.tp_item_id=ETPI.tp_item_id
AND EIR.MASTER_ORGANIZATION_ID=ESI.ORGANIZATION_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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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