Search Results gcs_fem_posting_gt

Overview

GCS_FEM_POSTING_GT is a global temporary table (GT) owned by the GCS schema within the Oracle E-Business Suite Financial Consolidation Hub (FCH) module. It serves as a transient staging and posting structure used during the financial consolidation process, specifically the posting of consolidated balances into the General Ledger or into the consolidation engine's balance repository. The table temporarily holds balance amounts (entered, translated, year-to-date, period-to-date debit and credit) keyed by a comprehensive set of accounting flexfield and dimension identifiers, allowing the consolidation engine to validate, aggregate, and post balances prior to final commit. As a global temporary table, its contents are session-scoped, meaning rows persist only for the duration of a database session or transaction and are automatically purged, which makes it unsuitable for permanent reporting without first materializing its contents.

From a Data Vault modeling perspective, the heuristic classification provided in the metadata is standalone, with no foreign keys referencing a parent hub or link structure within this table itself. This suggests the object functions as a staging or staging-to-satellite buffer rather than a persistent hub, link, or satellite. Its single documented foreign key (PRODUCT_ID to FND_DM_PRODUCTS) confirms that PRODUCT_ID is a conformed dimension reference rather than an internal surrogate.

Key Information Stored

The table contains 30 documented columns. The most significant columns fall into several functional groups:

• ENTRY_ID — the primary posting/entry identifier; the primary surrogate key candidate for each row staged in the table.
• SEQUENCE_NUM — ordinal control column used to preserve insertion/processing order.
• Balance measures — XTD_BALANCE_E, YTD_BALANCE_E, PTD_DEBIT_BALANCE_E, PTD_CREDIT_BALANCE_E, YTD_DEBIT_BALANCE_E, and YTD_CREDIT_BALANCE_E hold the converted and consolidated monetary amounts that are the payload of the posting operation.
• Accounting flexfield identifiers — COMPANY_COST_CENTER_ORG_ID, NATURAL_ACCOUNT_ID, FINANCIAL_ELEM_ID, INTERCOMPANY_ID, and ENTITY_ID define the accounting distribution of each balance line.
• Analytical dimensions — PRODUCT_ID, CHANNEL_ID, LINE_ITEM_ID, PROJECT_ID, CUSTOMER_ID, and TASK_ID provide supplementary analysis segments.
• User-defined dimensions — USER_DIM1_ID through USER_DIM10_ID support extensible dimension mapping for consolidation ledgers.
• CURRENCY_CODE — the functional or entered currency of the staged amounts.

The metadata documents PRODUCT_ID as a validated foreign key to FND_DM_PRODUCTS. No secondary unique index is documented beyond the ENTRY_ID-driven row identity, so ENTRY_ID plus SEQUENCE_NUM functions as the practical business key for de-duplicating staged postings.

Common Use Cases and Queries

Typical usage centers on auditing and troubleshooting consolidation runs. A consolidation analyst or DBA might interrogate the session's staged rows to confirm that debit and credit totals balance before posting, or to trace a specific entity's translated balances. Representative query patterns include:

• Aggregating staged balances by entity and account: SELECT ENTITY_ID, NATURAL_ACCOUNT_ID, SUM(YTD_BALANCE_E) FROM GCS_FEM_POSTING_GT GROUP BY ENTITY_ID, NATURAL_ACCOUNT_ID;
• Verifying debit/credit equality: SELECT SUM(PTD_DEBIT_BALANCE_E) - SUM(PTD_CREDIT_BALANCE_E) FROM GCS_FEM_POSTING_GT;
• Joining to product master data to validate dimension values: SELECT p.PRODUCT_ID, g.YTD_BALANCE_E FROM GCS_FEM_POSTING_GT g, FND_DM_PRODUCTS p WHERE g.PRODUCT_ID = p.PRODUCT_ID;
• Inspecting sequential posting order using SEQUENCE_NUM, and filtering by CURRENCY_CODE for multi-currency reconciliation.

Because it is a temporary table, queries must be executed within the same session that populated it; otherwise the result set will be empty.

Related Objects

The documented foreign key relationship is:

• FND_DM_PRODUCTS — joined on GCS_FEM_POSTING_GT.PRODUCT_ID = FND_DM_PRODUCTS.PRODUCT_ID, providing product dimension validation.

By functional dependency, related GCS objects include the GCS_FEM_POSTING_GT's parent consolidation staging and posting programs, the FCH consolidation run/request tables, and the GL interface and GL_JE lines tables that receive the finalized posted balances. The USER_DIM identifiers logically align with the FCH dimension member tables, and the FINANCIAL_ELEM_ID relates to the consolidation financial element definition. Reporting is generally performed after the temporary rows are written into permanent FCH balance tables, making this table a transient intermediate rather than a durable reporting source.