Search Results gl_auto_alloc_sets




Overview
Explore in AI Chat

Overview

The GL_AUTO_ALLOC_SETS table is a core data object within the Oracle E-Business Suite General Ledger (GL) module. It serves as the master definition table for autoallocation sets, which are configurations used to automate complex financial allocations. These allocations, which can be structured as step-down (sequential) or parallel, are essential for distributing costs, revenues, or statistical amounts across different departments, cost centers, or other segments of the chart of accounts. The table defines the fundamental properties of an allocation set, linking it to a specific ledger (Set of Books) and providing the framework for the detailed allocation rules and batches that execute the calculations.

Key Information Stored

The table's primary purpose is to store the header-level attributes for an allocation set. The central column is the ALLOCATION_SET_ID, which is the unique system-generated identifier and the table's primary key. This ID is referenced throughout the allocation subsystem. Another critical column is SET_OF_BOOKS_ID, a foreign key linking the allocation set to a specific ledger in the GL_SETS_OF_BOOKS table, ensuring allocations are performed within the correct accounting context. While the provided metadata does not list all columns, typical attributes stored in this or related tables include the allocation set name, description, status (e.g., Active, Inactive), type (step-down or parallel), and effective date ranges. This table acts as the parent record for the detailed steps and rules defined in child tables.

Common Use Cases and Queries

This table is central to administering and reporting on autoallocation configurations. Common operational use cases include identifying all allocation sets defined for a specific ledger, auditing set definitions, and troubleshooting allocation batch errors by tracing them back to their source definition. A typical reporting query would join GL_AUTO_ALLOC_SETS with GL_SETS_OF_BOOKS to list allocation sets by ledger name. For technical support, one might query the relationship between a failing batch and its set definition.

  • Sample Query: SELECT gas.allocation_set_id, gas.name, sob.name ledger_name FROM gl_auto_alloc_sets gas, gl_sets_of_books sob WHERE gas.set_of_books_id = sob.set_of_books_id AND sob.name = 'US Ledger';
  • Administration: Identifying inactive or obsolete allocation sets for cleanup.
  • Integration: Serving as a reference point for custom programs or data extracts that need to understand the allocation framework.

Related Objects

As indicated by the foreign key relationships, GL_AUTO_ALLOC_SETS is a pivotal parent table within the autoallocation architecture. Its primary key is referenced by several key child objects. The GL_AUTO_ALLOC_BATCHES table stores individual execution instances of an allocation set, linking each batch run to its parent definition via the ALLOCATION_SET_ID. The GL_AUTO_ALLOC_SET_HISTORY table tracks changes to the allocation set over time. Furthermore, the table has a mandatory dependency on the GL_SETS_OF_BOOKS (ledgers) table to enforce ledger validity. In practice, allocation sets are comprised of multiple steps and rules; therefore, this table also has logical relationships (often via the allocation set ID) with other core allocation tables such as GL_AUTO_ALLOC_STEPS and GL_AUTO_ALLOC_RULES, which store the procedural and calculation details.