Receipt Application API is Failing When Applied to an Invoice Without Tax and With Discount Term (Doc ID 2434329.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

1) Create an application rule set with Over application tax treatment = Before
2) Associate the application rule set to transaction type

3) Create an invoice with one line and no tax
amount =482.94
Payment term = 2% 10 NET 45
Use the transaction type with application rule set created in step 1 and 2

4) Create a receipt for same customer for 473.29

5) Run the API ar_receipt_api_pub.apply() to apply the receipt to invoice within the discount period to apply 473.29

API is failing with below error

Gross transaction amount do not reconcile
A cash application is being made against a transaction with zero line amount basis, please contact Oracle Support.
OTHERS IN Trx_level_direct_cash_apply :ORA-20001: A cash application is being made against a transaction with zero line amount basis, please contact Oracle Support.
EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:ORA-20001: A cash application is being made against a transaction with zero line amount basis, please contact Oracle Support.
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
EXCEPTION: ARP_RECEIPTS_MAIN.Execute
EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
A cash application is being made against a transaction with zero line amount basis, please contact Oracle Support.
EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: arp_process_application.receipt_application

Cause

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