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

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms