R12/CE: Payment Batch Reconciliation, AutoReconciliation, Payment Instruction, Batch Name, ACH, EFT, BAT (Doc ID 1240767.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

Issue 1: Autoreconciliation of Payment Batch:
Auto-reconciliation by payment instruction: You are trying to automatically reconcile the electronic payment of from bank statement by using payment instruction. It errors as:
ARPLABRC module: AutoReconciliation:

No matching payment
No matching payment batch
No matching payment group

Issue 2: Manual Reconciliation of Payment batch?

Issue 3: Cannot Find AP 11i Payment Batch Migrated to R12?

Issue 4: When attempting to When USER Manually Reconcile a Payment it errors as:
the following error occurs.

APP-SQLAP-10000:ORA-01403: no data found occurred in
AP_RECONCILIATION_PKG.insert_payment_history<-CE_AUTO_BANK_CLEAR1.reconcile_t
rx AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING ->
AP_ACCOUNTING_EVENTS_PKG.CREATE_EVENTS ->
AP_ACCOUNTING_EVENTS_PKG.CREATE_PAYMENT_EVENT
with parameters (p_event_type = PAYMENT CLEARED, p_check_id = <CHECK_ID>,
p_event_date = <EVENT_DATE>)
while performing the following operation:
Begin of procedure CREATE_PAYMENT_EVENT"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.