Results for “pa_cost_distribution_lines_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_COST_DISTRIBUTION_LINES_ALL is the core Oracle Projects table that stores the distribution of expenditure item costs across general ledger accounts, projects, tasks, and reporting currencies. Its documented description is "Information about expenditure item cost distribution." Each row represents one cost distribution line for an expenditure item, identifying the debit and credit accounting flexfield combinations, the amounts in denominator, project, project functional, and accounting currencies, and the transfer status to Oracle General Ledger. The table sits at the intersection of Oracle Projects costing and subledger accounting: it is populated during the cost distribution and burdening process and is the source from which project costs are transferred to GL and summarized for capitalization and asset generation.

From a modeling perspective, the FK structure suggests a satellite-leaning classification: the table holds descriptive, mutable attributes (amounts, status codes, dates, flags) that hang off the central EXPENDITURE_ITEM_ID business key rather than acting as a standalone hub or link. The _ALL suffix indicates multi-organization partitioning by ORG_ID, which must be considered in every query.

Key Information Stored

The primary key is PA_COST_DISTRIBUTION_LINES_PK, composed of LINE_NUM and EXPENDITURE_ITEM_ID. A separate unique index, PA_COST_DISTRIBUTION_LINES_U1 (EXPENDITURE_ITEM_ID, LINE_NUM), serves as the business-key candidate, confirming that line number is only unique within an expenditure item.

The most significant columns include:

• EXPENDITURE_ITEM_ID and LINE_NUM — the composite key linking each distribution line to its parent expenditure item.
• DR_CODE_COMBINATION_ID and CR_CODE_COMBINATION_ID — the debit and credit accounting flexfield combinations (FK to GL_CODE_COMBINATIONS).
• PROJECT_ID and TASK_ID — the project and task to which the cost is charged.
• ORG_ID — the operating unit, required for multi-org security.
• DENOM_RAW_COST, DENOM_BURDENED_COST — raw and burdened costs in the denominator (transaction) currency.
• PROJECT_RAW_COST, PROJECT_BURDENED_COST — amounts converted to project currency along with PROJECT_CURRENCY_CODE, PROJECT_EXCHANGE_RATE, and PROJECT_RATE_TYPE.
• ACCT_RAW_COST, ACCT_BURDENED_COST — amounts in accounting currency with ACCT_CURRENCY_CODE, ACCT_EXCHANGE_RATE, and ACCT_RATE_TYPE.
• TRANSFER_STATUS_CODE, GL_DATE, TRANSFERRED_DATE, GL_PERIOD_NAME — transfer state to General Ledger, and TRANSFER_REJECTION_REASON for failures.
• BATCH_NAME — FK to PA_EXPENDITURE_BATCHES_ALL, identifying the expenditure batch.
• REVERSED_FLAG and LINE_NUM_REVERSED — self-referencing reversal tracking.
• PA_DATE, PA_PERIOD_NAME, GL_PERIOD_NAME — accounting dates and periods for Projects and GL.

Common Use Cases and Queries

Typical reporting involves reconciling project costs to GL, auditing untransferred or rejected distributions, and validating burdened versus raw cost amounts.

• Identify distributions not yet transferred to GL: filter on TRANSFER_STATUS_CODE and null GL_DATE.
• Reconcile project currency to accounting currency by comparing PROJECT_BURDENED_COST and ACCT_BURDENED_COST.
• Trace reversed lines using LINE_NUM_REVERSED against the same EXPENDITURE_ITEM_ID.

A representative query pattern:

• SELECT pcdl.expenditure_item_id, pcdl.line_num, pcdl.acct_burdened_cost, pcdl.transfer_status_code FROM pa_cost_distribution_lines_all pcdl WHERE pcdl.org_id = :org_id AND pcdl.gl_date IS NULL;

These queries are common in period-end close reporting, cost transfer audits, and capital project asset reconciliation.

Related Objects

The following objects are the most significant dependencies based on documented foreign keys:

• PA_EXPENDITURE_ITEMS_ALL — joined on EXPENDITURE_ITEM_ID; the parent expenditure item.
• GL_CODE_COMBINATIONS — joined on DR_CODE_COMBINATION_ID and CR_CODE_COMBINATION_ID.
• PA_PROJECTS_ALL and PA_TASKS — joined on PROJECT_ID and TASK_ID.
• PA_EXPENDITURE_BATCHES_ALL — joined on BATCH_NAME.
• PA_PROJECT_ASSET_LINE_DETAILS — references LINE_NUM; drives asset capitalization.
• PA_TXN_ACCUM_DETAILS and PA_BC_COMMITMENTS_ALL — reference LINE_NUM for accumulation and commitment tracking.
• PA_MC_COST_DIST_LINES_ALL — multiple currency cost distribution lines referencing LINE_NUM.