R12 Supplier Merge Unexpected Error: ORA-00001: Unique Constraint (IBY.IBY_ACCOUNT_OWNERS_U2) (Doc ID 1498497.1)

Last updated on AUGUST 31, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Other-MiscIss & KeyIndReport

When attempting to migrating to R12 from 11i,
In Supplier Merge in R12
the following error occurs.

ERROR
-----------------------

While performming standard functionality for a Supplier Merge in R12.
In 11i customer has only 1 Operating Unit - In R12 customer has many Operating Units.
The error message that we received was:
Calling IBY API - Start
In IBY merge call, p_last_site_flag:Y
Unexpected error: ORA-00001: unique constraint (IBY.IBY_ACCOUNT_OWNERS_U2) violatediby.plsql.IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(MERGE_BANKS)
In IBY merge call, l_return_status:U


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When attempting to migrating to R12 from 11i,
In Supplier Merge in R12

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Supplier Merge in R12

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