Apply Receipts Using Automatch Is Failing (Doc ID 2053779.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion, Release 9 version, autoply process erroring when applying a zero amount transaction and credit memo to a zero amount receipt with the following error


ERROR
-----------------------
AutoApply: ORA-01476: divisor is equal to zero => 11/06/15 10:23:33
AutoApply: Exception from ar_autoapply_pkg.process_recos => 11/06/15 10:23:33


ENVIRONMENT
--------------------------
Product and Version: Oracle Fusion Receivables (Release 9)


WHAT IS WORKING
-----------------
Manually applying this receipt to the transaction and credit memo

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a receipt for zero dollars
2. There are invoices and credit memos which equal to zero
3. Ran the auto apply to apply both credit memos and invoices and it is failing with an error divisor equal to zero


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run autoapply

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