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 NOVEMBER 13, 2018
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!