Search Results gcs_entry_lines

Overview

The GCS_ENTRY_LINES table is a core data object within the Oracle E-Business Suite Financial Consolidation Hub (GCS) module. It serves as the detailed repository for all line-level entries generated during the financial consolidation process. This table stores the granular transactional data that aggregates into consolidated financial statements, representing the fundamental building blocks for consolidation journals, eliminations, adjustments, and currency translations. Its role is critical for maintaining the integrity and auditability of the consolidation ledger, enabling the system to track the source, nature, and accounting impact of each financial line item across multiple legal entities and reporting periods.

Key Information Stored

The table's structure is designed to uniquely identify and describe each consolidation entry line. As defined by its primary key, the table is organized around four essential identifiers: ENTRY_ID, which links to the parent consolidation journal header; COMPANY_COST_CENTER_ORG_ID, which identifies the specific legal entity or cost center; INTERCOMPANY_ID, used for tracking intercompany transactions between entities within the consolidation group; and LINE_ITEM_ID, which uniquely sequences lines within an entry. While the provided metadata does not list specific attribute columns, typical data stored in such a table includes accounting flexfield combinations (e.g., Code Combination ID), entered and functional currency amounts, line descriptions, and references to source system transactions. The composite primary key ensures that no duplicate line items exist for a given entry, company, and intercompany context.

Common Use Cases and Queries

Primary use cases involve reporting, reconciliation, and troubleshooting the consolidation data flow. Financial controllers run queries against this table to verify the details of consolidation adjustments or to analyze intercompany balances before elimination. A common reporting pattern is to join this table to the consolidation entry headers (GCS_ENTRIES) and the chart of accounts (via FND_FLEX_VALUES) to produce detailed trial balances for a specific consolidation entity or process run. Sample SQL often includes filters on period, consolidation entity, and specific account ranges. For instance, a query to list all elimination entries for a given intercompany partner would join on INTERCOMPANY_ID and filter for the appropriate entry type. Data integrity checks also frequently query this table to ensure the sum of line amounts matches the header totals.

Related Objects

The GCS_ENTRY_LINES table has a fundamental relationship with the consolidation entry header table, typically named GCS_ENTRIES, where the ENTRY_ID column serves as a foreign key. This parent-child relationship is central to the consolidation journal structure. Based on the primary key components, other likely related objects include tables storing entity master data (for COMPANY_COST_CENTER_ORG_ID), intercompany partner definitions (for INTERCOMPANY_ID), and the consolidation ledger tables. The table is also a primary source for various consolidation reporting views within the GCS schema, which aggregate and present this detailed data for end-user consumption. All processes that create, update, or query consolidation journal lines will interact directly with this table.