Symptoms

• AP payment processing fails or generates errors related to supplier bank account configuration.
• Multiple active bank account use records exist in AP_BANK_ACCOUNT_USES_ALL for the same supplier/site combination, causing conflicts when selecting payment accounts.
• Payments are rejected or routed to incorrect bank accounts due to duplicate/unended bank account use records.

Root Cause

Bank account use records in AP_BANK_ACCOUNT_USES_ALL became corrupted — either duplicate records were created or end dates were not properly applied when supplier bank accounts were updated or replaced. The presence of multiple active (non-ended) bank account use records for the same supplier site caused payment processing to fail or produce incorrect results.

Resolution

Run data_fix.sql. The script creates a backup of all affected AP_BANK_ACCOUNT_USES_ALL records identified via joins to supplier and bank account tables.

The script identifies bank account use records for supplier/site combinations that have multiple active records without proper end dates, joining:

• AP_BANK_ACCOUNT_USES_ALL
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• AP_BANK_ACCOUNTS_ALL

Update AP_BANK_ACCOUNT_USES_ALL to stamp an end_date on the corrupted/duplicate records, effectively inactivating them while leaving the correct active record without an end date.

Issue COMMIT. Confirm that each supplier/site now has only one active (non-ended) bank account use record. Retry the affected payment run.

Script Inventory

Key Tables Affected