Search Results child_low

Overview

EDW_CONS_MAPPING_V is an internal database view associated with the FII (Financial Intelligence) product family in Oracle E-Business Suite. In the ETRM metadata for releases 12.1.1 and 12.2.2, the object is classified under FII – Financial Intelligence (Obsolete). Its documented purpose is to support the consolidation package, a data extraction and transformation component used by Financial Intelligence to align General Ledger consolidation hierarchies with segment mapping definitions.

The view presents a unified, flattened representation of the relationship between consolidation segment mappings and consolidation flex hierarchies. It is not intended for direct end-user reporting; rather, it functions as a staging or transformation layer consumed by the FII consolidation extraction package. The metadata notes that the view is "Not implemented in this database" in the documented environment, meaning availability depends on whether the FII consolidation components have been deployed and configured.

Because the object belongs to an obsolete FII component, its presence in a given EBS instance should be treated as legacy. Nonetheless, in environments where the consolidation package is still active, EDW_CONS_MAPPING_V remains relevant for reconciling consolidation hierarchies and segment mappings.

Underlying Base Objects

The view is defined over two General Ledger consolidation tables:

• GL_CONS_SEGMENT_MAP (aliased CSM) — stores consolidation segment mapping definitions, including the mapping type, the consolidation identifier, and the source and target value set identifiers.
• GL_CONS_FLEX_HIERARCHIES (aliased CFH) — stores the flex hierarchy ranges that correspond to a given segment mapping.

The view text uses a UNION ALL of two branches. The first branch joins CFH to CSM on SEGMENT_MAP_ID and filters for SEGMENT_MAP_TYPE = 'R', producing a child-low/child-high range drawn from the hierarchy table. The second branch selects directly from GL_CONS_SEGMENT_MAP where SEGMENT_MAP_TYPE = 'P', using PARENT_ROLLUP_VALUE for both the child-low and child-high columns and SINGLE_VALUE as the parent. The documented metadata lists no other referenced base objects.

Key Columns

• CHILD_LOW and CHILD_HIGH — the lower and upper bounds of the child value range. For type 'R' mappings these come from CFH.CHILD_FLEX_VALUE_LOW/HIGH; for type 'P' mappings both are set to CSM.PARENT_ROLLUP_VALUE.
• PARENT — the parent flex value. For range mappings this is CFH.PARENT_FLEX_VALUE; for 'P' mappings it is CSM.SINGLE_VALUE.
• CONSOLIDATION_ID — the identifier of the consolidation definition, sourced from GL_CONS_SEGMENT_MAP. This is the column most frequently referenced when linking mappings to a specific consolidation.
• SEGMENT_MAP_TYPE — indicates the mapping style, with 'R' for range-based hierarchies and 'P' for single or parent rollup mappings.
• SEGMENT_MAP_ID — the primary key of the segment mapping row in GL_CONS_SEGMENT_MAP.
• FROM_VALUE_SET_ID and TO_VALUE_SET_ID — the source and target value set identifiers used to convert between value sets during consolidation.

Common Use Cases and Queries

The view is typically queried to audit or extract consolidation segment mappings for a specific consolidation. A representative query retrieves all mapping rows for a known consolidation_id:

• SELECT consolidation_id, segment_map_id, segment_map_type, parent, child_low, child_high, from_value_set_id, to_value_set_id FROM EDW_CONS_MAPPING_V WHERE consolidation_id = :p_consolidation_id ORDER BY segment_map_id;

Analysts may also use the view to inspect only range-based mappings, or to join the view back to GL_CONS_SEGMENT_MAP or GL_CONS_FLEX_HIERARCHIES to validate that the flattened output matches the underlying definitions. Because the object is documented as obsolete and as "not implemented" in the reference database, queries should verify object existence and privileges before use in any given EBS 12.1.1 or 12.2.2 environment.