Due Date Issue in Past With Transactions Interfaced From Service Contracts
Last updated on MARCH 08, 2017
Applies to:Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Sep-2014***
On 12.1.3 version, find that there are Due Date issues with Transactions interfaced from Service Contracts.
Transaction Due Date is incorrectly calculated on a few of the Transactions interfaced from Service Contracts.
One of the Transaction details are as below:
The contract HAS been modified in some way on the 21st of March followed by an Invoicing and a Credit.
The Billing is in ADVANCE according to the Header
1. A Screenshot of contract_transations in Receivables (Transactions form) displays:
The trouble Invoice 2120066174 : Transaction date: 21-March 2013 ( Contract modification date contract invoiced for CFA19,735.00 for the whole duration of the contract)
But the Due date is: 26 nov 2012 (Customer issue i.e earlier than transaction date and seemingly equal to contract Start Date + 25 days )
The invoice date on the Transaction form is 21-Mar 2013
2. For the same Contract and with the same Payment terms, the Due Date on an other transaction 2120046339 (Original invoice) is calculated correctly as 25 days from transaction date
Transaction Date: 09 Jan 2013 (invoice date)
Due date: 03rd Feb 2013.
Apparently : 09 Jan 2013 plus 25 days. (No Issues Here)
For case 1 Customer expected for the invoice: 21-Mar 2013 plus 25 days.
BUT the applications did instead 01 nov 2012 plus 25 days i.e. 26 Nov 2012
Expected Due Date to be transaction date plus payment terms.
Workaround: It is possible to data fix the Due Date, but there is a need for a solution so that the issue no longer occurs in future.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a contract interface it to AR.
2. Run OKS main Billing
3. Run AutoInvoice
4. Check AR Transaction for the Contract see the date discrepancy.
Due Date shown on the AR Transactions is Back Dated from the Transaction Date
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