Results for “pa_tsk_act_cmt_it_all”

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

Overview

PA_TSK_ACT_CMT_IT_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores task-level actuals and commitments for the Oracle Project Analysis Collection Pack. It serves as a consolidated analytical store where accumulated actual and commitment balances are captured at the intersection of task, period, resource, expenditure type, service type, and organization. This granularity supports project performance analysis, cost and revenue trending, and commitment tracking without requiring repeated aggregation against transactional subledger tables.

Within the ETRM 12.2.2 documented physical schema, the table resides in the PA schema under the name PA.PA_TSK_ACT_CMT_IT_ALL_ and exposes 42 columns. The heuristic Data Vault classification mined from the foreign key structure is link, suggesting this object functions primarily as a junction resolving relationships among tasks, periods, resources, expenditure types, service types, and organizations. It is therefore best modeled as a fact-like intersection record rather than a standalone hub or descriptive satellite.

Key Information Stored

The surrogate primary key is TASK_ACT_CMT_KEY, enforced by the PA_TSK_ACT_CMT_IT_ALL_PK constraint. A second unique index, PA_TSK_ACT_CMT_IT_ALL_U1, also covers TASK_ACT_CMT_KEY, confirming it as the sole documented business-key candidate. The most significant business and measure columns include:

• TASK_ID – identifies the task within the project hierarchy; joins to PA_TOP_TASKS_IT.
• PA_PERIOD_KEY – the accounting or reporting period for which balances are accumulated.
• RESOURCE_LIST_MEMBER_ID – the resource list member associated with the accumulated amounts.
• EXPENSE_ORGANIZATION_ID / OWNER_ORGANIZATION_ID – expense and owning organizations providing organizational context.
• EXPENDITURE_TYPE – classification of the cost or commitment being accumulated.
• SERVICE_TYPE_CODE – service type dimension for the record.
• ORG_ID – operating unit identifier used for multi-org security and partitioning.
• ACCUME_REVENUE, ACCUME_RAW_COST, ACCUME_BURDENED_COST, ACCUME_QUANTITY, ACCUME_LABOR_HOURS – accumulated actual revenue, cost, quantity, and labor measures.
• ACCUME_BILLABLE_RAW_COST, ACCUME_BILLABLE_BURDENED_COST, ACCUME_BILLABLE_QUANTITY, ACCUME_BILLABLE_LABOR_HOURS – billable counterparts of the accumulated actual measures.
• ACCUME_CMT_RAW_COST, ACCUME_CMT_BURDENED_COST, ACCUME_CMT_QUANTITY – accumulated commitment amounts.
• UNIT_OF_MEASURE and STATUS_CODE – qualifying attributes for quantity and record status.
• LAST_UPDATE_DATE, CREATION_DATE, REQUEST_ID, PROGRAM_ID – standard audit and concurrent program lineage columns.

Common Use Cases and Queries

Typical usage involves task-level cost, revenue, and commitment reporting. A common pattern joins the table to the task and period dimensions to compare actual burdened cost against commitments for a given period:

• Aggregating accumulated actuals by task: SELECT TASK_ID, SUM(ACCUME_BURDENED_COST) FROM PA_TSK_ACT_CMT_IT_ALL GROUP BY TASK_ID;
• Comparing billable versus non-billable positions: SELECT TASK_ID, SUM(ACCUME_BURDENED_COST), SUM(ACCUME_BILLABLE_BURDENED_COST) FROM PA_TSK_ACT_CMT_IT_ALL GROUP BY TASK_ID;
• Tracking commitments by expenditure type: SELECT EXPENDITURE_TYPE, SUM(ACCUME_CMT_BURDENED_COST) FROM PA_TSK_ACT_CMT_IT_ALL GROUP BY EXPENDITURE_TYPE;
• Period-over-period trending joined to PA_PERIODS_IT on PA_PERIOD_KEY.
• Operating unit filtering using ORG_ID for multi-org reporting.

Related Objects

The foreign keys define the core dimensional relationships from this table:

• PA_TOP_TASKS_IT – joined on TASK_ID; provides task-level context.
• PA_PERIODS_IT – joined on PA_PERIOD_KEY; supplies period attributes.
• PA_LOWEST_RLMEM_IT – joined on RESOURCE_LIST_MEMBER_ID; defines the lowest resource list member.
• PA_PRJ_ORGS_IT – joined on OWNER_ORGANIZATION_ID.
• PA_EXP_ORGS_IT – joined on EXPENSE_ORGANIZATION_ID.
• PA_EXP_TYPES_IT – joined on EXPENDITURE_TYPE.
• PA_SRVC_TYPES_IT – joined on SERVICE_TYPE_CODE.
• PA_OPER_UNITS_IT – joined on ORG_ID; supplies operating unit context.