Search Results formula_line_number

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:

ALLOCATION_FORMULA_ID — foreign key to GL_ALLOC_FORMULAS; identifies the parent allocation formula.
LINE_NUMBER — sequence position of the line within the formula.
LINE_TYPE and OPERATOR — define how the line participates in the allocation calculation.
AMOUNT and AMOUNT_TYPE — the allocation amount and the basis on which it is computed.
PERIOD_NAME and RELATIVE_PERIOD — the accounting period and relative offset used by the formula.
ACTUAL_FLAG, BUDGET_VERSION_ID, and ENCUMBRANCE_TYPE_ID — determine whether the line targets actuals, a budget version, or an encumbrance type.
CURRENCY_CODE, CURRENCY_TYPE, TRANSACTION_CURRENCY, ENTERED_CURRENCY, and LEDGER_CURRENCY — define the currency dimensions of the allocation.
SEGMENT1 through SEGMENT30 — the account segment values assigned to the line.
SEGMENT_TYPES_KEY and SEGMENT_BREAK_KEY — supporting keys for segment structure and parsing.
LEDGER_ID and LEDGER_ACTION_CODE — identify the target ledger and the action applied.
Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) provide audit lineage.

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.

Table: GL_ALLOC_FORMULA_LINES 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ALLOC_FORMULA_LINES, object_name:GL_ALLOC_FORMULA_LINES, status:VALID, product: GL - General Ledger , description: MassAllocations and MassBudget formula lines , implementation_dba_data: GL.GL_ALLOC_FORMULA_LINES ,
Table: GL_ALLOC_FORMULA_LINES 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ALLOC_FORMULA_LINES, object_name:GL_ALLOC_FORMULA_LINES, status:VALID, product: GL - General Ledger , description: MassAllocations and MassBudget formula lines , implementation_dba_data: GL.GL_ALLOC_FORMULA_LINES ,
TABLE: GL.GL_ALLOC_INT_1 12.1.1
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_1, status:VALID,
Table: GL_ALLOC_INTERIM_3 12.2.2
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
Table: GL_ALLOC_INTERIM_3 12.1.1
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
Table: GL_ALLOC_INTERIM_2 12.2.2
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
TABLE: GL.GL_ALLOC_INT_3 12.2.2
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_3, status:VALID,
TABLE: GL.GL_ALLOC_INT_2 12.2.2
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_2, status:VALID,
Table: GL_ALLOC_INTERIM_1 12.2.2
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
Table: GL_ALLOC_INTERIM_1 12.1.1
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
Table: GL_ALLOC_INTERIM_2 12.1.1
product: GL - General Ledger , description: Temporary table for MassAllocations and MassBudgets , implementation_dba_data: Not implemented in this database ,
TABLE: GL.GL_ALLOC_INT_1 12.2.2
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_1, status:VALID,
TABLE: GL.GL_ALLOC_INT_3 12.1.1
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_3, status:VALID,
TABLE: GL.GL_ALLOC_INT_2 12.1.1
owner:GL, object_type:TABLE, object_name:GL_ALLOC_INT_2, status:VALID,
eTRM - SQLGL Tables and Views 12.2.2
description: This table contains the tracking information that Golden Gate will use to launch Journal Import. ,
eTRM - SQLGL Tables and Views 12.1.1
description: USSGL transaction codes ,
eTRM - SQLGL Tables and Views 12.2.2
description: This table contains the tracking information that Golden Gate will use to launch Journal Import. ,
eTRM - SQLGL Tables and Views 12.1.1
description: USSGL transaction codes ,