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:
- TOP_TASK_ID — Primary key uniquely identifying each top-level task record.
- PROJECT_ID — Foreign key to PA_PROJECTS_IT_ALL, linking the top task to its owning project.
- TASK_NUMBER and TASK_NAME — User-facing identifiers and descriptive labels for the top task.
- CARRYING_OUT_ORGANIZATION_ID — Foreign key to PA_PRJ_ORGS_IT, identifying the organization responsible for executing the task.
- SERVICE_TYPE_CODE — Classifies the type of service associated with the task.
- DESCRIPTION — Free-text narrative describing the task.
- STATUS_CODE — Indicates the lifecycle state of the top task record.
- USER_COL1 through USER_COL10 — Ten extensible attribute columns for customer-specific data capture.
- LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATED_BY, CREATED_BY, and LAST_UPDATE_LOGIN — Standard EBS audit and concurrency columns.
- REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE — Concurrent program context identifying the process that last modified the row.
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:
- SELECT t.TOP_TASK_ID, t.TASK_NUMBER, t.TASK_NAME, p.PROJECT_NAME FROM PA_TOP_TASKS_IT t, PA_PROJECTS_IT_ALL p WHERE t.PROJECT_ID = p.PROJECT_ID AND t.STATUS_CODE = 'ACTIVE';
- Aggregating task activity cost comments from PA_TSK_ACT_CMT_IT_ALL using TASK_ID joins.
- Feeding budgetary control balances in PA_BC_BALANCES and PA_BC_PACKETS through TOP_TASK_ID.
- Supporting Grants Management (GMS) budgetary control and balance reporting via GMS_BUDGETARY_CONTROLS and GMS_BALANCES.
- Driving forecast and planning resource calculations through PA_FP_PLANNING_RES_TMP1_1 and PA_FP_RES_ASSIGNMENTS_TMP.
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.
-
Information about the top task level for Oracle Project Analysis Collection Pack
-
Information about the top task level for Oracle Project Analysis Collection Pack
-
TABLE: PA.PA_TOP_TASKS_IT 12.2.2
-
TABLE: PA.PA_TOP_TASKS_IT 12.1.1
-
VIEW: PA.PA_TOP_TASKS_IT# 12.2.2
-
VIEW: PA.PA_TOP_TASKS_IT# 12.2.2
-
PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions
-
Task level actuals and commitments for Oracle Project Analysis Collection Pack
-
Task level budgets for Oracle Project Analysis Collection Pack
-
This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.
-
This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.
-
PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions
-
Budgetary control level for awards, tasks, resource groups, and resources
-
Balance of budgets, actual costs, and encumbrance costs
-
Budgetary control level for awards, tasks, resource groups, and resources
-
Stores audit tasks details for an engagement
-
Service type and task organization history
-
Service type and task organization history
-
Balance of budgets, actual costs, and encumbrance costs
-
PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat
-
PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat
-
Lowest level task information for reporting.
-
Lowest level task information for reporting.
-
Stores the resource assignment level data for internal use of Oracle Projects
-
Stores the resource assignment level data for internal use of Oracle Projects
-
Task level budgets for Oracle Project Analysis Collection Pack
-
Task level actuals and commitments for Oracle Project Analysis Collection Pack
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1