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:

Symptoms

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:

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.

Cause

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