Search Results pa_work_types_b_pk

Overview

The PA_WORK_TYPES_B table is a core reference table within the Oracle E-Business Suite Projects module (PA). It serves as the master repository for implementation-defined classifications of work performed across an organization's project portfolio. These work types are user-defined categories, such as "Analysis," "Development," "Testing," or "Support," used to categorize and report on project activities. The table stores records in the base language of the installation, with its corresponding translation table, PA_WORK_TYPES_TL, providing multilingual support. Its primary role is to provide a controlled, validated list of work types that can be associated with projects, tasks, assignments, and financial transactions, ensuring consistency in project costing, billing, and resource management.

Key Information Stored

The central column in the table is the WORK_TYPE_ID, which serves as the unique primary key (PA_WORK_TYPES_B_PK) for all work type definitions. While the specific descriptive columns are not detailed in the provided metadata, standard Oracle EBS practice dictates the presence of columns for a work type code (e.g., WORK_TYPE_CODE) and a name. Critically, the table includes foreign key relationships to two utilization categories via ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID, linking to the PA_UTIL_CATEGORIES_B table. This linkage allows work types to be mapped to specific utilization categories for reporting on organizational and resource utilization. Standard Oracle Application Object Library columns, such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, are also present for auditing.

Common Use Cases and Queries

This table is fundamental for setting up and reporting on project work. Administrators use it to define the valid list of work types during implementation. Common reporting and validation queries involve joining this table to transactional data. For instance, to list all projects with their associated work type, one would query PA_PROJECTS_ALL joined to PA_WORK_TYPES_B. A critical use case is analyzing expenditure items or cost distribution lines by work type for detailed cost accounting. A sample query to report expenditures by work type would be:

• SELECT wt.WORK_TYPE_CODE, SUM(ei.raw_cost) FROM pa_expenditure_items_all ei, pa_work_types_b wt WHERE ei.work_type_id = wt.work_type_id GROUP BY wt.WORK_TYPE_CODE;

Work types are also essential for resource management and forecasting within Oracle Project Resource Management (PJI).

Related Objects

As indicated by its extensive foreign key relationships, PA_WORK_TYPES_B is a heavily referenced master table. Key related objects include the translation table PA_WORK_TYPES_TL and the utilization category master PA_UTIL_CATEGORIES_B. Major transactional tables that reference WORK_TYPE_ID include PA_EXPENDITURE_ITEMS_ALL (capturing costs), PA_COST_DISTRIBUTION_LINES_ALL (recording accounting distributions), and PA_PROJECT_ASSIGNMENTS (for resources). Project definition tables like PA_PROJECTS_ALL and PA_TASKS can also store a default work type. Furthermore, it is integral to the Project Resource Management schema, linking to PJI_RM_RES_WT_F and PJI_RM_WORK_TYPE_INFO for resource planning and utilization analytics.