My Oracle Support Banner

R12: AP: Supplier Merge Results In Error: ORA-00001: unique constraint (IBY.IBY_ACCOUNT_OWNERS_U2) violated (Doc ID 2804104.1)

Last updated on FEBRUARY 27, 2025

Applies to:

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

Symptoms

In Oracle Payables, when a user attempts to merge two suppliers using the Supplier Merge form, the following error occurs:

ERROR
-------
Unexpected error: ORA-00001: unique constraint (IBY.IBY_ACCOUNT_OWNERS_U2) violatediby.plsql.IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(MERGE_BANKS)


The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Suppliers>Supplier Merge

3. Execute the merge.

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


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