My Oracle Support Banner

Troubleshooting Grouping Rules In AutoInvoice (Doc ID 1084554.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Oracle Receivables - Version and later
Information in this document applies to any platform.
Executable:RAXTRX - AutoInvoice Import Program


Oracle Receivables (AR): AutoInvoice Information Center > Generic Setup and Troubleshooting Resources > Note 1084554.1

This note was created to facilitate troubleshooting AutoInvoice Grouping Rule Issues. For general AutoInvoice Troubleshooting, please review Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 12.

Grouping rules tell AutoInvoice how you want to group records in the interface tables into invoices, debit memos, and credit memos. Grouping rules specify which attributes must be identical for lines to appear on the same transaction.

There are Mandatory and Optional Grouping Attributes, predefined within the application.  These are the attributes that are used to determine how lines are grouped for a transaction.
You can run the Ordering and Grouping Rules Listing to see a complete list of all MANDATORY grouping attributes.

You can also review Note 1067993.1, How To Use Grouping Rules With AutoInvoice.


Download the latest EBS Oracle Receivables Grouping Rules Analyzer in DocID: 2073657.1
The EBS Oracle Receivables Grouping Rules Analyzer is a self-service health-check script that reviews the current configurations and settings for your grouping rules set-up and provides solutions for known issues, feedback and recommendations to address errors you are encountering.

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
 Troubleshooting Grouping Rule Issues When Using AutoInvoice
 1. One Credit Memo Is Created When Expecting Several
 2. Multiple Invoice Transactions Created When Expecting One
     a. Consider the Mandatory and Optional Grouping Attributes
     b. Consider the frequency in which AutoInvoice is executed
 3. Order Management - Line Transaction Flexfield
 4. Mandatory And Optional Grouping Attribute Columns
    a. Release 12.x, Mandatory Grouping Attributes
    b. Release 12.x, Optional Grouping Attributes
    c. Release 11.5, Mandatory Grouping Attributes
    d. Release 11.5, Optional Grouping Attributes
    e. Scripts to identify grouping attributes
 5. Intercompany Limitations
 6. What Happens if One Line is Rejected?
 7. How Commitment Lines are Grouped
 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.