My Oracle Support Banner

R12:AP/AR:Reverse Netting Batch Report Goes In Error- "APP-SQLAP-10786: No payments were found to reconcile" Due To Manual Unclearing In Cash Management (Doc ID 2975941.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

 Unable to reverse an AP/AR Netting batch. It throws error while reversing.

Error in FND Debug Log messages

FUN.PLSQL.funntcrb.FUN_NET_CANCEL_PKG.reverse_ap_checks Reversing check for batch:4xxx1
FUN.PLSQL.funntcrb.FUN_NET_CANCEL_PKG.reverse_ap_checks Reversing check for check :2xxxx24
AP.PLSQL.AP_VOID_PKG.Ap_Reversal_Check AP_VOID_PKG.AP_REVERSE_CHECK<-Netting Batch - Reversing
AP.PLSQL.AP_VOID_PKG.Ap_Reversal_Check Get set of books id
AP.PLSQL.AP_VOID_PKG.Ap_Reversal_Check Get patch set level
AP.PLSQL.AP_VOID_PKG.Ap_Reversal_Check Is AP patch set level above branchline :Y
...
AP.PLSQL.AP_RECONCILIATION_PKG.recon_payment_unclearing checkrun is null, recon flag is Y, before select
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-SQLAP-10786: No payments were found to reconcile.

Steps to reproduce:
----------------------
1. (N) Payables Responsibility > Payments > Netting > Netting Batch
2. Query the problematic Netting Batch.
3. Click on Action button (icon) in order to reverse the batch
4. The error is thrown up.
 

Changes

 

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
Changes
Cause
Solution
References


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