Search Results account_segment_value




Overview
Explore in AI Chat

Overview

GL_STAT_ACCOUNT_UOM_V is a General Ledger (GL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata designates it with the description "10SC ONLY," indicating that the object is restricted to specific statutory or localization contexts (the "10SC" designation) rather than being exposed as a general-purpose GL dictionary object. It presents statistical account assignments to units of measure, exposing a simplified projection that maps a chart of accounts and an account segment value to a unit of measure alongside its descriptive text.

The view functions primarily as a read-only reporting and integration surface. It lets external processes, custom reports, and interfaces retrieve the association between statistical account segment values and the units of measure they carry, without querying the underlying base table directly. Because it is a simple projection view containing no joins, aggregation, or filtering logic, it inherits the row-level content of its base object and does not impose additional predicates of its own.

Underlying Base Objects

According to the documented metadata, GL_STAT_ACCOUNT_UOM_V is defined over a single referenced base object: the synonym GL_STAT_ACCOUNT_UOM, which resolves to the underlying GL statistical account/unit-of-measure table in the APPS schema. The view text selects all columns from this base object and aliases them to expose the same logical attributes under consistent public names.

Because the view is a straightforward SELECT from one base object with column aliasing, it maintains a one-to-one correspondence with the base rows. A ROWID from the base record is surfaced as ROW_ID to provide a stable identifier for the underlying row. Core columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are passed through unchanged, preserving standard EBS who-column audit semantics. The view performs no filtering on these columns; any where-clause behavior is entirely at the discretion of the calling query.

Key Columns

  • ROW_ID — the base row's ROWID, useful for uniquely identifying a base record when joining or updating.
  • CHART_OF_ACCOUNTS_ID — identifies the chart of accounts to which the statistical account assignment belongs.
  • ACCOUNT_SEGMENT_VALUE — the statistical account segment value associated with the unit of measure.
  • UNIT_OF_MEASURE — the unit of measure code or name assigned to the statistical account; this is the column most relevant to searches for "unit_of_measure."
  • DESCRIPTION — descriptive text for the unit of measure or the assignment.
  • CREATED_BY / CREATION_DATE — standard audit columns recording the creating user and timestamp.
  • LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification user, timestamp, and login session.

Common Use Cases and Queries

Typical uses include validation of statistical account unit-of-measure assignments, reconciliation of reporting against units of measure, and lookups in conversion or interface programs that need to translate an account segment value to its unit of measure. The following query retrieves all unit-of-measure assignments for a chart of accounts:

  • SELECT ROW_ID, CHART_OF_ACCOUNTS_ID, ACCOUNT_SEGMENT_VALUE, UNIT_OF_MEASURE, DESCRIPTION FROM APPS.GL_STAT_ACCOUNT_UOM_V WHERE CHART_OF_ACCOUNTS_ID = :p_coa_id;
  • SELECT ACCOUNT_SEGMENT_VALUE, UNIT_OF_MEASURE FROM APPS.GL_STAT_ACCOUNT_UOM_V WHERE UNIT_OF_MEASURE = :p_uom;

Because the object carries the "10SC ONLY" restriction, implementers should confirm that the localization or patch level relevant to their deployment populates and supports it before relying on the view in a production inquiry or interface.