My Oracle Support Banner

Due Date Issue in Past With Transactions Interfaced From Service Contracts (Doc ID 1547845.1)

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

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.

Business Impact:
Due Date shown on the AR Transactions is Back Dated from the Transaction Date


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.