My Oracle Support Banner

R12: CE: Autoreconciliation For Zero Payments In Foreign Currency Is Failing With Error: AP_DEBUG (Doc ID 2394357.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

AutoReconciliation request completed with the following error message AP_DEBUG and the FND log display the below error:
 

ERROR
-----------------------

fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in CE_AUTO_BANK_CLEAR1.reconcile_trx AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING
with parameters (&PARAMETERS)while performing the following operation: checkrun is null, inside "
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in CE_AUTO_BANK_CLEAR1.reconcile_trx AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING
with parameters (&PARAMETERS)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a bank statement line amount 0
2. Run Autoreconciliation, but the zero payments in foreign currency aren't get reconcile
3. The request is completed with the following Error message: AP_DEBUG


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot autoreconcile zero payments in foreign currency.

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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