My Oracle Support Banner

Troubleshooting AutoInvoice Date Derivation: GL Date, Invoice Date, Due Date, Ship Date, Billing Date, Rule Date (Doc ID 201241.1)

Last updated on OCTOBER 17, 2023

Applies to:

Oracle Order Management - Version 11.5.1 and later
Oracle Receivables - Version 11.5.0 and later
Information in this document applies to any platform.


Oracle Receivables (AR): AutoInvoice Information Center >Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 201241.1

The purpose of this note is to provide a clear explanation of the logic used by AutoInvoice to derive the General Ledger Date and the Transaction Date while processing transactions. 

It is intended as a resource to assist you in identifying why a date is not what you expected.  It can also be used to influence setup during an implementation so that dates default as intended.

This note should be used in conjunction with the following two articles:
Note 1067402.1, AutoInvoice Setup for Release 12: A Case Study Using a Simple Script
Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12

Troubleshooting Steps

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
Troubleshooting Steps
 1. Date Derivation In AutoInvoince:  How It Works
 2. General Ledger Date
     a. Invoice Without Rules 
     b. Invoice With Rules
         i. Bill In Advance Invoicing Rules
         ii. Bill in Arrears Invoicing Rules
         iii. How Accounting Rule Start Dates Are Derived
     c. Credit Memos (RMAs)
     d. General Ledger Date Handling For Closed Periods
     e. GL Date Validation In AutoInvoice
 3. Transaction Date & Ship Date
     a. Invoice
     b. Credit Memo
 4. Billing Date (Balance Forward Billing)
 5. Due Date
 6. Receivables Transaction Source Setup Impacting Date Derivation
     a. Date Derivation In Transaction Batch Source Window
     b. Adjust GL Date In Closed Period Setup In Transaction Batch Source Window
 7. AutoInvoice Execution/Validation Report Date Errors And Steps To Resolve
 8. Known Bugs And Fixes For AutoInvoice Date Derivation Issues
 9. Brazil Transaction and GL Date Derivation
 10. 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.