Search Results segment1_low

Overview

GL_CONS_FLEXFIELD_MAP_LOW is a General Ledger consolidation view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the segment-level mapping ranges used during Global Consolidation. Its defining characteristic is that it projects the thirty low-range key flexfield columns — SEGMENT1_LOW through SEGMENT30_LOW — from the GL_CONS_FLEXFIELD_MAP table. These columns describe the lower bound of an accounting flexfield segment range that a consolidation mapping rule uses to select source balances and translate them to a target code combination.

The view plays a supporting role in reporting and integration rather than in the core consolidation engine. Consolidation mappings are normally created and maintained through the Consolidation Workbench or the Define Consolidation Mapping form, which operate against the base table. GL_CONS_FLEXFIELD_MAP_LOW provides a simplified, read-oriented projection that developers and integrators can query when they need to inspect the low-end segment values of mapping rules without navigating the full multi-column base table. Because consolidation mappings relate a source account range to a destination account, the low segment columns are frequently paired with their high counterparts to reconstruct the complete range definition.

Underlying Base Objects

The documented metadata states that the view is defined over a single base object: the GL_CONS_FLEXFIELD_MAP table. The view text is a straightforward SELECT list projecting the primary key and auditing columns (FLEXFIELD_MAP_ID, CONSOLIDATION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, TO_CODE_COMBINATION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), the thirty SEGMENT n_LOW columns, the descriptive flexfield attributes ATTRIBUTE1 through ATTRIBUTE5, and the CONTEXT column. The ETRM record documents no additional referenced base objects, and the view notes that it is not implemented in the documentation database, meaning the extraction reflects shipped metadata rather than a live instance.

The naming convention implies a companion view, GL_CONS_FLEXFIELD_MAP_HIGH, which projects the corresponding SEGMENT n_HIGH columns. Together the two views partition the thirty-pair range definition held in the base table, keeping each projection to a manageable column list and shielding consumers from the full width of GL_CONS_FLEXFIELD_MAP.

Key Columns

• FLEXFIELD_MAP_ID — Primary key identifying a single mapping rule row.
• CONSOLIDATION_ID — Foreign key to the consolidation definition that owns the mapping.
• TO_CODE_COMBINATION_ID — Identifier of the target accounting flexfield combination to which matched source balances are mapped.
• SEGMENT1_LOW through SEGMENT30_LOW — The lower bounds of the source account range, one per accounting flexfield segment. Only the segments enabled and used by the chart of accounts carry meaningful values; unused segment positions remain null.
• ATTRIBUTE1–ATTRIBUTE5 and CONTEXT — Descriptive flexfield columns carrying any additional, installation-specific mapping attributes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN support change tracking and reconciliation of mapping metadata.

The searched term segment1_low resolves to the first segment lower bound in this list, typically the balancing or company segment in a standard chart of accounts.

Common Use Cases and Queries

Typical uses include auditing consolidation mapping ranges, validating that source ranges are correctly bounded before a consolidation run, and extracting mapping metadata for documentation or migration. The following query lists the low range for each mapping in a given consolidation:

• SELECT flexfield_map_id, consolidation_id, segment1_low, segment2_low, segment3_low FROM gl_cons_flexfield_map_low WHERE consolidation_id = :p_consolidation_id;
• SELECT m.flexfield_map_id, m.segment1_low, m.segment2_low FROM gl_cons_flexfield_map_low m WHERE m.segment1_low = :p_company_value;
• SELECT flexfield_map_id, segment1_low, to_code_combination_id FROM gl_cons_flexfield_map_low ORDER BY last_update_date DESC;

Because the view is read-only and derived entirely from GL_CONS_FLEXFIELD_MAP, no inserts or updates should be issued against it; maintenance must target the base table through the standard consolidation forms or APIs.