Case 00040609 – AP Bank Account Uses Data Corruption

AP Bank Account Uses Data Corruption — Revised End Date Fix (Iteration B)

Case Number	00040609
Oracle Module	Accounts Payable (AP) / Oracle Payments (IBY)
EBS Version	R12
Functional Area	Supplier Bank Accounts / Payment Processing
Related Patches	None

Symptoms

AP payment processing fails or generates errors related to supplier bank account configuration.
Duplicate or corrupted records in AP_BANK_ACCOUNT_USES_ALL for supplier/site combinations cause payment routing issues.
The initial fix (case 00037149, iteration A) did not fully resolve all affected records — additional records required an end date.

Root Cause

This is a follow-on fix to case 00037149. After the initial fix was applied, additional corrupted bank account use records were identified that also required end-dating. The original script (iteration A) addressed one subset of records; this revised script (iteration B) addresses the remaining records with improved error handling (WHENEVER SQLERROR CONTINUE to handle cases where some records may already be fixed).

Resolution

Step 1 – Create backup table

Run data_fix.sql. The script creates a backup of all newly identified affected AP_BANK_ACCOUNT_USES_ALL records.

Step 2 – Identify remaining affected records

The script queries for bank account use records for supplier/site combinations that still have multiple active (non-ended) records after the initial fix, joining AP_BANK_ACCOUNT_USES_ALL, PO_VENDORS, PO_VENDOR_SITES_ALL, and AP_BANK_ACCOUNTS_ALL.

Step 3 – Apply end dates to remaining corrupted records

Update AP_BANK_ACCOUNT_USES_ALL to stamp an end_date on the remaining corrupted/duplicate records.

Step 4 – Commit and validate

Issue COMMIT. Confirm payment processing succeeds for all previously affected supplier/site combinations.

Note: This is iteration B of the fix. Iteration A (case 00037149) should be applied first if starting fresh. The script uses WHENEVER SQLERROR CONTINUE to tolerate records that may already be corrected. Connects to custom schema for execution.

Script Inventory

File	Description
data_fix.sql	Revised (iteration B) fix for AP Bank Account Uses data corruption. End-dates remaining corrupted records in AP_BANK_ACCOUNT_USES_ALL not addressed by the initial fix (case 00037149). Includes improved error handling.

Key Tables Affected

Table	Action
AP_BANK_ACCOUNT_USES_ALL	Update END_DATE on remaining corrupted/duplicate records