Search Results pa_prj_act_cmt_it_all




Overview
Explore in AI Chat

Overview

The PA_PRJ_ACT_CMT_IT_ALL table is a core data repository within Oracle E-Business Suite (EBS) Projects module, specifically designed for the Oracle Project Analysis Collection Pack. Its primary role is to store aggregated, project-level financial information pertaining to actual costs and commitments. This table functions as a critical staging or reporting table, consolidating transactional data from various source modules to support analytical reporting, performance measurement, and financial analysis. The presence of the '_ALL' suffix and the 'ORG_ID' column indicates it is a multi-organization access control (MOAC) enabled table, storing data partitioned by operating unit for secure, partitioned access.

Key Information Stored

The table's structure is centered on a unique composite primary key, PRJ_ACT_CMT_KEY, which likely combines several dimensions to uniquely identify a financial fact record. Based on its foreign key relationships, the table stores data keyed by fundamental project dimensions. Important stored information includes the project identifier (PROJECT_ID), the accounting period (PA_PERIOD_KEY), and financial resource details via the RESOURCE_LIST_MEMBER_ID. It also holds organizational context through EXPENSE_ORGANIZATION_ID and OWNER_ORGANIZATION_ID, and categorizes financial data using EXPENDITURE_TYPE and SERVICE_TYPE_CODE. The table's core fact data would typically include monetary amounts for actual costs incurred and commitment obligations, aggregated to the project level for the specified period and dimension combination.

Common Use Cases and Queries

This table is predominantly used for generating project financial performance and variance analysis reports. Common use cases include comparing actual costs against budgeted commitments, analyzing expenditure trends by organization or resource type, and feeding data into higher-level business intelligence tools. A typical analytical query might join this fact table to its associated dimension tables to produce a readable report.

Sample Query Pattern:
SELECT p.segment1 project_number,
       per.period_name,
       SUM(f.actual_amount) total_actuals,
       SUM(f.commitment_amount) total_commitments
FROM pa.PA_PRJ_ACT_CMT_IT_ALL f,
       pa.pa_projects_it_all p,
       pa.pa_periods_it per
WHERE f.project_id = p.project_id
  AND f.pa_period_key = per.pa_period_key
  AND f.org_id = 123
  AND per.period_name = 'JAN-2024'
GROUP BY p.segment1, per.period_name;

Related Objects

The PA_PRJ_ACT_CMT_IT_ALL table is a central fact table with well-defined foreign key relationships to several dimension tables in the Project Analysis schema. These relationships enforce data integrity and enable meaningful joins for reporting:

  • PA_PROJECTS_IT_ALL: Joined via PROJECT_ID to retrieve project master data.
  • PA_PERIODS_IT: Joined via PA_PERIOD_KEY to obtain accounting period information.
  • PA_LOWEST_RLMEM_IT: Joined via RESOURCE_LIST_MEMBER_ID for resource details.
  • PA_EXP_ORGS_IT: Joined via EXPENSE_ORGANIZATION_ID for the expending organization.
  • PA_PRJ_ORGS_IT: Joined via OWNER_ORGANIZATION_ID for the project owning organization.
  • PA_EXP_TYPES_IT: Joined via EXPENDITURE_TYPE for expenditure classification.
  • PA_SRVC_TYPES_IT: Joined via SERVICE_TYPE_CODE for service type classification.
  • PA_OPER_UNITS_IT: Joined via ORG_ID for operating unit context.