Cannot Understand Why We See Wrong Vendor Site Id In MSC_TRADING_PARTNER_SITES Table

(Doc ID 1446673.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.


On : 11.5.10 or R12.X  version, Data Collections

Found that the sr_tp_site_id in the MSC_TRADING_PARTNER_SITES is incorrect. This is very critical as the reports built on this data is not getting populated. This is happening for many items but not all.

Expect to have sr_tp_site_id in the MSC_TRADING_PARTNER_SITES correct

The issue can be reproduced at will with the following steps:
1.Run complete refresh data collection
2.Run the unconstrained plan .
3.The data in msc_trading_partner_sites is wrong.
Please refer the attached screen shots.
4.You are not able release PO for correct vendor site.

The issue has the following business impact:
Due to this issue, users are not able to create PO's for many items.


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