Search Results oks_coverage_templts_v

Overview

The APPS.OKS_COVERAGE_TEMPLTS_V view is a Service Contracts (OKS) reporting object that exposes a consolidated list of coverage templates available within Oracle E-Business Suite 12.1.1 and 12.2.2. Coverage templates in Oracle Service Contracts serve as reusable definitions of the entitlement terms that can be applied to contract lines, and this view flattens those definitions into a single queryable structure suitable for reporting, integration, and validation purposes. The view is owned by the APPS schema and holds VALID status, making it safe to reference directly from custom reports, concurrent programs, Oracle Discoverer worksheets, and inbound/outbound interface logic. Its principal value lies in abstracting the underlying contract line storage model, which is normalized across base tables and translation tables, into a de-normalized result set that distinguishes service, warranty, usage, and subscription coverage template types through a derived ITEM_TYPE column.

Underlying Base Objects

The documented metadata identifies three referenced objects: the synonyms OKC_K_LINES_B and OKC_K_LINES_TL, which resolve to the Contract Core base tables OKC_K_LINES_B (the transactional line table) and OKC_K_LINES_TL (its translation table), and the view OKS_SUBSCR_HEADER_V. The view is constructed as a UNION of two branches. The first branch joins OKC_K_LINES_B to OKC_K_LINES_TL on the line ID, filtering on CHR_ID < 0 to isolate template records (as opposed to actual contract lines) and restricting LSE_ID to the values 2, 15, 65, and 66. It restricts translations to the session language via USERENV('LANG'). The second branch supplies subscription coverage templates from OKS_SUBSCR_HEADER_V, projecting NULL placeholders into columns that are not applicable to subscriptions. The join to the translation table ensures that NAME and ITEM_DESCRIPTION are returned in the user's current language.

Key Columns

• ID – Identifier of the coverage template record, sourced from OKC_K_LINES_B.ID.
• LSE_ID – Internal line-set/entitlement identifier that drives the derived item type; values 2, 15, and 66 map to service, warranty, and usage respectively.
• ITEM_TYPE – Derived via DECODE over LSE_ID, yielding 'SERVICE', 'WARRANTY', 'USAGE', or 'SUBSCRIPTION'. This is the primary discriminatory column for filtering templates.
• NAME / DESCRIPTION – Translated template name and item description from OKC_K_LINES_TL (or directly from the subscription header view).
• START_DATE / END_DATE – Effective date boundaries for the template.
• WARRANTY_YN – Flag derived as 'Y' when LSE_ID equals 15, otherwise 'N'.
• EXCEPTION_YN – Indicates whether the template is an exception record.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – Descriptive flexfield columns carrying template-specific extensibility data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

Typical uses include populating LOVs for coverage template selection, validating that a requested template exists and is of the correct type, and feeding external entitlement systems. A representative query for warranty templates only is:

• SELECT id, name, description, start_date, end_date FROM oks_coverage_templts_v WHERE item_type = 'WARRANTY' ORDER BY name;
• SELECT item_type, COUNT(*) FROM oks_coverage_templts_v GROUP BY item_type;
• SELECT t.id, t.name, t.description FROM oks_coverage_templts_v t WHERE t.item_type = 'SERVICE' AND t.warranty_yn = 'N' AND SYSDATE BETWEEN NVL(t.start_date, SYSDATE) AND NVL(t.end_date, SYSDATE);

Because the view references USERENV('LANG'), custom code that joins it to multilingual data or executes it under a locale other than the session default should account for language-specific name resolution. As with any APPS-owned view, direct DML is not supported; templates must be maintained through the Service Contracts authoring forms or supported APIs.