AP/AR Netting Error: Netting Batch Completes In Error when Adding Trading Partner In Inactive Relationship (Doc ID 1315186.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When adding a trading partner in an inactive relationship when creating netting agreement, the Settling of the Netting Batch completes in error:

Debug log shows:

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


There is no issue when netting related customers. 

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