Search Results pa_ei_cdl_cm_gtemp2

Overview

PA_EI_CDL_CM_GTEMP2 is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the PA schema. The "GTEMP" naming convention traditionally signals a temporary or staging table used during concurrent processing — commonly as a global temporary or working table populated as part of cost distribution, interface, or compilation logic that feeds a downstream process. In the documented 12.2.2 physical schema the table carries 62 columns, with a single documented foreign key: EXPENDITURE_ITEM_ID references PA_EXPENDITURE_ITEMS_ALL. That lone relationship anchors the table to the core expenditure item entity, confirming its role as a cost-detail carrier derived from, and subordinate to, expenditure items.

From a heuristic Data Vault modeling perspective, the mined FK structure classifies this object as standalone. The metadata does not evidence the multi-parent key combinations typical of a hub or link, so it is most reasonably modeled as a satellite-style detail table attached to the expenditure item hub. The surrogate primary key for the row is not separately documented; EXPENDITURE_ITEM_ID, LINE_NUM, and the composite of PROJECT_ID, TASK_ID, and ORGANIZATION_ID function as the practical business-key candidates. Because the table is populated and consumed internally by PA cost processing, its contents should be treated as transient rather than authoritative master data.

Key Information Stored

The table captures cost distribution and compiled cost amount (CDL) detail for expenditure items, along with the rate and currency context needed to interpret those amounts. The ten to fifteen most significant columns are:

• EXPENDITURE_ITEM_ID — foreign key to PA_EXPENDITURE_ITEMS_ALL; the primary join to the expenditure item.
• PROJECT_ID, TASK_ID, ORGANIZATION_ID — the project/task/org business key context for the costed row.
• LINE_NUM — line sequencing within the expenditure item's distribution.
• CDL_AMOUNT — the compiled cost distribution amount, the numeric core of the row.
• CDL_DENOM_RAW_COST, CDL_ACCT_RAW_COST, CDL_PROJECT_RAW_COST — raw-cost components in denominated, accounting, and project currencies.
• CDL_PROJFUNC_CURRENCY_CODE, CDL_DENOM_CURRENCY_CODE, CDL_ACCT_CURRENCY_CODE, CDL_PROJECT_CURRENCY_CODE — the currency codes for each of the cost components above.
• PA_DATE, PA_PERIOD_NAME, EXPENDITURE_ITEM_DATE — date and accounting period context for the costed row.
• EI_EXPENDITURE_TYPE, SYSTEM_LINKAGE_FUNCTION, NON_LABOR_RESOURCE — expenditure type and system linkage identifiers.
• ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE, PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE, PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_EXCHANGE_RATE — the rate type/rate pairs applied for currency conversion.
• REQUEST_ID — the concurrent request that populated the row, supporting traceability of the staging run.
• BILLABLE_FLAG, ADJUSTMENT_TYPE, COST_BASE, COST_PLUS_STRUCTURE — costing and billing attributes of the distributed row.
• CBS_ELEMENT_ID — the cost breakdown structure element associated with the row.
• BURDEN_SUM_SOURCE_RUN_ID, BURDEN_SUM_REJECTION_CODE — burden summarization run and rejection context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE10 — descriptive flexfield storage.

Common Use Cases and Queries

This table is queried primarily during cost distribution and burdening analysis, and by support teams diagnosing rejected or incomplete expenditure item costing. Typical patterns join it to the expenditure item base and filter by the concurrent request that built the temp data.

• Reconcile compiled cost amounts back to the expenditure item: SELECT g.EXPENDITURE_ITEM_ID, g.CDL_AMOUNT, e.EXPENDITURE_TYPE, e.EXPENDITURE_ITEM_DATE FROM PA_EI_CDL_CM_GTEMP2 g, PA_EXPENDITURE_ITEMS_ALL e WHERE g.EXPENDITURE_ITEM_ID = e.EXPENDITURE_ITEM_ID;
• Trace the population run and check for burden summarization rejections via REQUEST_ID and BURDEN_SUM_REJECTION_CODE.
• Report multi-currency raw costs using the CDL_*_RAW_COST columns paired with their currency codes.
• Validate rate application by comparing ACCT_RATE_TYPE/rate values against the project and project functional rate pairs for currency conversion discrepancies.

Related Objects

The following objects are the most significant points of reference for PA_EI_CDL_CM_GTEMP2:

• PA_EXPENDITURE_ITEMS_ALL — referenced through EXPENDITURE_ITEM_ID; the parent expenditure item record.
• PA_PROJECTS_ALL / PA_TASKS — provide the project and task context for PROJECT_ID and TASK_ID.
• PA_EXPENDITURE_TYPES — resolves EI_EXPENDITURE_TYPE descriptive values.
• PA_ORGANIZATIONS — supplies the expenditure organization referenced by ORGANIZATION_ID and ORG_ID.
• PA_CURRENCY_CODES / FND_CURRENCIES — resolve the various currency code columns for reporting.
• PA_COST_BASE_TYPES / PA_CBS_ELEMENTS — map COST_BASE and CBS_ELEMENT_ID to meaningful costing definitions.
• FND_CONCURRENT_REQUESTS — relates REQUEST_ID to the concurrent program that populated the staging row.