Search Results oks_k_headers_b_pk

Overview

The table OKS_K_HEADERS_B is a core data object within the Oracle E-Business Suite (EBS) Service Contracts module (OKS). It functions as the primary repository for header-level attributes specific to service contracts. This table is integral to the OKS data model, extending the foundational contract header information stored in the shared OKC_K_HEADERS_B table. Its role is to store the business data that uniquely defines a service contract, distinguishing it from other contract types (like sales or procurement) managed within the broader Oracle Contracts suite. The table's status as VALID confirms its active use in both EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The table's structure holds the descriptive and control attributes for a service contract header. While the specific column list is not detailed in the provided metadata, the table's primary key is the ID column, which is enforced by the OKS_K_HEADERS_B_PK constraint. The most critical relational column is CHR_ID, which serves as the foreign key linking each service contract header to its corresponding generic contract header record in the OKC_K_HEADERS_B table. This relationship ensures data integrity and shared functionality across contract types. Typical data stored in this table includes service-specific terms, coverage details, billing plans, and other attributes that govern the lifecycle and execution of a service agreement.

Common Use Cases and Queries

This table is central to any process involving service contract inquiry, reporting, or data extraction. Common use cases include generating contract summaries, analyzing service coverage, and feeding data into custom service management reports. A fundamental query pattern involves joining to the parent OKC_K_HEADERS_B table to retrieve a complete contract header view.

• Basic Header Retrieval: SELECT oks_hdr.* FROM oks_k_headers_b oks_hdr, okc_k_headers_b okc_hdr WHERE oks_hdr.chr_id = okc_hdr.id AND okc_hdr.contract_number = '<CONTRACT_NUM>';
• Reporting on Active Service Contracts: Queries often join OKS_K_HEADERS_B with OKC_K_HEADERS_B (for dates, status) and party tables to list contracts by customer, date range, or status.
• Data Migration/Integration: The table is a key target for loading service contract data during implementations or integrations from legacy systems.

Related Objects

OKS_K_HEADERS_B exists within a tightly coupled hierarchy of Service Contracts tables. Its primary relationship is defined by its foreign key dependency on the shared contracts table.

• OKC_K_HEADERS_B: The parent table, providing the core contract header identifier (ID) and generic attributes like dates, status, and party information via the CHR_ID foreign key.
• OKS_K_LINES_B: The key child table, storing the individual service lines (coverages, deliverables) that are associated with a contract header.
• Service Contracts APIs: Oracle provides standard PL/SQL APIs (e.g., within OKS_<package>) for creating and modifying service contracts, which programmatically validate and write data to this table and its dependencies.
• Key Views: Application user interfaces typically query views based on this table, such as OKS_K_HEADERS_V, which present a denormalized, user-friendly representation of the header data.