Search Results gl_expn_cds_tmp




Overview
Explore in AI Chat

Overview

GL_EXPN_CDS_TMP is a temporary (staging) table owned by the GMF schema in Oracle EBS Process Manufacturing Financials. Its documented purpose is to improve performance during the cost allocation process: rather than repeatedly querying the full GL_CODE_COMBINATIONS table, the cost allocation routines populate this table with a pre-filtered subset of account combination rows and then join against the smaller result set. The table is therefore a transient working structure rather than a master or transactional data store. The ETRM metadata records five columns and a single primary key constraint, GL_EXPN_CDS_U1, defined on CODE_COMBINATIONS.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone, meaning it is not treated as a hub, link, or satellite in the mined relationship graph. This classification reflects its role as a performance-oriented temporary structure whose grain is derived from GL_CODE_COMBINATIONS rather than an independently maintained business entity. Modelers should treat it as a derived cache, not as a source of record.

Key Information Stored

The documented physical schema contains five columns:

  • CODE_COMBINATIONS — The primary key column (constraint GL_EXPN_CDS_U1). It carries the concatenated account combination string, i.e., the rendered flexfield value that the cost allocation logic matches against.
  • CODE_COMBINATION_ID — The internal surrogate identifier for the account combination, corresponding to the GL_CODE_COMBINATIONS primary key. This is the primary join key back to the General Ledger.
  • CHART_OF_ACCOUNTS_ID — Identifies the chart of accounts to which the combination belongs, allowing the temporary set to be scoped by ledger chart of accounts.
  • ACCOUNT_TYPE — The account type classification (for example, asset, liability, expense, revenue, or owner's equity) used by cost allocation to select or exclude accounts.
  • CONCATENATED_SEGMENT_DELIMITER — The delimiter character used when the CODE_COMBINATIONS string was concatenated, ensuring the stored string is interpreted consistently.

The surrogate primary key is CODE_COMBINATIONS as documented, while CODE_COMBINATION_ID serves as the natural business-key join to GL_CODE_COMBINATIONS. Because the table is temporary, row contents should be treated as volatile and valid only for the duration of the cost allocation run.

Common Use Cases and Queries

Typical usage is diagnostic rather than operational. Consultants inspect the table to verify which combinations the allocation process staged, and to confirm that concatenated strings and delimiters match expectations.

  • Listing staged combinations for the current run:
    SELECT code_combination_id, code_combinations, account_type FROM gmf.gl_expn_cds_tmp;
  • Comparing the staged set against GL_CODE_COMBINATIONS:
    SELECT gcc.code_combination_id FROM gl_code_combinations gcc WHERE NOT EXISTS (SELECT 1 FROM gmf.gl_expn_cds_tmp t WHERE t.code_combination_id = gcc.code_combination_id);
  • Checking delimiter consistency across staged rows: SELECT DISTINCT concatenated_segment_delimiter FROM gmf.gl_expn_cds_tmp;
  • Scoping by chart of accounts: SELECT * FROM gmf.gl_expn_cds_tmp WHERE chart_of_accounts_id = :chart_id;

Because the table is repopulated per allocation run, queries should be executed during or immediately after the process; otherwise the table may be empty or contain stale rows.

Related Objects

  • GL_CODE_COMBINATIONS — The documented source table; rows are copied from here into GL_EXPN_CDS_TMP, joined on CODE_COMBINATION_ID.
  • GL_MGT_SEG_UPGRADE_H — Referenced by the CHART_OF_ACCOUNTS_ID relationship in the documented FK structure.
  • GL_EXPN_CDS_U1 — The primary key constraint on CODE_COMBINATIONS that enforces uniqueness within a staging run.
  • GMF cost allocation concurrent programs — The processes that populate and consume the temporary data.