My Oracle Support Banner

R12: AP/AR/IBY: Receive Error when Trying to Add an Owner to a Bank Account when the Owner was Previously End Dated "Unique Check: same party cannot be assigned the same bank account more than once" (Doc ID 3004034.1)

Last updated on FEBRUARY 12, 2024

Applies to:

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


When trying to add an owner to a bank account via API, when the owner was a previous owner that was end dated, the following error occurs:

Unique Check: same party cannot be assigned the same bank account more than once.

Steps to cause the issue:

  1. From a Payables Responsibility navigate to Suppliers -> Entry
  2. Pull up an existing supplier
  3. Click on the "Bank Details" tab
  4. Click "Create"
  5. Enter the details for a supplier bank account
  6. Click "Apply"
  7. Click "OK"
  8. Click "Save"
  9. Click on the "Update" icon to re-edit the account
  10. In the "Account Owners" section specify an "End Date"
  11. Click "Apply"
  12. Use the API to try and add the supplier as an owner again
  13. This will error with the Unique Check error since the supplier is still an owner, even if end dated.


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

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