Module: ARLockboxSeverity: HIGH
Lockbox Transmission Line Rejected: Customer Number or Check Unmatched
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
lockbox rejectedAR_LBX_UNMATCHEDcustomer not found in ar_payments_interfaceinvalid bank transit number
Root Cause Analysis
Lockbox transmission {transmissionName} has receipt {checkNumber} with customer account mismatch.
Diagnostic SQL Queries (Read-Only)
CHECK_LOCKBOX_STAGINGInspect rejected records in AR_PAYMENTS_INTERFACE_ALL
SELECT transmission_name, item_number, customer_number, check_number, amount, status
FROM ar_payments_interface_all
WHERE transmission_name = :transmissionName AND status = 'AR_PLB_INVALID_CUSTOMER'Remediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM ar_payments_interface_all WHERE transmission_name = :transmissionName AND status != 'PROCESSED'Execute 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.