Search Results xdp_service_pkg_det




Overview
Explore in AI Chat

Overview

The XDP_SERVICE_PKG_DET table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a junction or intersection table, establishing a many-to-many relationship between service packages and individual services. Its primary role is to define the composition of a service package by detailing which specific services are included within it. While the official ETRM documentation states "Not used," this is a common placeholder for objects that are integral to the application's internal data model but are not intended for direct, end-user transactional interfaces. The table's structure, primary key, and foreign key constraints confirm its active role in maintaining referential integrity between the master service package and service entities.

Key Information Stored

The table's structure is minimal, focusing solely on the relationship it manages. The two key columns form a composite primary key. The PACKAGE_ID column stores the unique identifier for a service package, linking to the XDP_SERVICE_PACKAGES table. The SERVICE_ID column stores the unique identifier for a provisioning service, linking to the XDP_SERVICES table. Together, each unique combination of PACKAGE_ID and SERVICE_ID represents a single service included in a specific package. The table does not typically store descriptive or transactional data; its purpose is purely relational.

Common Use Cases and Queries

This table is central to queries that need to list the contents of service packages or identify which packages include a particular service. Common operational and reporting scenarios include generating a bill of materials for a service package, validating service assignments, and auditing package configurations. A typical query would join XDP_SERVICE_PKG_DET with the descriptive tables for packages and services.

Sample SQL to retrieve all services within a package:

  • SELECT s.SERVICE_CODE, s.SERVICE_NAME
  • FROM XDP_SERVICES s, XDP_SERVICE_PKG_DET d
  • WHERE d.PACKAGE_ID = :p_package_id
  • AND d.SERVICE_ID = s.SERVICE_ID;

Another common pattern is to find all packages containing a specific service by joining on SERVICE_ID and XDP_SERVICE_PACKAGES.

Related Objects

XDP_SERVICE_PKG_DET is a nexus between several key Provisioning tables. Its primary foreign key relationships are with XDP_SERVICE_PACKAGES (master list of packages) and XDP_SERVICES (master list of available services). Furthermore, it has a direct relationship with the XDP_SERVICE_PKG_DET_TL table, which is its Translated Table counterpart. The _TL table stores multilingual descriptions for the package-service relationship, allowing the association to be presented in different languages. Any custom reporting or data extraction involving service package composition will invariably involve joining through this intersection table.