Search Results consolidation_sob_flag




Overview
Explore in AI Chat

Overview

APPS.GL_SOB_NAMES_V is a reporting and integration view in the Oracle E-Business Suite General Ledger module, documented for release 12.2.2 and applicable to 12.1.1. It exposes a focused, denormalized projection of the set of books definition, presenting the ledger identity attributes most frequently required by downstream processes: name, short name, identifier, chart of accounts, accounting calendar, currency, average balance enabling, and the consolidation set of books indicator. The view's name reflects its original design intent — to provide a lightweight means of resolving set of books names and identities without querying the full GL_SETS_OF_BOOKS entity. This is significant for searches involving the term "consolidation_sob_flag," because CONSOLIDATION_SOB_FLAG is one of the eight columns the view explicitly exposes. That column identifies whether a given set of books is a consolidation set of books, a property that governs how balances are aggregated from subsidiary ledgers into a parent ledger. Because the view surfaces this flag alongside the set of books identifier and name, it allows consolidation-related logic to determine parent/target ledgers without navigating the entire GL_SETS_OF_BOOKS record. In practice the view functions as a stable, read-only presentation layer that decouples calling code from column churn in the underlying table while still delivering the consolidation attribute consumers need.

Underlying Base Objects

The view is defined over a single documented base object: GL_SETS_OF_BOOKS, itself a view in the APPS schema. The ETRM metadata lists GL_SETS_OF_BOOKS (VIEW) as the sole referenced object, confirming that GL_SOB_NAMES_V is a straightforward projection rather than a join across multiple entities. The view text is a simple unconditional SELECT of eight columns from that source, with no WHERE clause, DISTINCT, or aggregation. Consequently, it inherits the row cardinality and security characteristics of GL_SETS_OF_BOOKS — one row per defined set of books visible to the querying responsibility. No filtering by ledger, operating unit, or data access set is applied within the view itself; any such restriction must be imposed by the consuming query. Because it dereferences only a view rather than base tables directly, the public contract is limited to the columns named in the SELECT list.

Key Columns

  • SET_OF_BOOKS_ID — Primary identifier of the set of books; the join key used throughout GL and subledger tables.
  • NAME — The user-defined descriptive name of the set of books.
  • SHORT_NAME — The abbreviated name, commonly used in reports and concatenated display values.
  • CHART_OF_ACCOUNTS_ID — Identifier of the associated chart of accounts structure.
  • PERIOD_SET_NAME — The accounting calendar (period set) assigned to the ledger.
  • CURRENCY_CODE — The ledger's functional currency.
  • ENABLE_AVERAGE_BALANCES_FLAG — Indicates whether average balance tracking is enabled.
  • CONSOLIDATION_SOB_FLAG — Indicates whether the set of books serves as a consolidation set of books, the attribute central to the user's search term.

Common Use Cases and Queries

The view is typically used to populate list of values, resolve ledger names for reporting, and drive consolidation selection logic. A common query retrieves all consolidation ledgers:

  • SELECT set_of_books_id, name, short_name, currency_code FROM apps.gl_sob_names_v WHERE consolidation_sob_flag = 'Y';
  • SELECT name, short_name, period_set_name FROM apps.gl_sob_names_v WHERE set_of_books_id = :p_sob_id;
  • SELECT sob.set_of_books_id, sob.name, sob.chart_of_accounts_id FROM apps.gl_sob_names_v sob ORDER BY sob.name;

Note that CONSOLIDATION_SOB_FLAG is conventionally stored as 'Y'/'N'. The view carries no ordering or filtering, so consumers should add ORDER BY and any data access predicates themselves.