Search Results ahl_warranty_cont_ctr_b




Overview
Explore in AI Chat

Overview

The table AHL_WARRANTY_CONT_CTR_B belongs to the AHL schema, which supports the Oracle Complex Maintenance Repair and Overhaul (CMRO) application in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a core transactional table that associates warranty contracts with specific counters, thereby defining the coverage scope of a warranty agreement against measurable usage units such as operating hours, cycles, or mileage. Each row represents a distinct warranty-contract-to-counter relationship, including the threshold and starting values that govern when warranty entitlement applies or expires.

Based on the foreign key structure documented in the ETRM metadata, this object exhibits characteristics of a satellite-leaning entity within a Data Vault modeling approach. It carries descriptive attributes (thresholds, start values, expiration dates) tied to the business keys formed by the combination of warranty contract and counter, rather than acting as a pure hub or link. The primary key is a surrogate identifier, with unique indexes providing the natural business-key candidates.

Key Information Stored

The table contains 29 documented columns. The most significant are as follows:

The unique index AHL_WARRANTY_CONT_CTR_B_U1 on WARRANTY_CNTRT_COUNTER_ID reinforces the surrogate key, while AHL_WARRANTY_CONT_CTR_B_U2 enforces at most one active association per warranty contract and counter pair.

Common Use Cases and Queries

Typical usage scenarios include verifying which counters are covered by a given warranty contract, determining whether a counter reading has crossed the warranty threshold, and reporting on warranties nearing expiration. For example, to list counters covered by a contract and their thresholds:

SELECT w.WARRANTY_CONTRACT_ID,
       w.COUNTER_ID,
       w.START_VALUE,
       w.THRESHOLD,
       w.EXPIRATION_DATE
  FROM AHL.AHL_WARRANTY_CONT_CTR_B w
 WHERE w.WARRANTY_CONTRACT_ID = :contract_id;

A common join to resolve counter details uses the foreign key to CSI_COUNTERS_B:

SELECT c.COUNTER_NAME,
       c.COUNTER_UOM,
       w.THRESHOLD,
       w.EXPIRATION_DATE
  FROM AHL.AHL_WARRANTY_CONT_CTR_B w,
       CSI.CSI_COUNTERS_B c
 WHERE w.COUNTER_ID = c.COUNTER_ID
   AND w.WARRANTY_CONTRACT_ID = :contract_id;

Reporting queries frequently filter on EXPIRATION_DATE to identify lapsed coverage, or compare live counter readings against THRESHOLD and START_VALUE to evaluate remaining warranty entitlement.

Related Objects

The following objects are most significant in relation to this table:

  • CSI_COUNTERS_B — referenced via COUNTER_ID; supplies counter definitions and units of measure.
  • AHL_WARRANTY_CONT_CTR_TL — translation table referencing this entity via WARRANTY_CNTRT_COUNTER_ID; stores language-specific descriptive text.
  • AHL_WARRANTY_CONTRACTS (warranty contract header) — parent of WARRANTY_CONTRACT_ID.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for access control.
  • AHL warranty contract APIs — typically operate on this table when creating or modifying warranty coverage.