ASCP Query Issue - Supplier Site in Order Query Vs. Source Supplier Site In Find Window
(Doc ID 2167938.1)
Last updated on JULY 22, 2020
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
reproduced by support on 188.8.131.52.1
When trying to select the Supplier Site in the Order Query -- functionality does not match functionality of:
A> Supplier query
B> Find window on supply/demand
For Order Query - it displays duplicate data and uses:
select distinct partner_site_id hidden, tp_site_code display
msc_trading_partner_sites where partner_type = 1 and tp_site_code is not null
order by display
-- 1481 rows returned internally with many duplicate rows
For Supplier query and Find window - it uses
SQL ID: 03143bfkfvt2w Plan Hash: 1857868835
select distinct tp_site_code hidden, tp_site_code display
msc_trading_partner_sites where partner_type = 1 and tp_site_code is not
null order by tp_site_code
-- 8232 rows returned internally
For Order Query - create and choose Supplier Site, equals, click lookup for sites
For Supplier Query - create and choose Supplier Site, equals, click lookup for sites
For Find window - use source Supplier Site , equals, click lookup for sites
should not return duplicate records
cannot chose the correct site when there are many duplicates for same site code.
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