Unable to Apply Receipt to Invoice with Multiples Lines when One line has a Negative Balance (Doc ID 764390.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Receivables - Version: 12.0.0 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.
Form:ARXRWMAI.FMB - Receipts

Symptoms

An invoice with multiple lines is created using transaction source with "generate line level balances" selected and transaction type with "allow overapplication" checked. Then a receipt is applied at the invoice level, leaving a balance due. Following the receipt application, one of the lines is adjusted (line adjustment) driving its balance to negative. Only the adjusted line has a negative balance; invoice still has a balance due. At this point, applying a receipt a receipt is not possible. When hitting "Save" button, application is not saved and no error message is produced.

Steps To Reproduce:
------------------
1. Create invoice with multiple lines using transaction source with "generate line level balances" selected and transaction type with "allow overapplication" checked.
2. Apply a receipt at the invoice level, leaving a balance due.
3. Perform a line level adjusment that will drive line to a negative balance.
4. Attempt to apply a receipt to invoice.
5. Hit "Save" button
6. Receipt application is not saved and no error message is produced.

Also ,when attempting to load receipt applications using Ar_receipt_api_pub.Apply api, The error
occurs for few cases (about 500 on 400.000 records). If the records are inserted into the application manually, when clicking on the Save button, the system doesn't save and doesn't provide any message and the following error occurs:

ERROR
Ar_receipt_api_pub.apply Error:

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