Search Results pa_all_srvc_types_it_pk

Overview

The PA_ALL_SRVC_TYPES_IT table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It serves as the master repository for the top-level entries in the standard service type dimension hierarchy. This table is fundamental to the classification and reporting of service-related activities across project structures. Its primary role is to define the highest-level categories under which more specific service types are organized, enabling consistent categorization, aggregation, and analysis of project work and costs by service type.

Key Information Stored

While the provided metadata does not list individual columns, the documented primary key and foreign key relationships define its critical structure. The table's primary key is the column ALL_SERVICE_TYPES. This column stores the unique identifier for each top-level service type category. As the root of a hierarchy, these records represent broad classifications, such as "Consulting," "Implementation," or "Support." The integrity of this identifier is enforced by the primary key constraint PA_ALL_SRVC_TYPES_IT_PK. The table's design ensures referential integrity for all subordinate service type definitions within the Projects module.

Common Use Cases and Queries

This table is primarily used in master data maintenance, hierarchical reporting, and as a validation source. Administrators reference it when defining or updating the service type hierarchy. A common reporting use case involves rolling up detailed project cost or revenue data from specific service types to these top-level categories for executive summaries. A typical query would join this table to its child detail table to retrieve the full hierarchy.

• Hierarchy Listing: SELECT ast.all_service_types, st.service_type FROM pa_all_srvc_types_it ast, pa_srvc_types_it st WHERE ast.all_service_types = st.all_service_types ORDER BY 1, 2;
• Validation in Data Loads: Scripts for importing project data often validate service type codes against this table to ensure they map to a valid top-level category.
• Aggregate Reporting: Financial reports aggregate amounts from transaction tables by joining through PA_SRVC_TYPES_IT to this table to report at the top service type level.

Related Objects

The table has a direct and critical relationship with the more granular service type detail table, as defined by the documented foreign key.

• PA_SRVC_TYPES_IT: This is the primary related table. It contains the detailed service type records, each of which must belong to a valid top-level category defined in PA_ALL_SRVC_TYPES_IT. The relationship is enforced by the foreign key where PA_SRVC_TYPES_IT.ALL_SERVICE_TYPES references PA_ALL_SRVC_TYPES_IT.ALL_SERVICE_TYPES. This creates a classic parent-child hierarchy for service types.

Consequently, this table is indirectly related to any transactional or planning tables that utilize a SERVICE_TYPE code, as that code will ultimately roll up to a record in PA_ALL_SRVC_TYPES_IT through the PA_SRVC_TYPES_IT table.