Search Results ahl_warranty_entitlements




Overview
Explore in AI Chat

Overview

The AHL_WARRANTY_ENTITLEMENTS table is a core transactional entity within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (CMRO), specifically under the AHL product family. This table serves as the central repository for recording and managing warranty entitlements. Its primary role is to establish a formal link between a service event—such as a work order, a visit task, or a warranty claim—and a specific warranty contract. This linkage is critical for determining whether a particular repair or service activity is covered under warranty, thereby enabling accurate cost accounting, billing, and warranty claim processing within the CMRO lifecycle.

Key Information Stored

The table stores the fundamental relationships that define a warranty entitlement. The primary identifier is the WARRANTY_ENTITLEMENT_ID. The most crucial foreign key columns define the parties involved in the entitlement: the WARRANTY_CONTRACT_ID links to the specific warranty agreement, and the OLD_WARRANTY_CONTRACT_ID may track superseded contracts. The table then links this contract to the actual service execution point via one of several key columns: WORKORDER_ID (for a maintenance work order), VISIT_TASK_ID (for a service task within a customer visit), WARRANTY_CLAIM_ID (for a formal claim), or OSP_ORDER_LINE_ID (for an Outside Processing purchase order line). This structure allows a single warranty contract to be associated with multiple service events over time.

Common Use Cases and Queries

A primary use case is validating warranty coverage during service execution. For instance, when processing a work order, the system queries this table to confirm an active entitlement exists for the work order under a valid warranty contract. This check determines if parts and labor should be billed to the customer or covered under warranty. Common reporting queries involve analyzing warranty utilization, such as listing all service events covered under a specific contract, or identifying all warranty entitlements linked to a particular asset. A typical SQL pattern to find covered work orders for a warranty contract would be:

  • SELECT we.warranty_entitlement_id, wo.workorder_number
  • FROM ahl_warranty_entitlements we, ahl_workorders wo
  • WHERE we.workorder_id = wo.workorder_id
  • AND we.warranty_contract_id = <contract_id>;

Related Objects

The AHL_WARRANTY_ENTITLEMENTS table is a central hub with documented foreign key relationships to several key CMRO tables. Its primary key is enforced by the constraint AHL_WARRANTY_ENTITLEMENTS_PK1. The documented foreign key relationships, as per the provided metadata, are as follows:

  • AHL_WORKORDERS: Linked via the WORKORDER_ID column. This joins an entitlement to a specific maintenance work order.
  • AHL_VISIT_TASKS_B: Linked via the VISIT_TASK_ID column. This joins an entitlement to a specific task performed during a customer visit.
  • AHL_OSP_ORDER_LINES: Linked via the OSP_ORDER_LINE_ID column. This joins an entitlement to an outside processing purchase order line item.
  • Self-Referential for Warranty Contracts: The table references itself for warranty contracts through two columns: WARRANTY_CONTRACT_ID and OLD_WARRANTY_CONTRACT_ID, which typically point to records in a warranty contracts master table (the exact name of which is implied but not explicitly listed in the snippet).
  • Warranty Claims: Linked via the WARRANTY_CLAIM_ID column, connecting the entitlement to a formal warranty claim record.