Search Results fact_long_name




Overview
Explore in AI Chat

Overview

EDW_SEC_FACT_INFO_V is a security and metadata view within the Oracle E-Business Suite (EBS) Business Intelligence System (BIS) product family, commonly associated with the Enterprise Data Warehouse (EDW) and Daily Business Intelligence (DBI) reporting infrastructure. In EBS 12.1.1 and 12.2.2, this view serves as a lightweight abstraction layer that exposes fact metadata definitions to reporting, security, and integration components. It provides a consolidated, read-only projection of fact identifiers, their descriptive names, their relationship to dimensions, and the foreign key column names that join facts to those dimensions.

The view is particularly relevant to users searching for "fact_long_name," as it exposes the FACT_LONG_NAME column, which carries the human-readable, descriptive label for each fact. This makes the view a convenient source for resolving fact identifiers (FACT_ID) into meaningful business terminology, a common requirement when building security rules, metadata-driven reports, or documentation extracts. Because the underlying metadata view is not implemented directly in all database instances, the object functions primarily as a metadata reference and may return no rows in environments where the EDW metadata schema has not been deployed.

Underlying Base Objects

Per the documented ETRM metadata, EDW_SEC_FACT_INFO_V is defined over a single referenced object: EDW_FACT_DIM_RELATIONS_MD_V. No additional base tables are documented for this view, and the ETRM entry confirms that it is "not implemented in this database" for the documented instance, meaning the view text exists as a definition but resolves against a metadata view that may be absent in a given environment.

The relationship is straightforward: EDW_SEC_FACT_INFO_V is a column-renaming and projection layer over EDW_FACT_DIM_RELATIONS_MD_V. The view text selects FACT_ID, FACT_NAME, FACT_LONG_NAME, DIM_ID, and FACT_FK_COL_NAME (aliased to FK_COL_NAME) directly from the parent metadata view. Because the parent view name ends in "_MD_V" (metadata view), the underlying data is expected to be static metadata maintained by the EDW/DBI configuration, rather than transactional business data.

Key Columns

  • FACT_ID — The numeric or surrogate identifier for the fact. Serves as the primary reference key when joining to other fact metadata objects.
  • FACT_NAME — The technical or short name of the fact, typically used programmatically for object resolution and internal joins.
  • FACT_LONG_NAME — The descriptive, business-friendly label for the fact. This is the column most relevant to users searching for "fact_long_name," and it is used to present facts in user-facing reports, dashboards, and metadata listings.
  • DIM_ID — The identifier of the dimension associated with the fact through the fact-dimension relationship. Enables grouping or filtering facts by dimension.
  • FK_COL_NAME — The foreign key column name (aliased from FACT_FK_COL_NAME) that links the fact to the referenced dimension. This is essential for constructing join paths in metadata-driven SQL generation.

Common Use Cases and Queries

Typical scenarios include metadata discovery, security rule construction, and automated documentation of the EDW star schema. A reporting developer might query the view to list all facts with their long names, or to identify the foreign key columns needed to join a fact to a given dimension.

Sample query to list facts and their descriptive names:

  • SELECT FACT_ID, FACT_NAME, FACT_LONG_NAME FROM EDW_SEC_FACT_INFO_V ORDER BY FACT_LONG_NAME;

Sample query to find facts for a specific dimension and their join columns:

  • SELECT FACT_ID, FACT_LONG_NAME, FK_COL_NAME FROM EDW_SEC_FACT_INFO_V WHERE DIM_ID = :dim_id;

Sample query to search by descriptive name:

  • SELECT FACT_ID, FACT_NAME, FACT_LONG_NAME FROM EDW_SEC_FACT_INFO_V WHERE UPPER(FACT_LONG_NAME) LIKE '%REVENUE%';

Because the object is metadata-oriented and may not be implemented in every database, queries should be preceded by a check of DBA_VIEWS or ALL_VIEWS to confirm availability. Where present, the view provides a reliable, low-overhead mechanism for resolving fact metadata in EBS 12.1.1 and 12.2.2 environments.