FUNNTSTB Error "Settlement Date - Please enter a Settlement Date which is on or after today's date" (Doc ID 2823925.1)

Last updated on DECEMBER 02, 2021

Applies to:

Symptoms

When attempting to submit a Netting Batch,
the following error occurs.

Settlement Date - Please enter a Settlement Date which is on or after today's date.

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables
2. Path: Payables Manager -> Payments -> Entry -> Netting -> Netting -> Netting Batch
3. Create a Netting Batch
Details entered while creating Netting Agreement:

Netting Bank Account: AP Adjustment Bank
Select Only Past Due Receivables Transactions: Yes
Days Past Due: 0
...

Confirmation
Netting agreement xxx has been created.

Settlement date corrected.

Error
Settlement Date - Please enter a Settlement Date which is on or after today's date.

4. Select Status of the batch

Status: Selected

Select AR Invoice

Select AP Invoice

Update and submit the batch.

Netting Batch gone in error.

The invoice gets stuck.


5. FND Log

...
FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.Settle_Net_Batch AP invoices settled successfully
FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.Settle_Net_Batch Error in Settling AP Invoices
...

Cause

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