Search Results gl_alloc_formula_lines




Overview
Explore in AI Chat

Overview

GL_ALLOC_FORMULA_LINES is a General Ledger (GL) table that stores the individual formula lines that make up MassAllocations and MassBudget definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents one line of an allocation formula, capturing the source or target account segments, the calculation operator, the amount basis, and the currency context used when the allocation is executed. It is the transactional detail behind GL_ALLOC_FORMULAS, which holds the formula header.

From a dimensional modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. This is a heuristic suggestion rather than a documented fact: the table behaves like a descriptive satellite attached to the parent formula hub/link (GL_ALLOC_FORMULAS), carrying the mutable attributes—amounts, segment values, currency codes, and period references—that describe each formula line over time.

Key Information Stored

The primary key is the composite GL_ALLOC_FORMULA_LINES_PK, defined on (ALLOCATION_FORMULA_ID, LINE_NUMBER). The same pair forms the unique index GL_ALLOC_FORMULA_LINES_U1, which serves as the business-key candidate and establishes line ordering within a formula. The most significant columns include:

Common Use Cases and Queries

A frequent requirement is to retrieve all formula lines for a given allocation and reformat them for review. For example:

  • Joining to GL_ALLOC_FORMULAS on ALLOCATION_FORMULA_ID to display formula name, line number, operator, and amount in a MassAllocation listing report.
  • Resolving currency descriptions by joining CURRENCY_CODE, TRANSACTION_CURRENCY, ENTERED_CURRENCY, or LEDGER_CURRENCY to FND_CURRENCIES on CURRENCY_CODE to display currency names and precision.
  • Auditing formula composition by filtering on ACTUAL_FLAG, BUDGET_VERSION_ID, or ENCUMBRANCE_TYPE_ID to separate actual, budget, and encumbrance allocations.
  • Reconstructing allocation execution output by joining to GL_ALLOC_INTERIM_1, GL_ALLOC_INTERIM_2, and GL_ALLOC_INTERIM_3 on FORMULA_ID and FORMULA_LINE_NUMBER to trace generated journal lines back to their source formula line.
  • Reporting the segment values (SEGMENT1–SEGMENT30) used per line for compliance and account-mapping analysis.

Related Objects

The following objects are the most significant dependencies for this table:

  • GL_ALLOC_FORMULAS — parent header table; joined on ALLOCATION_FORMULA_ID.
  • FND_CURRENCIES — referenced by CURRENCY_CODE, TRANSACTION_CURRENCY, ENTERED_CURRENCY, and LEDGER_CURRENCY.
  • GL_ENCUMBRANCE_TYPES — referenced by ENCUMBRANCE_TYPE_ID.
  • GL_BUDGET_VERSIONS — referenced by BUDGET_VERSION_ID.
  • GL_ALLOC_INTERIM_1, GL_ALLOC_INTERIM_2, and GL_ALLOC_INTERIM_3 — child/interim tables referencing this table on FORMULA_ID and FORMULA_LINE_NUMBER.

Note that the metadata lists TRANSACTION_CURRENCY_11I and TRANSACTION_CURRENCY as separate columns, reflecting the transition between 11i and 12.x currency handling. Implementers validating or migrating allocation definitions should confirm which column is authoritative in the target release.