Receipt Workbench Error: A Cash Application Is Being Made Against A Transaction With Zero Line Amount Basis (Doc ID 1608690.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

When attempting to apply a cash receipt against a negative balanced invoice
the following error occurs.

ERROR
-----------------------
A cash application is being made against a transaction with zero line amount basis


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Responsibility : Receivables Manager
Navigation : Receipts > Receipts

Example:
Created an invoice with Line: 100 and charges: 6
Applied a receipt worth amount 106 against it.
Now created two adjustments against the invoice and each with amount -6.
Line level balances of the invoice was correctly stamped for
CHRG_AMOUNT_REMAINING.
Applied another receipt against total -12 USD of the invoice.
Line level balances showing CHRG_AMOUNT_REMAINING as zero.
Now, unapplied the second receipt.
Found that CHRG_AMOUNT_REMAINING in ra_customer_trx_lines is still zero.
It should have been updated to -12.

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