Search Results cdl_acct_currency_code

Overview

PA.PA_EI_CDL_CM_GTEMP2 is a global temporary table in the Oracle E-Business Suite Projects (PA) schema. It is registered as PA.PA_EI_CDL_CM_GTEMP2 under FND Design Data and is currently VALID in both 12.1.1 and 12.2.2 environments. As a global temporary table (GTT), its definition is persistent in the data dictionary, but its data is session-private: the current session can see only the rows it inserted, and other concurrent sessions cannot observe them.

The table’s data duration is SYS$TRANSACTION. Rows are removed at the end of the transaction that inserted them, which means PA_EI_CDL_CM_GTEMP2 is designed as transient working storage rather than a permanent fact carrier. In practice it supports Oracle Projects cost distribution and cross-charge processing logic, particularly the calculation of raw cost in multiple currency perspectives (denominated, accounting, project, and project functional) before those amounts are validated and posted to permanent expenditure tables.

Heuristically, the table is classified as a standalone structure, meaning it does not carry a formal Data Vault role such as hub, link, or satellite. As a modeling suggestion, it is best understood as a transient staging or work table rather than a conformed dimension or fact. Its single documented foreign key reference to PA.PA_EXPENDITURE_ITEMS_ALL indicates that rows are populated from or validated against existing expenditure items.

Key Information Stored

Although PA_EI_CDL_CM_GTEMP2 contains 62 documented columns, the following are the most operationally significant:

• EXPENDITURE_ITEM_ID — The primary business linkage to PA_EXPENDITURE_ITEMS_ALL. This is the most important key column for joining temporary rows back to the permanent expenditure item record.
• PROJECT_ID, TASK_ID, ORGANIZATION_ID, ORG_ID — Identify the project, task, expenditure organization, and operating unit context for each row.
• PA_DATE, EXPENDITURE_ITEM_DATE, PA_PERIOD_NAME — Date and period context used for cost distribution, rate determination, and period-based reporting.
• CDL_AMOUNT — The core calculated amount produced by the cost distribution logic (CDL).
• CDL_ACCT_CURRENCY_CODE, CDL_ACCT_RAW_COST — The accounting currency code and the raw cost expressed in that currency. CDL_ACCT_CURRENCY_CODE is the specific column the user searched for, and it is central to any query that compares the accounting-perspective amount against the functional or project currency amounts.
• CDL_DENOM_CURRENCY_CODE, CDL_DENOM_RAW_COST, CDL_PROJECT_CURRENCY_CODE, CDL_PROJECT_RAW_COST, CDL_PROJFUNC_CURRENCY_CODE — Parallel currency and raw cost columns for the denominated, project, and project functional perspectives, allowing a single row to be evaluated across all four currency views.
• ACCT_CURRENCY_CODE, PROJECT_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE, DENOM_CURRENCY_CODE — Non-prefixed counterparts that supply the currency code associated with each established perspective.
• Rate columns — ACCT_RATE_DATE, ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE, PROJECT_RATE_DATE, PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE, PROJFUNC_COST_RATE_DATE, PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_EXCHANGE_RATE — Capture the exchange rate metadata used to convert raw cost into each currency view.
• CBS_ELEMENT_ID, COST_BASE, COST_PLUS_STRUCTURE — Cost breakdown structure and cost base context for burdening and cost-plus processing.
• BURDEN_SUM_SOURCE_RUN_ID, BURDEN_SUM_REJECTION_CODE — Track the burden summarization run that produced the row and any rejection condition encountered.
• REQUEST_ID — Identifies the concurrent request that populated the temporary rows, useful for troubleshooting and re-run isolation.

The table has no documented surrogate primary key; EXPENDITURE_ITEM_ID functions as the principal business-key candidate for joining to permanent expenditure records.

Common Use Cases and Queries

This GTT is primarily consumed by Oracle Projects cost distribution and burdening programs. Typical scenarios include diagnosing currency conversion discrepancies, verifying raw cost amounts across the four currency perspectives, and investigating rejected burden rows.

A representative query isolating the accounting-currency context is:

• SELECT expenditure_item_id, project_id, task_id, cdl_amount, cdl_acct_raw_cost, cdl_acct_currency_code, cdL_denom_currency_code, cdL_project_currency_code FROM pa.pa_ei_cdl_cm_gtemp2 WHERE cdl_acct_currency_code IS NOT NULL;

Because the table is transaction-scoped and session-private, such queries must be executed from the same session that performed the insert, typically within a diagnostic script or an instrumented concurrent program run. Reporting use cases focus on reconciling CDL_ACCT_RAW_COST against CDL_DENOM_RAW_COST and CDL_PROJECT_RAW_COST, confirming that exchange rates in ACCT_EXCHANGE_RATE and PROJECT_EXCHANGE_RATE applied correctly, and detecting rows flagged with BURDEN_SUM_REJECTION_CODE.

Related Objects

• PA.PA_EXPENDITURE_ITEMS_ALL — The sole documented foreign key target, joined via EXPENDITURE_ITEM_ID to PA_EI_CDL_CM_GTEMP2.EXPENDITURE_ITEM_ID.
• PA.PA_EXPENDITURE_ITEM_DETAILS — Stores raw cost distribution lines that correspond to the calculated amounts staged in the GTT.
• PA.PA_COST_DISTRIBUTION_LINES_ALL — The permanent repository for distributed cost lines produced after the GTT logic completes.
• PA.PA_PROJECTS_ALL, PA.PA_TASKS — Provide project and task context for PROJECT_ID and TASK_ID.
• PA.PA_PERIODS_ALL — Validates PA_PERIOD_NAME and period-based processing.
• GL.GL_DAILY_CONVERSION_TYPES, GL.GL_CURRENCIES — Source of currency codes and rate types referenced by the rate columns.
• FND.FND_CONCURRENT_REQUESTS — Links REQUEST_ID to the concurrent program that populated the temporary rows.