Search Results formula_line_number




Overview
Explore in AI Chat

Overview

The GL_ALLOC_FORMULA_LINES table is a core data object within the Oracle E-Business Suite (EBS) General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the detailed repository for the individual lines that constitute a MassAllocation or MassBudget formula. While the header definition of a formula is stored in GL_ALLOC_FORMULAS, this table stores the specific calculation rules, source accounts, and target accounts for each step or line within the formula. Its primary role is to provide the executable logic that the General Ledger engine uses to periodically allocate balances or budget amounts across different accounting segments, enabling automated and consistent financial distribution.

Key Information Stored

The table's structure is defined by a composite primary key consisting of ALLOCATION_FORMULA_ID and LINE_NUMBER, linking each line definitively to its parent formula. Key columns define the formula's operational logic. These include columns to identify the SOURCE (the account providing the balance), the TARGET (the account receiving the allocated amount), and the OFFSET (the balancing account). The PERCENT and AMOUNT columns specify the calculation basis for the allocation. The table also holds critical currency control columns (CURRENCY_CODE, TRANSACTION_CURRENCY, ENTERED_CURRENCY, LEDGER_CURRENCY) to manage multi-currency allocations. For budget-related formulas, the BUDGET_VERSION_ID links to GL_BUDGET_VERSIONS, and ENCUMBRANCE_TYPE_ID links to GL_ENCUMBRANCE_TYPES for encumbrance processing.

Common Use Cases and Queries

This table is central to troubleshooting, auditing, and reporting on allocation formulas. A common scenario involves analyzing all lines for a specific formula to verify calculation logic. A typical query joins to the formula header table:

  • SELECT gfl.line_number, gfl.source, gfl.target, gfl.percent, gf.name FROM gl_alloc_formula_lines gfl, gl_alloc_formulas gf WHERE gfl.allocation_formula_id = gf.allocation_formula_id AND gf.name = '&FORMULA_NAME' ORDER BY gfl.line_number;

Another critical use case is identifying formulas that use a specific general ledger account code combination as a source or target, which is essential for impact analysis during account changes. Data from this table is also used to generate custom reports detailing allocation rules outside the standard EBS forms, often joined with GL_CODE_COMBINATIONS to translate IDs into readable account segments.

Related Objects

GL_ALLOC_FORMULA_LINES has extensive relationships within the GL schema. Its primary parent is GL_ALLOC_FORMULAS, linked via ALLOCATION_FORMULA_ID. It references FND_CURRENCIES multiple times for currency columns. For budget allocations, it depends on GL_BUDGET_VERSIONS and GL_ENCUMBRANCE_TYPES. Crucially, the table is a parent to three key interim processing tables: GL_ALLOC_INTERIM_1, GL_ALLOC_INTERIM_2, and GL_ALLOC_INTERIM_3, linked via the composite key (ALLOCATION_FORMULA_ID, LINE_NUMBER). These interim tables hold runtime data during the execution of an allocation or budget formula, demonstrating this table's direct role in the allocation engine's processing workflow.