Search Results psb_ws_submit_service_packages




Overview
Explore in AI Chat

Overview

The table PSB_WS_SUBMIT_SERVICE_PACKAGES is a data object within the Oracle E-Business Suite (EBS) module for Public Sector Budgeting (PSB), which is noted as obsolete in the provided documentation. This table serves a specific transactional role in the budgeting workflow by tracking the submission of service packages for a given budget worksheet. It functions as a junction table, creating a many-to-many relationship between worksheets (PSB_WORKSHEETS) and service packages (PSB_SERVICE_PACKAGES). Its primary purpose is to log which service packages, representing specific budgeting tasks or calculations, have been submitted for processing or inclusion as part of a worksheet's budget data. A critical detail from the metadata is its stated implementation status: "Not implemented in this database," indicating it may be a legacy or placeholder object in the referenced EBS versions (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three columns that uniquely identify each submission record. The WORKSHEET_ID column is a foreign key linking to the PSB_WORKSHEETS table, identifying the specific budget worksheet. The SERVICE_PACKAGE_ID column is a foreign key linking to the PSB_SERVICE_PACKAGES table, identifying the specific budgeting service or calculation package being submitted. The OPERATION_ID column is a third component of the primary key, suggesting the table can differentiate between multiple submission operations or steps for the same worksheet and service package combination. This design allows the system to maintain a history or sequence of submission events.

Common Use Cases and Queries

In a functional PSB environment, this table would be central to auditing and reporting on the budget preparation workflow. Common use cases would include generating a list of all service packages submitted for a particular worksheet to verify completeness, or identifying worksheets awaiting the submission of specific critical service packages. A typical query would join this table to its related master tables to produce a meaningful report. For example:

  • Finding Submitted Packages for a Worksheet: SELECT w.worksheet_name, s.service_package_name FROM psb_ws_submit_service_packages sub JOIN psb_worksheets w ON sub.worksheet_id = w.worksheet_id JOIN psb_service_packages s ON sub.service_package_id = s.service_package_id WHERE w.worksheet_id = :1;
  • Auditing Submission Activity: Queries would leverage the OPERATION_ID to track the progression or different stages of service package submissions over time for a given budget cycle.

Given the "obsolete" status of the module, these operations are likely relevant only for historical data analysis or migration projects in the specified EBS versions.

Related Objects

PSB_WS_SUBMIT_SERVICE_PACKAGES has defined dependencies on two core master tables, as per its foreign key constraints. The table PSB_WORKSHEETS is the parent table for the WORKSHEET_ID foreign key and contains the master definition and header information for budget worksheets. The table PSB_SERVICE_PACKAGES is the parent table for the SERVICE_PACKAGE_ID foreign key and defines the available service packages or budgeting processes within the system. These relationships are fundamental to the table's purpose of linking worksheet instances to the specific service packages submitted against them. No other referencing objects are detailed in the provided metadata.