Search Results gl_auto_alloc_sets_u1

Overview

GL.GL_AUTO_ALLOC_SETS is a General Ledger table that stores information about AutoAllocation sets. Each row represents a single allocation set definition, including its unique identifier, name, type, owner, and description. AutoAllocation sets are the logical containers that group the allocation rules used to distribute balances across accounting flexfield combinations during the General Ledger allocation process.

The table carries a heuristic Data Vault classification of hub-leaning. In dimensional modeling terms, GL_AUTO_ALLOC_SETS behaves primarily as a hub: it holds the durable business key of an allocation set (ALLOCATION_SET_NAME, qualified by a unique surrogate identifier) and is referenced by downstream transactional and historical tables. Modeling it as a hub, with dependent attributes such as description and owner treated as satellite content, is a reasonable design suggestion for downstream analytics.

The table is owned by the GL schema and mapped to the FND Design Data object SQLGL.GL_AUTO_ALLOC_SETS. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. In Release 12, the SET_OF_BOOKS_ID_11I column is retained for historical compatibility but is no longer used.

Key Information Stored

• ALLOCATION_SET_ID — The allocation set defining column and surrogate primary key (GL_AUTO_ALLOC_SETS_PK1). It is also the column behind the unique index GL_AUTO_ALLOC_SETS_U1.
• ALLOCATION_SET_NAME — The business-facing name of the set (maximum 40 characters). A nonunique index, GL_AUTO_ALLOC_SETS_N1, supports lookups by name.
• ALLOCATION_SET_TYPE_CODE — Distinguishes set behavior: 'S' for a step-down allocation set and 'P' for a parallel allocation set.
• ALLOCATION_CODE — Identifies the responsibility that created the record: 'GL' for General Ledger or 'PA' for Projects.
• OWNER — The default contact for the allocation set who receives notifications when an error occurs during a step-down allocation run. It is null for parallel sets and populated for step-down sets.
• ORG_ID — Organization identifier for multi-org installations, used only for Projects autoallocation sets.
• DESCRIPTION — Free-text description of the allocation set (maximum 240 characters).
• CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE — Accounting configuration context associated with the set.
• SECURITY_FLAG — Indicator governing the security treatment of the set.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments supporting user-defined extensions.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY provide audit tracking.

Common Use Cases and Queries

A frequent requirement is listing all allocation sets along with their type and originating responsibility, for example:

• SELECT allocation_set_id, allocation_set_name, allocation_set_type_code, allocation_code FROM gl_auto_alloc_sets ORDER BY allocation_set_name;
• Identifying step-down sets that have an owner assigned: SELECT allocation_set_name, owner FROM gl_auto_alloc_sets WHERE allocation_set_type_code = 'S' AND owner IS NOT NULL;
• Isolating Projects-created sets in a multi-org environment: SELECT allocation_set_name, org_id FROM gl_auto_alloc_sets WHERE allocation_code = 'PA' AND org_id IS NOT NULL;

Reporting scenarios typically join this table to its dependent detail tables to summarize which rules or batches belong to a given set, or to reconcile the number of allocation runs executed per set over a period. Because the unique index GL_AUTO_ALLOC_SETS_U1 covers ALLOCATION_SET_ID, joins driven by that key resolve with a unique access path, while name-based filters benefit from the nonunique index GL_AUTO_ALLOC_SETS_N1.

Related Objects

• GL.GL_AUTO_ALLOC_BATCHES — References GL_AUTO_ALLOC_SETS via ALLOCATION_SET_ID, capturing batch-level execution groupings for a set.
• GL.GL_AUTO_ALLOC_SET_HISTORY — References GL_AUTO_ALLOC_SETS via ALLOCATION_SET_ID, retaining historical state for allocation sets.
• GL.GL_SETS_OF_BOOKS — Referenced through SET_OF_BOOKS_ID, providing the ledger context for the set.
• GL.GL_MGT_SEG_UPGRADE_H — Referenced through CHART_OF_ACCOUNTS_ID, linking the set to chart of accounts upgrade history.

Together these relationships position GL_AUTO_ALLOC_SETS as the central reference point for allocation configuration and its execution history within the General Ledger schema.