My Oracle Support Banner

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

Last updated on DECEMBER 21, 2022

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


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
: 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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