Results for “edw_sr_option_type_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDW_SR_OPTION_TYPE_V is a reporting view within the Oracle E-Business Suite (EBS) BIS (Business Intelligence System) product family, specifically associated with the Enterprise Data Warehouse (EDW) configuration layer. It exposes the set of enabled "source" configuration options that the EDW uses to govern its data extraction and transformation behavior. In practice, the view presents a curated list of option codes and their human-readable names, drawn from the standard Oracle Applications lookup mechanism and constrained to options relevant to the EDW source instance.
The view is not an operational or transactional object. It is a metadata and configuration reporting object intended for integration, diagnostics, and reporting scenarios. Because it filters on DATABASE='SOURCE' and INSTANCE_CODE IS NULL, it effectively answers the question "which EDW options are defined as source-level, non-instance-specific configuration values?" This makes it useful when validating ETL setup, auditing configuration drift, or feeding option metadata into downstream BI objects.
The view name suggests it also carries the option type classification, allowing consumers to distinguish between different categories of options rather than treating all codes as a flat list. This is reinforced by the inclusion of the OPTION_TYPE column sourced from the EDW configuration table, which links the lookup-based label to the EDW-specific classification.
Underlying Base Objects
According to the documented view text, EDW_SR_OPTION_TYPE_V is defined over two underlying objects joined on the option code:
- FND_LOOKUP_VALUES_VL — the standard Oracle Applications lookup view. The view aliases this as
FLKand restricts it toLOOKUP_TYPE='EDW_OPTION_LOOKUP'andENABLED_FLAG='Y', ensuring only active EDW option lookups are surfaced. - EDW_CFIG_OPTIONS — the EDW configuration table, aliased as
COP. This table supplies the OPTION_TYPE value and carries the filtering attributesDATABASEandINSTANCE_CODE.
The join condition is FLK.LOOKUP_CODE = COP.OPTION_CODE. The additional predicates COP.DATABASE='SOURCE' and COP.INSTANCE_CODE IS NULL narrow the result set to source-level, non-instance-scoped definitions. The ETRM metadata records no separately documented base objects beyond what appears in the view text, and the view is noted as "not implemented in this database," meaning it may be absent from certain environments or shipped conditionally.
Key Columns
The view exposes four columns:
- OPTION_CODE — the lookup code from FND_LOOKUP_VALUES_VL; the technical identifier for the option, joined against EDW configuration.
- OPTION_NAME — the lookup "meaning"; the user-facing label for the option, returned as FLK.MEANING. This is the column most commonly searched and displayed.
- DESCRIPTION — the descriptive text associated with the lookup value, providing additional context on the option's purpose.
- OPTION_TYPE — the classification drawn from EDW_CFIG_OPTIONS, distinguishing option categories within the EDW configuration framework.
Common Use Cases and Queries
Typical uses include confirming which EDW source options are active, mapping option codes to friendly names, and filtering options by type. For example, to list all enabled source options ordered by name:
SELECT OPTION_CODE, OPTION_NAME, OPTION_TYPE FROM EDW_SR_OPTION_TYPE_V ORDER BY OPTION_NAME;
To locate a specific option by its display name, matching the common option_name search pattern:
SELECT OPTION_CODE, OPTION_NAME, DESCRIPTION
FROM EDW_SR_OPTION_TYPE_V
WHERE UPPER(OPTION_NAME) LIKE UPPER('%COST%');
To group available options by classification:
SELECT OPTION_TYPE, COUNT(*) OPTION_COUNT FROM EDW_SR_OPTION_TYPE_V GROUP BY OPTION_TYPE;
These queries support configuration auditing and pre-extraction validation without touching the underlying EDW tables directly.
-
View: EDW_SR_OPTION_TYPE_V 12.1.1
EDW_SR_OPTION_TYPE_V
Not implemented in this database·Explore BIS module →
-
View: EDW_SR_OPTION_TYPE_V 12.2.2
EDW_SR_OPTION_TYPE_V
Not implemented in this database·Explore BIS module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2