Search Results gl_row_multipliers




Overview
Explore in AI Chat

Overview

GL_ROW_MULTIPLIERS is a General Ledger (GL) reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 schemas. As stated in the ETRM documentation, its purpose is to store "constant row multipliers." In the context of Oracle General Ledger's Financial Statement Generator (FSG), row multipliers define fixed numeric factors that are applied to a row's calculated balance when building report output. These multipliers allow report designers to express derived values — for example, negating a value, doubling it, or applying a fractional factor — without altering the underlying account balances.

The table is small and static in nature, functioning as a lookup or validation list rather than a transactional store. The heuristic Data Vault classification mined from the foreign-key structure is "standalone," meaning the object has no outgoing or incoming foreign-key dependencies on other documented tables. Under a Data Vault modeling suggestion, this object is best treated as a reference or lookup construct — a hub-like set of valid multiplier values — rather than a link or satellite, since it captures a discrete domain of permitted factors with no relational history of its own.

Key Information Stored

The documented physical schema contains six columns. The most significant are:

  • MULTIPLIER — The business key and primary key column. It stores the numeric constant applied to a report row, and it is also the column captured by the unique index GL_ROW_MULTIPLIERS_U1, making it the authoritative business-key candidate as well as the surrogate primary key.
  • CREATED_BY — The user identifier responsible for creating the multiplier record.
  • CREATION_DATE — The timestamp when the row was inserted.
  • LAST_UPDATED_BY — The user identifier responsible for the most recent modification.
  • LAST_UPDATE_DATE — The timestamp of the most recent modification.
  • LAST_UPDATE_LOGIN — The login identifier associated with the most recent change, used for audit traceability.

The five audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) follow the standard Oracle EBS WHO-column convention and support multi-user change tracking. The business payload is effectively limited to the MULTIPLIER value itself; the table is a controlled enumeration of acceptable factors rather than a data-rich entity.

Common Use Cases and Queries

The primary use case is supporting FSG row definitions, where each row set line references a multiplier that scales the reported balance. Administrators query this table to review which multipliers are available before assigning one to a row, and developers query it to validate or join multiplier values into custom reporting extracts.

  • Validating a user-entered multiplier: SELECT MULTIPLIER FROM GL_ROW_MULTIPLIERS WHERE MULTIPLIER = :p_value;
  • Producing a lookup list for a value set or LOV: SELECT MULTIPLIER FROM GL_ROW_MULTIPLIERS ORDER BY MULTIPLIER;
  • Auditing recent maintenance: SELECT MULTIPLIER, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM GL_ROW_MULTIPLIERS ORDER BY LAST_UPDATE_DATE DESC;

Because the table has no foreign keys, joins in reporting are driven by matching the MULTIPLIER value against a stored factor in a consuming configuration table rather than by a referential constraint. This makes it suitable for lightweight lookups and validation lists embedded in concurrent programs or custom BI Publisher reports.

Related Objects

The FK metadata identifies GL_ROW_MULTIPLIERS as standalone, so no enforced parent-child relationships are documented. In practice, the table is referenced by FSG configuration objects that store a row's multiplier attribute, and it participates in the broader GL reporting object family. Relevant associated objects include:

  • GL_ROW_MULTIPLIERS_U1 — The unique index on MULTIPLIER, enforcing business-key uniqueness.
  • GL_ROW_MULTIPLIERS_PK — The primary-key constraint on MULTIPLIER.
  • FSG row and row set definitions — Where a referenced multiplier is applied to computed balances.
  • GL account and balance inquiry objects — Used together when reconciling scaled reporting output.
  • Standard EBS audit WHO-column consumers — Reporting layers that read CREATED_BY, LAST_UPDATED_BY and related audit fields.

Join columns, where used, are the MULTIPLIER value matched against the multiplier attribute held in the consuming FSG row configuration.