Search Results gl_cons_segment_map




Here's a description of the GL_CONS_SEGMENT_MAP table in Oracle E-Business Suite (EBS):

Table Name: GL_CONS_SEGMENT_MAP

Purpose:
The GL_CONS_SEGMENT_MAP table is used in the General Ledger (GL) module to support consolidation mapping between different segments or chart of accounts during financial consolidation processes.

Key Characteristics:
1. Used for mapping segments across different legal entities or reporting structures
2. Supports financial consolidation and reporting requirements
3. Helps align different chart of accounts during consolidation

Typical Columns:
- CONSOLIDATION_SET_ID: Unique identifier for the consolidation set
- FROM_SEGMENT_VALUE: Source segment value
- TO_SEGMENT_VALUE: Target segment value being mapped
- ENABLED_FLAG: Indicates if the mapping is active
- START_DATE: Effective start date of the mapping
- END_DATE: Effective end date of the mapping
- LAST_UPDATE_DATE: Date of last modification
- LAST_UPDATED_BY: User who last modified the record

Common Use Cases:
- Mapping different company codes during consolidation
- Aligning segment values across multiple reporting entities
- Supporting inter-company financial reporting

Typical Relationships:
- Links with GL_CONSOLIDATION_SET
- Connected to GL_LEDGER_NORM_SEG_VAL tables

This table plays a crucial role in facilitating accurate financial consolidation and reporting across complex organizational structures.