Case 00029586 – AP Bank Account Uses Duplicate Record — Delete and Rebuild Payment Batch (11i)

AP Bank Account Uses Duplicate Record — Delete and Rebuild Payment Batch (11i)

Case Number	00029586
Oracle Module	Accounts Payable (AP)
EBS Version	11i (11.5.10.2)
Functional Area	Payment Processing / Bank Account Setup
Related Patches	None

Symptoms

A payment batch fails to build or process due to a duplicate record in AP_BANK_ACCOUNT_USES_ALL.
The duplicate bank account use record causes a unique constraint violation or unexpected behavior when the system attempts to select a bank account for payment.
The affected bank_account_uses_id identifies a duplicate row that should not exist.

Root Cause

A duplicate record exists in AP_BANK_ACCOUNT_USES_ALL — the table that maps bank accounts to suppliers, operating units, or payment documents for use in the AP payment process (11i bank account model). The duplicate entry was likely created by a concurrent process, a data migration, or a manual insert. The fix deletes the duplicate row and rebuilds the payment batch.

Resolution

Step 1 – Create backup table

Run data_fix.txt. A backup of the affected AP_BANK_ACCOUNT_USES_ALL row is created.

Step 2 – Delete the duplicate record

Delete from AP_BANK_ACCOUNT_USES_ALL for the specific bank_account_uses_id that is the duplicate. Commit.

Step 3 – Rebuild the payment batch

Rebuild the affected payment batch through the AP Payment Batch window or via the Build Payments concurrent program to confirm the batch can be successfully built with the duplicate record removed.

Note: This fix applies to the 11i AP bank account model, which uses AP_BANK_ACCOUNT_USES_ALL to assign bank accounts. In R12, bank account assignments moved to the Oracle Payments (IBY) tables — IBY_EXT_BANK_ACCOUNTS and IBY_PMT_INSTR_USES_ALL. This fix is delivered as a .txt file containing a brief action plan.

Script Inventory

File	Description
data_fix.txt	Brief action plan (not a standalone executable script). Creates backup of the duplicate AP_BANK_ACCOUNT_USES_ALL row; deletes the duplicate record; instructs to rebuild the payment batch.

Key Tables Affected

Table	Action
AP_BANK_ACCOUNT_USES_ALL	Delete duplicate bank account use record