Search Results pa_ei_cdl_cm_gtemp




Overview
Explore in AI Chat

Overview

PA_EI_CDL_CM_GTEMP is a global temporary table (GTT) owned by the PA (Projects) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store valid CDL (Cost Distribution Line) detail rows that are subsequently consumed by the Create and Distribute Burden Transactions process, which in turn generates burden transactions against the appropriate cost bases. Because it is a global temporary table, the rows it holds are session- or transaction-scoped: Oracle stores them in the temporary segment and deletes them at the configured point of commitment or session termination, so the table never functions as a persistent repository of burden data.

The object carries 61 documented physical columns in the 12.1.1 schema. The ETRM metadata records that the table is not implemented in the extraction database, meaning the shown structure is derived from the shipped EBS data dictionary rather than from a live instance. From a Data Vault modeling perspective, the mined relationship data classifies this table as a standalone structure. Heuristically it behaves most like a link-satellite staging artefact rather than a hub or satellite: it holds a transient association between an expenditure item and computed cost distribution amounts, with denormalized descriptors attached. The single documented foreign key, EXPENDITURE_ITEM_ID referencing PA_EXPENDITURE_ITEMS_ALL, reinforces that the expenditure item is the principal grain anchor.

Key Information Stored

The table is keyed at the expenditure item level by EXPENDITURE_ITEM_ID, which is the documented foreign key to PA_EXPENDITURE_ITEMS_ALL and the strongest business-key candidate for joins. LINE_NUM and EXPENDITURE_ITEM_DATE provide the line-level sequencing and the expenditure date associated with each CDL row. PROJECT_ID, TASK_ID, and ORGANIZATION_ID identify the project, task, and organization context, while ORG_ID and PA_PERIOD_NAME and PA_DATE place each row in an accounting period and business date.

The CDL amount and currency set is central to the burden calculation. CDL_AMOUNT holds the raw CDL value; CDL_PROJFUNC_CURRENCY_CODE, CDL_DENOM_CURRENCY_CODE, CDL_ACCT_CURRENCY_CODE, and CDL_PROJECT_CURRENCY_CODE carry the respective currency codes; and CDL_DENOM_RAW_COST, CDL_ACCT_RAW_COST, and CDL_PROJECT_RAW_COST carry the converted raw cost in those currency bases. The broader rate columns (ACCT_EXCHANGE_RATE, PROJECT_EXCHANGE_RATE, PROJFUNC_COST_EXCHANGE_RATE and their rate date and rate type companions) preserve the conversion assumptions applied. BURDEN_SUM_SOURCE_RUN_ID and BURDEN_SUM_REJECTION_CODE record the source burden run and any rejection condition that prevented the row from proceeding. EI_EXPENDITURE_TYPE, COST_PLUS_STRUCTURE, COST_BASE, BILLABLE_FLAG, and REQUEST_ID complete the burden-relevant profile of each row.

Common Use Cases and Queries

The primary use case is diagnostic: reviewing which CDL rows were staged for a burden run and why some were rejected before burden transactions were created. A typical query filters by run identifier and rejection code:

  • SELECT ei.EXPENDITURE_ITEM_ID, g.CDL_AMOUNT, g.CDL_DENOM_RAW_COST, g.BURDEN_SUM_REJECTION_CODE FROM PA_EI_CDL_CM_GTEMP g, PA_EXPENDITURE_ITEMS_ALL ei WHERE g.EXPENDITURE_ITEM_ID = ei.EXPENDITURE_ITEM_ID;
  • Aggregate staged burden amounts by PROJECT_ID, TASK_ID, or PA_PERIOD_NAME for reconciliation against posted burden transactions.
  • Compare CDL_AMOUNT against CDL_DENOM_RAW_COST, CDL_ACCT_RAW_COST, and CDL_PROJECT_RAW_COST to verify currency conversion behavior when an exchange rate is suspected of being incorrect.
  • Join to the burden process run tables using BURDEN_SUM_SOURCE_RUN_ID to trace a specific Create and Distribute Burden Transactions execution.

Because data is session-scoped, queries must be executed within the same session that populated the table; the rows are not available for independent historical reporting.

Related Objects

The most significant dependent object is PA_EXPENDITURE_ITEMS_ALL, joined through EXPENDITURE_ITEM_ID. Supporting references include PA_PROJECTS_ALL and PA_TASKS for PROJECT_ID and TASK_ID, HR-related organization and person sources for ORGANIZATION_ID, ORG_ID, and INCURRED_BY_PERSON_ID, and the Projects cost distribution and burden source structures that supply EI_EXPENDITURE_TYPE, COST_PLUS_STRUCTURE, COST_BASE, and INVENTORY_ITEM_ID. The Create and Distribute Burden Transactions concurrent program is the process that reads this global temporary table, and BURDEN_SUM_SOURCE_RUN_ID links each staged row back to its originating burden run. Because the table is transient and not implemented in the reference database, its primary value is as a temporary bridge between cost distribution calculation and burden transaction generation rather than as a durable reporting entity.