Search Results ra_group_bys




Overview
Explore in AI Chat

Overview

The RA_GROUP_BYS table is a configuration table within the Oracle E-Business Suite Receivables (AR) module, specifically for releases 12.1.1 and 12.2.2. It is a core component of the transaction grouping functionality, which is used to consolidate multiple transaction lines into summarized entries for reporting and accounting purposes. The table's primary role is to define the specific database columns by which transactions are aggregated for each unique grouping rule and transaction type combination. This setup enables flexible, rule-based summarization of receivables data, which is critical for generating concise financial reports and streamlining the accounting process.

Key Information Stored

The table stores the mapping between grouping rules and the columns used for aggregation. Its structure is defined by a composite primary key. The critical columns are GROUPING_TRX_TYPE_ID, which identifies a specific grouping rule for a transaction type, and COLUMN_ID, which references a specific column from the RA_GROUP_BY_COLUMNS table that should be used as a grouping criterion. For example, a rule might specify grouping by CUSTOMER_ID, GL_DATE, and CURRENCY_CODE. Each of these criteria would be represented as a separate record in RA_GROUP_BYS for the given GROUPING_TRX_TYPE_ID. The table itself is lean, primarily serving as a junction table to enforce these many-to-many relationships between rules and grouping columns.

Common Use Cases and Queries

The primary use case is the configuration and analysis of transaction grouping rules within the Receivables module. Administrators use this data to understand how automatic transaction summarization is defined. A common analytical query involves joining to related tables to list all grouping criteria for a specific transaction type or rule.

Sample Query: To retrieve all grouping columns for a specific grouping rule, one might execute: 

SELECT gbt.name grouping_rule_name, gbc.column_name
  FROM ra_group_bys gb,
       ra_group_by_columns gbc,
       ra_grouping_trx_types gtt,
       ra_grouping_rule_headers gbt
 WHERE gb.column_id = gbc.column_id
   AND gb.grouping_trx_type_id = gtt.grouping_trx_type_id
   AND gtt.grouping_rule_id = gbt.grouping_rule_id
   AND gbt.grouping_rule_id = :p_rule_id;
This information is vital for troubleshooting why transactions are or are not being grouped as expected and for auditing the setup of summarization rules.

Related Objects

The RA_GROUP_BYS table sits at the intersection of two key configuration entities, as defined by its foreign key relationships:

  • RA_GROUP_BY_COLUMNS: This table defines the universe of available columns that can be used for grouping (e.g., CUSTOMER_ID, INVOICE_CURRENCY_CODE). RA_GROUP_BYS.COLUMN_ID is a foreign key to RA_GROUP_BY_COLUMNS.COLUMN_ID.
  • RA_GROUPING_TRX_TYPES: This table associates a transaction type (like Invoice or Credit Memo) with a specific grouping rule. RA_GROUP_BYS.GROUPING_TRX_TYPE_ID is a foreign key to RA_GROUPING_TRX_TYPES.GROUPING_TRX_TYPE_ID.

These relationships mean that a complete grouping rule definition involves navigating from a rule header (RA_GROUPING_RULE_HEADERS) to transaction types (RA_GROUPING_TRX_TYPES) and finally to the specific grouping columns (RA_GROUP_BYS -> RA_GROUP_BY_COLUMNS).