ASCP Query Issue - Supplier Site in Order Query Vs. Source Supplier Site In Find Window (Doc ID 2167938.1)

Last updated on FEBRUARY 09, 2022

Applies to:

Symptoms

12.1.3 .8
reproduced by support on 12.1.3.9.1

PROBLEM
-------------
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:
sqlid='75t9fjjs59f2g'
select distinct partner_site_id hidden, tp_site_code display
from
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
from
 msc_trading_partner_sites where partner_type = 1 and tp_site_code is not
  null order by tp_site_code
-- 8232 rows returned internally


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

EXPECTED BEHAVIOR
----------------------------
should not return duplicate records

BUSINESS IMPACT
----------------------
cannot chose the correct site when there are many duplicates for same site code.

Cause

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