Search Results psb_service_packages_pk

Overview

The PSB_SERVICE_PACKAGES table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module. It serves as the master repository for service package definitions. In the context of public sector budgeting, a service package represents a logical grouping of budget items, activities, or cost centers that are managed and reported on as a single unit for planning, execution, and analysis purposes. This table is fundamental to the PSB module's functionality, enabling structured budget formulation, worksheet management, and the submission of budget proposals. Its role is to provide a centralized definition that can be consistently referenced across various budgeting processes and transactional tables.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define its critical structure. The central identifier is the SERVICE_PACKAGE_ID, which is the primary key (PSB_SERVICE_PACKAGES_PK) and uniquely identifies each service package definition. Another significant column is GLOBAL_WORKSHEET_ID, which establishes a link to the PSB_WORKSHEETS table. This foreign key relationship indicates that a service package is associated with a specific global budget worksheet, anchoring the package within the broader budget development cycle. The table likely contains additional descriptive columns such as a name, description, status, creation date, and other attributes that define the package's properties and lifecycle.

Common Use Cases and Queries

A primary use case is the retrieval of all service packages linked to a specific budget worksheet for review or reporting. For instance, a budget analyst might run a query to list all packages within an active worksheet. Another critical scenario involves tracing transactional details back to their package definition for audit or reconciliation, using the SERVICE_PACKAGE_ID as the link. Common SQL patterns include joining to related transactional tables like PSB_WS_ACCOUNT_LINES to aggregate budget amounts by service package. A typical reporting query might be:

• SELECT sp.SERVICE_PACKAGE_ID, sp.PACKAGE_NAME, w.WORKSHEET_NAME FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w WHERE sp.GLOBAL_WORKSHEET_ID = w.WORKSHEET_ID AND w.STATUS = 'ACTIVE';

This object is also central during the budget submission process, as indicated by its relationship with the PSB_WS_SUBMIT_SERVICE_PACKAGES table.

Related Objects

The PSB_SERVICE_PACKAGES table is integral to a network of related objects within the PSB schema. As per the metadata, it has direct foreign key relationships with three key tables:

• PSB_WORKSHEETS: Linked via GLOBAL_WORKSHEET_ID, this defines the parent worksheet context for the service package.
• PSB_WS_ACCOUNT_LINES: This transactional table holds detailed budget line items, which are categorized under a specific service package via the SERVICE_PACKAGE_ID foreign key.
• PSB_WS_SUBMIT_SERVICE_PACKAGES: This table manages the submission status and details for service packages, also linked by SERVICE_PACKAGE_ID.

These relationships position PSB_SERVICE_PACKAGES as a master definition table that is referenced by downstream transactional and process-specific tables in the budgeting workflow.