Search Results pa_tasks

Overview

The PA_TASKS table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically in releases 12.1.1 and 12.2.2. It serves as the master repository for all user-defined tasks, which are the fundamental subdivisions of work on a project. Every task is associated with a parent project, enabling detailed planning, tracking, costing, billing, and reporting. The table's extensive network of foreign key relationships underscores its central role in integrating project management data with other EBS modules, including Payables, Assets, and Service.

Key Information Stored

The table's primary key is TASK_ID, which uniquely identifies each task. The most critical foreign key is PROJECT_ID, linking the task to its parent project in PA_PROJECTS_ALL. Other essential columns define the task's operational and financial context. These include PARENT_TASK_ID and TOP_TASK_ID for hierarchical task structures, and CARRYING_OUT_ORGANIZATION_ID to designate the executing business unit. Financial control is managed through columns like COST_IND_RATE_SCH_ID, INV_IND_RATE_SCH_ID, and REV_IND_RATE_SCH_ID for indirect cost rates, and LABOR_TP_SCHEDULE_ID or NL_TP_SCHEDULE_ID for transfer price schedules. The WORK_TYPE_ID links to a classification of labor, while ADDRESS_ID can store a customer site for billing purposes.

Common Use Cases and Queries

This table is central to project operational reporting and transactional integrity. Common use cases include generating task hierarchies for work breakdown structures, validating tasks during financial transaction entry (like invoice distributions or expense reports), and assigning specific costing rules at the task level. A fundamental query retrieves all tasks for a given project, often joining with PA_PROJECTS_ALL.

SELECT pt.task_number, pt.task_name, pt.description
FROM pa_tasks pt
WHERE pt.project_id = :p_project_id
ORDER BY pt.task_number;

Another critical pattern involves tracing financial transactions back to their source task, which is essential for project cost analysis and audit trails. This requires joining PA_TASKS to transactional tables like AP_INVOICE_DISTRIBUTIONS_ALL on TASK_ID.

Related Objects

As indicated by the foreign key metadata, PA_TASKS has extensive relationships across the EBS suite. Within Projects, it is the parent table for PA_LABOR_COST_MULTIPLIERS and is linked to PA_IND_RATE_SCHEDULES_ALL_BG and PA_CC_TP_SCHEDULES_BG. Crucially, it is referenced by numerous transactional tables in other products, including AP_INVOICE_DISTRIBUTIONS_ALL, AP_EXPENSE_REPORT_LINES_ALL, and FA_ASSET_INVOICES. This demonstrates that the TASK_ID is a key attribute propagated to financial records for project accounting. The table also has a recursive relationship with itself via PARENT_TASK_ID and TOP_TASK_ID to model task hierarchies.