My Oracle Support Banner

AP/AR Netting Error: When Netting Batch Includes an Invoice with Multiple Payment Schedules, it Fails with Error: Error in Settling AR Transactions (Doc ID 980936.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.


AP/AR Netting batch ends in the following error:

Error in Settling AR Transactions.

The FND debug log shows the following:

Default_disc_and_amt_applied: The p_amount_applied is NULL
Default_disc_and_amt_applied: EXCEPTION: Default_discount_and_amount_applied()
Apply: 100
Apply: ORA-01403: no data found
apply cash receipt package after AR_RECEIPT_API_PUB.Apply:
apply cash receipt package Error message AR_RECEIPT_API_PUB.ApplyThe installment number is null. 1
apply cash receipt package Error message AR_RECEIPT_API_PUB.ApplyInvalid customer transaction identifier. 2
apply cash receipt package Error message AR_RECEIPT_API_PUB.ApplyAPPLY : ORA-01403: no data found 3
apply cash receipt package Error message AR_RECEIPT_API_PUB.ApplyORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply 4
Error in Settling AR Transactions

The issue happens when an invoice within the batch has more than 2 installments. When the netting batch is processed to apply the first installment, the process completes without any errors. When trying to write off the second installment, the process ends in error.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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