Results for “ytd_debit_balance_e”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GCS_ENTRY_LINES is a table within the GCS schema supporting the Financial Consolidation Hub module in Oracle E-Business Suite 12.1.1 and 12.2.2. The object stores consolidation entry lines — the individual debit and credit line detail that makes up each consolidation journal entry processed by Financial Consolidation Hub. Because consolidation entries aggregate balances across legal entities, cost centers, and intercompany relationships, this table serves as the granular fact store at the line level of the consolidation engine.

The documented primary key is GCS_ENTRY_LINES_PK, composed of ENTRY_ID, COMPANY_COST_CENTER_ORG_ID, INTERCOMPANY_ID, and LINE_ITEM_ID. A heuristic Data Vault classification mined from the foreign-key structure identifies this object as standalone. In modeling terms, this suggests the table behaves as an independent transactional fact rather than a pure hub, link, or satellite, though its composite key and dimensional columns make it resemble a fact table supporting consolidation analytics.

Key Information Stored

The table contains 35 documented columns in the 12.1.1 physical schema. The most significant include:

• ENTRY_ID — Identifies the parent consolidation entry; part of the composite primary key.
• LINE_ITEM_ID — Distinguishes individual lines within an entry; part of the composite primary key.
• LINE_TYPE_CODE — Classifies the nature of the line (for example, elimination, adjustment, or translation).
• COMPANY_COST_CENTER_ORG_ID — The organization dimension for the line; part of the primary key.
• INTERCOMPANY_ID — The intercompany trading partner; part of the primary key, critical for elimination logic.
• FINANCIAL_ELEM_ID — The financial element (account grouping) to which the line posts.
• NATURAL_ACCOUNT_ID — The natural account segment referenced by the line.
• PRODUCT_ID, CHANNEL_ID, PROJECT_ID, CUSTOMER_ID, TASK_ID — Dimensional columns aligned with GL segment values.
• USER_DIM1_ID through USER_DIM10_ID — Ten user-defined dimensions providing extensibility for custom segment mapping.
• XTD_BALANCE_E, YTD_BALANCE_E — Extended and year-to-date balance amounts.
• PTD_DEBIT_BALANCE_E, PTD_CREDIT_BALANCE_E, YTD_DEBIT_BALANCE_E, YTD_CREDIT_BALANCE_E — Period and year-to-date debit/credit balance measures.
• DESCRIPTION, ENTRY_LINE_NUMBER — Line narrative and ordinal sequencing.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The surrogate primary key combines four business-identifying attributes, so no separate surrogate sequence column is documented. The dimensional columns collectively act as the business-key candidate space.

Common Use Cases and Queries

Typical scenarios include auditing elimination entries, reconciling intercompany balances, and tracing consolidation adjustments back to source. A representative query joining entries to their intercompany dimension might look like:

• SELECT entry_id, line_item_id, intercompany_id, natural_account_id, ptd_debit_balance_e, ptd_credit_balance_e FROM gcs.gcs_entry_lines WHERE entry_id = :entry_id;
• Aggregating balances by financial element: SELECT financial_elem_id, SUM(ytd_debit_balance_e) FROM gcs.gcs_entry_lines GROUP BY financial_elem_id;
• Isolating intercompany mismatches: WHERE ptd_debit_balance_e <> ptd_credit_balance_e across matching INTERCOMPANY_ID values.
• Reporting by user dimension: filtering on USER_DIM1_ID through USER_DIM10_ID to produce management-book outputs.

Related Objects

The documented foreign-key relationship links GCS_ENTRY_LINES.PRODUCT_ID to FND_DM_PRODUCTS, the standard product dimension table. Beyond this, the composite key implies joins to the parent entry header object via ENTRY_ID. Integration and reporting dependencies typically include GCS_ENTRY_HEADERS (or an equivalent entry header table) for entry metadata, GL period and balance tables for reconciliation to the general ledger, and the FND_DM_PRODUCTS dimension for product-level rollups. Financial Consolidation Hub extraction and reporting processes reference this table when generating consolidation journals and elimination reports.