Search Results oke_k_deliverables_uk01

Overview

The OKE_K_DELIVERABLES_B table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary repository for all deliverable information associated with project contracts. A deliverable represents a tangible or intangible product, service, or result that must be provided to fulfill contractual obligations. This table is fundamental for tracking, managing, and billing against contractually mandated outputs, forming a critical link between contract terms, project execution, and revenue recognition.

Key Information Stored

The table's structure is designed to integrate deliverables within the broader contract and project management framework. Its primary key is the system-generated DELIVERABLE_ID. Crucially, each deliverable is tied to a specific contract and line via the K_HEADER_ID and K_LINE_ID foreign keys, respectively. The DELIVERABLE_NUM, combined with the header and line IDs, forms a unique key (OKE_K_DELIVERABLES_UK01) to enforce business-level uniqueness. Other significant foreign key relationships include PROJECT_ID and TASK_ID, linking deliverables to Oracle Projects (PA) work breakdown structures. The SHIPPING_REQUEST_ID column integrates with Oracle Shipping Execution (WSH), connecting contractual deliverables to physical shipments. The SUB_REF_ID column supports hierarchical deliverable structures by self-referencing the table.

Common Use Cases and Queries

This table is central to operational and reporting processes. Common use cases include generating deliverable status reports, triggering billing events upon deliverable acceptance, and managing dependencies between deliverables. A typical query might join this table to contract headers and lines to list all deliverables for a specific contract.

• Sample Query: SELECT d.DELIVERABLE_NUM, d.DESCRIPTION, h.CONTRACT_NUMBER, l.LINE_NUMBER FROM OKE_K_DELIVERABLES_B d, OKE_K_HEADERS h, OKE_K_LINES l WHERE d.K_HEADER_ID = h.K_HEADER_ID AND d.K_LINE_ID = l.K_LINE_ID AND h.CONTRACT_NUMBER = '<CONTRACT_NUM>';
• Reporting often involves checking deliverable completion status against planned dates to identify contractual risks.
• Integration points include automated creation of billing events in OKE_K_BILLING_EVENTS and tracking communications or holds related to specific deliverables.

Related Objects

The OKE_K_DELIVERABLES_B table is a hub for numerous related entities within the Project Contracts schema. Key dependent tables include OKE_K_DELIVERABLES_TL for translated descriptions, OKE_K_BILLING_EVENTS for invoice generation, and OKE_DEPENDENCIES for modeling prerequisite relationships between deliverables. It is referenced by OKE_K_COMMUNICATIONS, OKE_K_FORM_HEADERS, OKE_K_HOLDS, and OKE_K_STANDARD_NOTES_B, illustrating its central role in contract administration. Externally, it maintains critical foreign key relationships with OKE_K_HEADERS, OKE_K_LINES, PA_PROJECTS_ALL, PA_TASKS, and WSH_DELIVERY_DETAILS, enabling end-to-end process integration from contract terms through project execution and fulfillment.