Search Results gl_sob_names_v




Overview
Explore in AI Chat

Overview

GL_SOB_NAMES_V is a General Ledger view owned by the APPS schema and registered as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM documentation describes its purpose tersely as "10SC ONLY" and classifies it under the GL - General Ledger product. In practice, the view exists to expose a compact, denormalized projection of the sets of books definition so that concurrent programs, reports, and integration routines can resolve a set of books identifier to its human-readable name, short name, and governing accounting attributes without joining the full GL_SETS_OF_BOOKS definition.

Because it selects directly from GL_SETS_OF_BOOKS, the view inherits the accounting configuration of every ledger (set of books) defined in the instance. It is particularly relevant to searches involving enable_average_balances_flag, since that column is one of the eight attributes the view surfaces. Consumers can therefore determine, for any given set of books, whether average balance tracking is enabled — a prerequisite for average balance inquiries, certain GL reports, and any downstream calculation that depends on average daily balances rather than period-end balances.

Underlying Base Objects

ETRM documents a single referenced base object: GL_SETS_OF_BOOKS, itself listed as a view in the 12.2.2 metadata. The relationship is a straightforward one-to-one projection. Each row in GL_SOB_NAMES_V corresponds to exactly one row in GL_SETS_OF_BOOKS, keyed by SET_OF_BOOKS_ID. No filtering predicate appears in the documented view text; the SELECT statement simply enumerates the eight columns and returns all rows from the base object.

Consequently, the view adds no incremental security, no row-level restriction, and no transformation logic beyond column selection. Any valid set of books in the instance is visible through it, subject only to the privileges granted on the underlying object. In 12.2.x environments where the accounting structure model has been replaced by ledgers, GL_SETS_OF_BOOKS remains the compatibility view that GL_SOB_NAMES_V reads from, so existing code referencing GL_SOB_NAMES_V continues to function.

Key Columns

  • NAME — The full descriptive name of the set of books.
  • SHORT_NAME — The abbreviated identifier commonly displayed in list of values and reports.
  • SET_OF_BOOKS_ID — The primary key linking the view to GL_SETS_OF_BOOKS and to any ledger-based foreign keys.
  • CHART_OF_ACCOUNTS_ID — Identifies the chart of accounts structure assigned to the set of books.
  • PERIOD_SET_NAME — The accounting calendar (period type) governing the set of books, typically the standard monthly calendar.
  • CURRENCY_CODE — The functional or reporting currency of the set of books.
  • ENABLE_AVERAGE_BALANCES_FLAG — Indicates whether average balance processing is active for the set of books. This is the column of interest behind the "enable_average_balances_flag" query.
  • CONSOLIDATION_SOB_FLAG — Indicates whether the set of books is designated as a consolidation set of books.

Common Use Cases and Queries

The most frequent use is resolving a set of books name or determining configuration attributes for reporting parameters. A typical query to check average balance enablement is:

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

These patterns are common in GL report parameter forms, custom concurrent programs, and migration scripts that must enumerate ledgers and confirm whether average balances are maintained before invoking balance inquiry logic.