Search Results pa_tsk_act_cmt_it_all




Overview
Explore in AI Chat

Overview

The PA_TSK_ACT_CMT_IT_ALL table is a core data repository within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Projects (PA) module. It serves as the primary storage table for the Oracle Project Analysis Collection Pack, a component designed for advanced project analytics and reporting. The table's fundamental role is to store aggregated, task-level financial data, specifically actual costs and commitment amounts. This consolidated data is critical for performance analysis, earned value management, and generating key project financial metrics by providing a unified view of financial performance at the task level.

Key Information Stored

The table stores aggregated financial data linked to key project dimensions. Its primary key is a composite key named TASK_ACT_CMT_KEY, which uniquely identifies each record. The most significant columns are those that store the aggregated financial figures, typically numeric amounts for actual costs and commitments. Crucially, the table includes foreign key columns that link this financial data to other dimension tables within the Analysis Collection Pack schema. These key linking columns include TASK_ID, PA_PERIOD_KEY, RESOURCE_LIST_MEMBER_ID, OWNER_ORGANIZATION_ID, EXPENSE_ORGANIZATION_ID, EXPENDITURE_TYPE, SERVICE_TYPE_CODE, and ORG_ID. This structure allows financial data to be analyzed across multiple hierarchical dimensions such as time, task structure, resource, organization, and expenditure type.

Common Use Cases and Queries

The primary use case for this table is generating project performance and financial analysis reports. Data is typically populated into this table via the Project Analysis Collection Pack's ETL processes from transactional sources like PA_COST_DISTRIBUTION_ALL_LINES and PA_COMMITMENT_TXNS. Common reporting scenarios include analyzing actual vs. budgeted costs per task, calculating cost performance indices (CPI), and assessing commitment liabilities. A typical analytical query would join this fact table to its related dimension tables to produce a readable report.

Sample Query Pattern:
SELECT t.task_number, p.period_name, SUM(f.actual_amount)
FROM pa_tsk_act_cmt_it_all f,
    pa_top_tasks_it t,
    pa_periods_it p
WHERE f.task_id = t.task_id
AND f.pa_period_key = p.pa_period_key
AND p.period_name = 'JAN-2024'
GROUP BY t.task_number, p.period_name;

Related Objects

PA_TSK_ACT_CMT_IT_ALL is a central fact table with defined foreign key relationships to several dimension tables within the Project Analysis Collection Pack, as documented in the ETRM. These relationships are essential for dimensional reporting.

  • PA_TOP_TASKS_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.TASK_ID to provide task hierarchy and descriptive information.
  • PA_PERIODS_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.PA_PERIOD_KEY for time period analysis.
  • PA_LOWEST_RLMEM_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.RESOURCE_LIST_MEMBER_ID for resource details.
  • PA_PRJ_ORGS_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.OWNER_ORGANIZATION_ID for project-owning organization details.
  • PA_EXP_ORGS_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.EXPENSE_ORGANIZATION_ID for expending organization details.
  • PA_EXP_TYPES_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.EXPENDITURE_TYPE for expenditure classification.
  • PA_SRVC_TYPES_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.SERVICE_TYPE_CODE for service type details.
  • PA_OPER_UNITS_IT: Joined via PA_TSK_ACT_CMT_IT_ALL.ORG_ID for operating unit context.
  • Table: PA_TSK_ACT_CMT_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_ACT_CMT_IT_ALL,  object_name:PA_TSK_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_ACT_CMT_IT_ALL , 

  • Table: PA_TSK_ACT_CMT_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_ACT_CMT_IT_ALL,  object_name:PA_TSK_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_ACT_CMT_IT_ALL , 

  • Table: PA_SRVC_TYPES_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SRVC_TYPES_IT,  object_name:PA_SRVC_TYPES_IT,  status:VALID,  product: PA - Projects ,  description: Information about service types for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_SRVC_TYPES_IT , 

  • Table: PA_TOP_TASKS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TOP_TASKS_IT,  object_name:PA_TOP_TASKS_IT,  status:VALID,  product: PA - Projects ,  description: Information about the top task level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TOP_TASKS_IT , 

  • Table: PA_SRVC_TYPES_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SRVC_TYPES_IT,  object_name:PA_SRVC_TYPES_IT,  status:VALID,  product: PA - Projects ,  description: Information about service types for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_SRVC_TYPES_IT , 

  • Table: PA_EXP_TYPES_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXP_TYPES_IT,  object_name:PA_EXP_TYPES_IT,  status:VALID,  product: PA - Projects ,  description: Information about expenditure types for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_EXP_TYPES_IT , 

  • Table: PA_EXP_TYPES_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXP_TYPES_IT,  object_name:PA_EXP_TYPES_IT,  status:VALID,  product: PA - Projects ,  description: Information about expenditure types for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_EXP_TYPES_IT , 

  • Table: PA_PERIODS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIODS_IT,  object_name:PA_PERIODS_IT,  status:VALID,  product: PA - Projects ,  description: Information about PA periods for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PERIODS_IT , 

  • Table: PA_PERIODS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERIODS_IT,  object_name:PA_PERIODS_IT,  status:VALID,  product: PA - Projects ,  description: Information about PA periods for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PERIODS_IT , 

  • Table: PA_LOWEST_RLMEM_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_LOWEST_RLMEM_IT,  object_name:PA_LOWEST_RLMEM_IT,  status:VALID,  product: PA - Projects ,  description: Information about the lowest level of resources for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_LOWEST_RLMEM_IT , 

  • Table: PA_EXP_ORGS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXP_ORGS_IT,  object_name:PA_EXP_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about expenditure organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_EXP_ORGS_IT , 

  • Table: PA_OPER_UNITS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OPER_UNITS_IT,  object_name:PA_OPER_UNITS_IT,  status:VALID,  product: PA - Projects ,  description: Information about operating units for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_OPER_UNITS_IT , 

  • Table: PA_LOWEST_RLMEM_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_LOWEST_RLMEM_IT,  object_name:PA_LOWEST_RLMEM_IT,  status:VALID,  product: PA - Projects ,  description: Information about the lowest level of resources for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_LOWEST_RLMEM_IT , 

  • Table: PA_TOP_TASKS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TOP_TASKS_IT,  object_name:PA_TOP_TASKS_IT,  status:VALID,  product: PA - Projects ,  description: Information about the top task level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TOP_TASKS_IT , 

  • Table: PA_PRJ_ORGS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ORGS_IT,  object_name:PA_PRJ_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ORGS_IT , 

  • Table: PA_OPER_UNITS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OPER_UNITS_IT,  object_name:PA_OPER_UNITS_IT,  status:VALID,  product: PA - Projects ,  description: Information about operating units for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_OPER_UNITS_IT , 

  • Table: PA_EXP_ORGS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXP_ORGS_IT,  object_name:PA_EXP_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about expenditure organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_EXP_ORGS_IT , 

  • Table: PA_PRJ_ORGS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ORGS_IT,  object_name:PA_PRJ_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ORGS_IT , 

  • View: PA_TSK_ACT_CMT_IT 12.2.2

    product: PA - Projects ,  description: Single-Org ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_TSK_ACT_CMT_IT 12.1.1

    product: PA - Projects ,  description: Single-Org ,  implementation_dba_data: Not implemented in this database ,