My Oracle Support Banner

Duplicate Payment Methods At Supplier Site Level (Doc ID 2362195.1)

Last updated on DECEMBER 16, 2020

Applies to:

Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When reviewing a supplier, there are duplicate Payment Methods at Supplier Site Level. The sites both show Primary. There should only be one primary payment method for the supplier site.

One of the following scripts to analyze the data returns data:

Select *
FROM iby_ext_party_pmt_mthds pmtmthd
WHERE pmtmthd.ext_party_pmt_mthd_id IN
(SELECT ext_party_pmt_mthd_id
FROM
(SELECT ext_party_pmt_mthd_id,
payment_method_code,
ext_pmt_party_id,
inactive_date,
rank() OVER (PARTITION BY payment_method_code, ext_pmt_party_id ORDER BY
inactive_date DESC) rank
FROM iby_ext_party_pmt_mthds
)
WHERE rank > 1
);

select *
FROM iby_ext_party_pmt_mthds pmtmthd
WHERE pmtmthd.ext_party_pmt_mthd_id IN
(SELECT ext_party_pmt_mthd_id
FROM
(SELECT ext_party_pmt_mthd_id,
payment_method_code,
ext_pmt_party_id,
primary_flag,
inactive_date,
rank() OVER (PARTITION BY ext_pmt_party_id, primary_flag ORDER BY
inactive_date DESC, ext_party_pmt_mthd_id) rank
FROM iby_ext_party_pmt_mthds
)
WHERE rank > 1
);

 

select iby.*, pv.segment1 vendor_no, pv.vendor_name, epa.supplier_site_id, pvsa.vendor_site_code
from
(
select count(1) over (partition by payment_method_code,ext_pmt_party_id) cnt
, ext_party_pmt_mthd_id,
payment_method_code,
ext_pmt_party_id,
inactive_date,
primary_flag
from iby_ext_party_pmt_mthds
where primary_flag ='Y'
)iby,
po_vendors pv ,
iby_external_payees_all epa,
po_vendor_sites_all pvsa
where cnt > 1
and  pv.party_id = epa.payee_party_id
and epa.ext_payee_id = iby.ext_pmt_party_id
and epa.supplier_Site_id = pvsa.vendor_site_id(+);

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.