Module: APSuppliersSeverity: HIGH
Supplier External Bank Account Inactive or Lacks Branch Number
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
supplier bank account inactiveIBY_BANK_ACCT_INACTbank branch missingpayment document rejected bank
Root Cause Analysis
Supplier bank account {bankAccountName} has an expired end-date in Oracle Payments banking repository.
Diagnostic SQL Queries (Read-Only)
CHECK_SUPPLIER_BANKVerify active bank account assignment in IBY_EXT_BANK_ACCOUNTS
SELECT b.ext_bank_account_id, b.bank_account_name, b.end_date, p.instrument_id
FROM iby_ext_bank_accounts b
JOIN iby_pmt_instr_uses_all p ON b.ext_bank_account_id = p.instrument_id
WHERE p.ext_pmt_party_id = :partyIdRemediation Mode: MANUAL_UI
Verification Query
SELECT 1 FROM iby_ext_bank_accounts WHERE ext_bank_account_id = :bankAccountId AND end_date IS NULLExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.