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 JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
*** Checked for relevance on 22-Oct-2013 ***


Symptoms

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.

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