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

Last updated on AUGUST 08, 2023

Applies to:

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

Cause

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