Search Results allocation_formula_id




Overview
Explore in AI Chat

Overview

GL_ALLOC_FORMULAS is a General Ledger table in the Oracle E-Business Suite that stores the definition of individual allocation formulas used by the MassAllocations and MassBudget features. Each row represents a named formula belonging to an allocation batch, capturing the run order, journal category, conversion behavior, and validation state that govern how the allocation engine distributes balances from source accounts to target accounts. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the GL schema and forms the operational backbone of recurring allocation processing.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification. GL_ALLOC_FORMULAS carries its own surrogate identity (ALLOCATION_FORMULA_ID) and a business key, while also referencing GL_ALLOC_BATCHES, giving it the characteristics of a central entity that dependent detail tables attach to rather than a pure link or satellite.

Key Information Stored

The table defines 15 documented columns. The most significant include:

Common Use Cases and Queries

Typical scenarios include auditing allocation setup, verifying validation status before running a batch, and reporting on formula sequencing. A representative query lists formulas for a given batch:

  • SELECT f.allocation_formula_id, f.name, f.run_sequence, f.validation_status FROM gl_alloc_formulas f WHERE f.allocation_batch_id = :batch_id ORDER BY f.run_sequence;
  • Detecting unvalidated formulas: SELECT name, validation_status FROM gl_alloc_formulas WHERE validation_status <> 'V';
  • Reviewing conversion settings: SELECT name, conversion_method_code, currency_conversion_type FROM gl_alloc_formulas;

These patterns support setup migration, post-clone reconciliation, and reconciliation of allocation runs against expected definitions.

Related Objects

The foreign-key metadata identifies the principal dependencies:

  • GL_ALLOC_BATCHES — parent table joined on ALLOCATION_BATCH_ID.
  • GL_ALLOC_FORMULA_LINES — child table joined on ALLOCATION_FORMULA_ID, storing the source/target line definitions.
  • GL_ALLOC_TARGETS — child table joined on ALLOCATION_FORMULA_ID, storing allocation target definitions and percentages.
  • The MassAllocation and MassBudget concurrent programs, which read these rows to generate allocation journals.
  • The GL Allocation setup forms, which create and maintain formula records.