My Oracle Support Banner

Autoinvoice Errors With 'Unable To Derive A GL Date For Your Transaction' For Service Contracts Credit Memos (Doc ID 1582504.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

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


Autoinvoice gives the error message below when trying to process service contract credit memos.  This happens when terminating a service contract which is already invoiced and the invoice falls in an accounting period that is already closed.


Unable to derive a gl date for your transaction.  Please ensure that your transaction is in a gl period which you have defined.

Steps to reproduce:

1. Create a Service Contract
Start date - 01-Jul-2013
End date - 30-Jun-2014

Single service/subscription line with same dates and 'Advance invoice'.

2. Activate and bill the contract.
Invoice is created for 3 months Jul, Aug and Sep 2013

GL date for these invoices is 01-Jul-2013

The July GL period is open.

3. Run Autoinvoice so that the invoices are created.
4. Close July period in AR and GL.
5. Terminate the contract, run service contracts main billing.
  - the credit memo records are created in RA interface tables
6. Submit Autoinvoice
- the records are in error with the above error message.


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.