Results for “pa_top_tasks_it”

50+ results




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

Overview

PA_TOP_TASKS_IT is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores information about the top task level for the Oracle Project Analysis Collection Pack. It is maintained in the PA schema and holds 27 documented columns, with a current status of VALID. The table functions as a denormalized reference for the highest-level task within a project hierarchy, providing the anchor point for task-level analysis, budgetary control, and collection-pack processing.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite attached to core project and task hubs, rather than functioning as an independent hub or associative link. Designers modeling the PA schema should treat TOP_TASK_ID as the primary key serving as a unique business identifier within this satellite context.

Key Information Stored

The table's structure is anchored by the surrogate primary key TOP_TASK_ID, which is also enforced as a unique index (PA_TOP_TASKS_IT_U1) and therefore represents the primary business-key candidate. The most significant descriptive and relational columns include:

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving all top tasks for a project, joining to project master data, and isolating task-level budget activity. A common query pattern joins to PA_PROJECTS_IT_ALL on PROJECT_ID:

Related Objects

The table participates in a dense web of referential relationships. The most significant dependent and referenced objects include:

  • PA_PROJECTS_IT_ALL — Referenced via PROJECT_ID; the project master.
  • PA_PRJ_ORGS_IT — Referenced via CARRYING_OUT_ORGANIZATION_ID; organizational context.
  • PA_TSK_ACT_CMT_IT_ALL and PA_TSK_BGT_LINES_IT_ALL — Reference TASK_ID for activity comments and budget lines.
  • PA_BC_PACKETS and PA_BC_BALANCES — Reference TOP_TASK_ID for budgetary control processing.
  • GMS_BUDGETARY_CONTROLS and GMS_BALANCES — Grants Management integration via TOP_TASK_ID.
  • PA_TASK_HISTORY — Tracks historical changes referencing TOP_TASK_ID.
  • PA_LOWEST_TASKS_IT — Lowest-task counterpart referencing TOP_TASK_ID.
  • PA_FP_PLANNING_RES_TMP1_1, PA_FP_RES_ASSIGNMENTS_TMP, and PA_FP_CALC_AMT_TMP1_1 — Forecast planning temporary structures keyed by TOP_TASK_ID.