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

Last updated on MAY 20, 2024

Applies to:

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

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