My Oracle Support Banner

AutoInvoice, Transaction Workbench or Invoice API Error: Please correct the revenue account assignment (Doc ID 1088251.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Project Billing - Version 11.5.10.1 and later
Oracle Order Management - Version 11.5.10.0 and later
Oracle Receivables - Version 11.5.10.0 and later
Oracle Lease and Finance Management - Version 12.0.1 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program
Form:ARXTWMAI.FMB - Transactions
Executable:PARGDR - PRC: Generate Draft Revenue for a Range of Projects
Executable:PAIGEN - PRC: Generate Draft Invoices for a Range of Projects


Symptoms

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

When Creating transactions via AutoInvoice, or the Transactions Form or APIs or via a hook-up into Receivables, you get the Error:

Please correct the revenue account assignment 

This can occur in:
Oracle Receivables Transaction Workbench
Oracle Receivables: AutoInvoice Import
Oracle Receivables: Invoice API's
Oracle Projects: Project Billing Generate Draft Invoices or Revenue

Cause

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
Symptoms
Cause
Solution
 1. Check AutoAccounting Setup
 a) If Segments Source = Salesreps
 b) If Segment Source =  Standard Lines
 c) If Segment Source = Transaction Types
 d) If Segment Source = Sites
 2. Validate the Shipping Inventory Organization
 3. If you are passing Data in RA_INTERFACE_DISTRIBUTIONS_ALL
 4. Check the profile option: AR: Use Invoice Accounting for Credit Memos
 5. Check if the GL account exists and is active
 6. Verify Accounting Flexfield setting for Enabled and Allow Dynamic Inserts
 7. Verify whether the GL account does not violate any cross-validation rules of the segments.
 8. Check for Possible Known Bugs
 9. Use the EBS Oracle Receivables AutoInvoice Analyzer
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.