Transactions Workbench: Due Date Changes After Requerying an Invoice (Doc ID 2075791.1)

Last updated on DECEMBER 21, 2022

Applies to:

Symptoms

You are using a payment term with the following:

Day of the month=10
Months ahead=1

after creating a transaction with this payment term, and with the transaction date after 10 of the month , the due date is showing the correct one first, but when user queries the transaction again, the due date is changed

The following can be seen in the diagnostic for the transaction:

In RA_CUSTOMER_TRX_ALL TERM_DUE_DATE is correct (i.e 10-Jun-2015)

In AR_PAYMENT_SCHEDULES_ALL DUE_DATE is incorrect (i.e. 10-Jul-2015)

Steps to Reproduce:

Responsibility: Receivables responsibility
Navigation: Transactions > Transactions

1. Enter Invoice manually, save, and complete it. See the due date is correct
2. Query the invoice, and the due date is changed.

Due to this issue, the due date of the invoices is incorrect

Cause

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