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

Last updated on MARCH 07, 2017

Applies to:

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

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

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