Search Results cost_object_id




Overview
Explore in AI Chat

Overview

APPS.FEM_INTG_GL_WRTBK_BAL_GT is a global temporary table (GTT) within the Oracle E-Business Suite 12.1.1 / 12.2.2 Applications schema. It serves as an integration staging object used by the Enterprise Performance Foundation / Financial Consolidation Hub balancing engine (the FEM_INTG component) to hold general ledger writeback balance results during processing. The table is defined as a session-duration GTT (SYS$SESSION data duration), meaning rows inserted by a session remain visible only to that session and are automatically purged when the session terminates. This design supports concurrent, multi-session writes without row contention, making the object suitable for intermediate transformation and aggregation steps in GL reconciliation and writeback routines.

The table carries 30 columns and a documented heuristic Data Vault classification of standalone. Because it is a transient GTT, it does not behave as a persistent hub, link, or satellite in practice; the standalone classification is best read as a modeling suggestion that the object is self-contained and does not participate in a durable dimensional or Data Vault schema. Foreign-key metadata lists relationships from ROW_ID to CS_SYSTEMS_ALL_B_TEMP and from PRODUCT_ID to FND_DM_PRODUCTS, indicating that the working set is anchored to a system context and a product dimension.

Key Information Stored

The most operationally significant columns fall into three groups:

Common Use Cases and Queries

Typical usage involves populating the GTT during a writeback run and then querying it to verify cost object balances, currency splits, and mapping status. Because data is session-scoped, all reads must occur within the writing session. A common diagnostic query filters by cost object and code combination:

  • Aggregate PTD balances by cost object: SELECT COST_OBJECT_ID, SUM(PTD_DEBIT_BALANCE_E - PTD_CREDIT_BALANCE_E) FROM APPS.FEM_INTG_GL_WRTBK_BAL_GT GROUP BY COST_OBJECT_ID;
  • Review currency and mapping exceptions: SELECT CODE_COMBINATION_ID, CURRENCY_CODE, VS_MAPPED_FLAG FROM APPS.FEM_INTG_GL_WRTBK_BAL_GT WHERE VS_MAPPED_FLAG = 'N';
  • Join to the product dimension via PRODUCT_ID to enrich writeback reporting with FND_DM_PRODUCTS descriptions.

Reporting use cases center on reconciliation of GL writeback results against source balances, validation of segment mappings across the ten user dimensions, and audit of intercompany and project distributions prior to committing balances back to the general ledger.

Related Objects

  • CS_SYSTEMS_ALL_B_TEMP — referenced via ROW_ID, supplying the system context for the working balance set.
  • FND_DM_PRODUCTS — referenced via PRODUCT_ID, the product dimension lookup.
  • FEM_INTG_GL_WRTBK_BAL (non-GTT counterpart) — the persistent sink typically populated from this staging table.
  • GL_CODE_COMBINATIONS — resolves CODE_COMBINATION_ID into account segment detail.
  • FEM_INTG_GL_WRTBACK family of integration objects — peer staging and control tables in the writeback process.
  • CS_SYSTEMS_ALL — base system definition table underlying the temporary system reference.
  • FND_FLEX_VALUES — supports translation of the user dimension IDs for reporting.