My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Cash Management - Version 12.1.1 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

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 = 17003,
p_event_date = 03-AUG-12)
while performing the following operation:
Begin of procedure CREATE_PAYMENT_EVENT"

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.