Search Results dim_long_name




Overview
Explore in AI Chat

Overview

APPS.EDW_DIM_VIEW is a lightweight reporting view in the Oracle E-Business Suite enterprise data warehouse (EDW) layer. It exposes a two-column projection drawn from the EDW dimensions metadata, presenting each warehouse dimension as an identifier/value pair. The view is defined in the APPS schema and is intended for consumption by Oracle EBS reporting tools, Discoverer workbooks, and downstream integration extracts that require a flat, human-readable list of dimension definitions rather than the full dimensional metadata structure.

The view is particularly relevant to users searching on the column name dim_long_name, since that attribute is exposed by the view as the VALUE column. Users who query the EDW dimensions metadata directly will find DIM_LONG_NAME in the underlying source, while the view renames it to VALUE for generic list-of-values consumption patterns.

Underlying Base Objects

Per the documented ETRM metadata, APPS.EDW_DIM_VIEW is defined over a single referenced object:

  • EDW_DIMENSIONS_MD_V — the EDW dimensions metadata view that supplies both columns projected by EDW_DIM_VIEW.

No private tables, synonyms, or additional joins are documented as base objects for this view. The view text is a straightforward select-list projection:

SELECT dim_id id, dim_long_name value
FROM   EDW_DIMENSIONS_MD_V

Because EDW_DIM_VIEW introduces no filters, aggregations, or joins, it inherits the row population, security predicates, and any row-level restrictions present in EDW_DIMENSIONS_MD_V. Any change to the underlying metadata view is therefore reflected immediately in EDW_DIM_VIEW without modification.

Key Columns

  • ID — maps to DIM_ID in EDW_DIMENSIONS_MD_V. This is the numeric identifier for the dimension and serves as the primary join key when correlating EDW_DIM_VIEW to other dimensional or fact objects in the warehouse layer.
  • VALUE — maps to DIM_LONG_NAME in EDW_DIMENSIONS_MD_V. This is the descriptive, human-readable long name of the dimension, and is the attribute the user searched for under the name dim_long_name. It is the field typically displayed in list-of-values pickers, report parameter prompts, and extract headers.

The absence of a short name, description, or status column means that consumers needing additional dimension attributes must query EDW_DIMENSIONS_MD_V directly or join back to it on DIM_ID.

Common Use Cases and Queries

The view is commonly used wherever a generic ID/value lookup pattern is required, such as populating a report parameter, driving a Discoverer list of values, or feeding an external extract that expects a uniform two-column shape.

Retrieve all dimension identifiers with their long names:

SELECT id, value
FROM   apps.edw_dim_view
ORDER  BY value;

Resolve a specific dimension name from its identifier:

SELECT value
FROM   apps.edw_dim_view
WHERE  id = :p_dim_id;

Locate a dimension by its long name:

SELECT id
FROM   apps.edw_dim_view
WHERE  value = :p_dim_long_name;

Join back to the full metadata view when additional attributes are required:

SELECT v.id, v.value, m.dim_short_name
FROM   apps.edw_dim_view v,
       apps.edw_dimensions_md_v m
WHERE  v.id = m.dim_id;

Because the view is defined in the APPS schema and the underlying metadata view is not documented as publicly exposed, grants or a covering synonym are typically required for non-APPS users. Query performance is dictated entirely by EDW_DIMENSIONS_MD_V, and no indexes or materializations are introduced by the view itself.