Search Results pa_tsk_bgt_lines_it_all




Overview
Explore in AI Chat

Overview

The PA_TSK_BGT_LINES_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 functions as the primary storage entity for task-level budget line details, serving the Oracle Project Analysis Collection Pack. This pack is integral to the business intelligence and analytical reporting infrastructure for project financials. The table's role is to capture granular budget data at the task level, enabling detailed variance analysis, performance tracking, and cost control against planned budgets. Its "ALL" suffix indicates it is a multi-organization table designed to store data across all operating units, with data segregation typically enforced by the ORG_ID column.

Key Information Stored

The table's primary key, TASK_BUDGET_LINE_KEY, uniquely identifies each budget line record. The data model centers on linking budget amounts to specific project tasks, resources, time periods, and budget classifications. Key foreign key columns define these critical relationships: TASK_ID links to the project task (PA_TOP_TASKS_IT), PA_PERIOD_KEY links to the accounting period (PA_PERIODS_IT), and RESOURCE_LIST_MEMBER_ID links to the specific resource (PA_LOWEST_RLMEM_IT). Further classification is provided by BUDGET_TYPE_CODE (e.g., original, current), EXPENDITURE_TYPE, and SERVICE_TYPE_CODE. The OWNER_ORGANIZATION_ID denotes the project organization responsible for the budget, while ORG_ID specifies the operating unit for multi-org security. The table stores the associated budgeted quantities and amounts for these defined dimensions.

Common Use Cases and Queries

This table is fundamental for generating task-level budget versus actual (BVA) reports and conducting detailed project cost analysis. Common operational and reporting scenarios include analyzing budget consumption for a specific task, drilling down into budget details by resource or expenditure type, and aggregating budget data for project-level summaries. A typical analytical query would join this fact table to its associated dimension tables to produce a readable report.

Sample Query Pattern:

  • SELECT t.task_number, p.period_name, r.resource_name, b.budget_type_name, tsk.budget_quantity, tsk.budget_amount
  • FROM pa_tsk_bgt_lines_it_all tsk
  • JOIN pa_top_tasks_it t ON tsk.task_id = t.task_id
  • JOIN pa_periods_it p ON tsk.pa_period_key = p.pa_period_key
  • JOIN pa_lowest_rlmem_it r ON tsk.resource_list_member_id = r.resource_list_member_id
  • JOIN pa_bgt_types_it b ON tsk.budget_type_code = b.budget_type_code
  • WHERE tsk.org_id = :p_org_id AND tsk.pa_period_key = :p_period_key;

Related Objects

The PA_TSK_BGT_LINES_IT_ALL table maintains defined foreign key relationships with several dimension tables in the Project Analysis Collection Pack schema, as documented in the ETRM. These relationships are essential for accurate reporting and data integrity.

  • PA_TOP_TASKS_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.TASK_ID. Provides task hierarchy and descriptive information.
  • PA_PERIODS_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.PA_PERIOD_KEY. Provides time dimension data for period-based analysis.
  • PA_LOWEST_RLMEM_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.RESOURCE_LIST_MEMBER_ID. Provides detailed resource information.
  • PA_BGT_TYPES_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.BUDGET_TYPE_CODE. Defines the classification of the budget (e.g., original, current).
  • PA_PRJ_ORGS_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.OWNER_ORGANIZATION_ID. Identifies the project organization owning the budget.
  • PA_EXP_TYPES_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.EXPENDITURE_TYPE. Classifies the type of expenditure.
  • PA_SRVC_TYPES_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.SERVICE_TYPE_CODE. Classifies the type of service.
  • PA_OPER_UNITS_IT: Joined via PA_TSK_BGT_LINES_IT_ALL.ORG_ID. Defines the operating unit context for multi-org reporting.