Search Results gcs_lex_map_structs_pk

Overview

The GCS_LEX_MAP_STRUCTS table is a core metadata repository within Oracle E-Business Suite's Financial Consolidation Hub (GCS). It defines the overall structure of staging tables used by the Interface Data Transformer, a critical component for data integration. The table's primary role is to act as a master catalog, storing the logical blueprint for how source system data is staged and prepared for transformation and loading into the consolidation hub. This enables the mapping and derivation rules engine to correctly interpret and process incoming financial data from disparate source systems across the enterprise.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's description and relationships define its core data. The central column is STRUCTURE_ID, which serves as the unique identifier (Primary Key: GCS_LEX_MAP_STRUCTS_PK) for each defined staging table structure. Each record in this table represents a distinct staging table definition. Associated metadata likely includes descriptive information such as the structure name, its purpose, the source system type, and creation details. This master record is then referenced by numerous child objects that define the detailed mapping logic.

Common Use Cases and Queries

This table is primarily accessed during the setup, maintenance, and troubleshooting of consolidation data interfaces. Common operational scenarios include auditing all configured data interfaces, diagnosing mapping errors by tracing back to the source structure definition, and ensuring metadata integrity during upgrades. A fundamental query involves joining this table with its related objects to get a complete view of a specific interface's mapping setup.

• Listing All Defined Interface Structures: SELECT structure_id, [other_columns] FROM gcs_lex_map_structs ORDER BY structure_id;
• Analyzing a Specific Mapping Structure: This involves joining GCS_LEX_MAP_STRUCTS with GCS_LEX_MAP_COLUMNS to list all columns defined for a staging table: SELECT s.structure_id, c.column_name, c.data_type FROM gcs_lex_map_structs s, gcs_lex_map_columns c WHERE s.structure_id = c.structure_id AND s.structure_id = &STRUCTURE_ID_VALUE;

Related Objects

The GCS_LEX_MAP_STRUCTS table is a central parent table within the Interface Data Transformer's metadata schema. It has defined foreign key relationships with the following critical child tables, as documented in the ETRM metadata:

• GCS_LEX_MAP_COLUMNS: References via GCS_LEX_MAP_COLUMNS.STRUCTURE_ID. This table defines the individual columns within the staging table structure.
• GCS_LEX_MAP_DERIVATIONS: References via GCS_LEX_MAP_DERIVATIONS.LOOKUP_TABLE_ID. This table stores rules for deriving target values, linked to the source structure.
• GCS_LEX_MAP_RULES: References via GCS_LEX_MAP_RULES.LOOKUP_TABLE_ID. This table holds conditional mapping rules associated with the structure.
• GCS_LEX_MAP_RULE_SETS: References via GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID. This table groups individual rules into sets for the staging structure.