Duplicate Payment Methods At Supplier Site Level

(Doc ID 2362195.1)

Last updated on FEBRUARY 21, 2018

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
);

Changes

 This is typically noticed after an upgrade from 11i or an earlier version of R12 to a later version.

Cause

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