My Oracle Support Banner

R12: AP: Identify And Fix Duplicate Suppliers With Same Employee Id (Doc ID 2793686.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When making any update to a supplier the following error may occur:

This Employee Name is already assigned to another supplier. Re-enter.

Steps to Reproduce

Using a Payables Responsibility

1. Login with a Payables Responsibility
2. Navigate: Suppliers > Enter
3. Search/find supplier
4. Attempt to make an update to the Supplier
5. Error message occurs

 


Identify Query

SELECT aps.vendor_id ,
aps.employee_id,
aps.vendor_name,
papf.full_name,
papf.party_id,
aps.party_id
FROM ap_suppliers aps,
per_all_people_f papf
WHERE aps.employee_id = papf.person_id
AND aps.employee_id in (SELECT employee_id FROM ap_suppliers GROUP BY employee_id Having Count(*) > 1)
/

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