Search Results oks_k_lines

Overview

The APPS.OKS_COVERAGE_MIGRATION package body is a Service Contracts (OKS) data migration utility responsible for converting legacy Oracle Contracts (OKC) rule and line structures into the Service Contracts coverage model. Prior to the extended coverage and reaction-time framework, warranty, service, and subscription entitlements were stored as rule-information records attached to contract lines in the OKC schema. The coverage migration package reads these legacy OKC rule groups, rules, and contract lines and creates the corresponding OKS coverage records, bill types, business processes, coverage times, and reaction intervals that the Service Contracts application expects.

The package header carries the identifier $Header: OKSCOVMB.pls 120.0 2005/25/05, indicating it is an older, noship utility file retained for upgrade and internal migration purposes. It is not a public API and is not referenced by any other package in the EBS schema, confirming its role as a standalone one-time conversion program rather than a reusable service component.

Key Procedures and Functions

The package exposes twelve documented procedures, organized into current-data migrations and their corresponding history-table migrations:

• COVERAGE_MIGRATION — The core conversion routine. It declares a cursor over OKC_K_LINES_B, OKC_RULE_GROUPS_B, and OKC_RULES_B, selecting line-level and rule-information columns for lines whose LSE_ID falls within the coverage-related line-style values and which have no existing row in OKS_K_LINES_B. It supports rowid-range processing via start and end rowids and returns a status and message payload.
• BILL_TYPES_MIGRATION and BILL_TYPE_HIST_MIGRATION — Populate bill-type coverage data and the corresponding history records.
• BUSINESS_PROCESS_MIGRATION and BUSS_PROC_HISTORY_MIGRATION — Convert legacy business-process rule information into the OKS business-process coverage model, current and historical.
• COVERAGE_TIMES_MIGRATION and COV_TIMES_HISTORY_MIGRATION — Migrate coverage time definitions and their audit history.
• REACTION_TIME_MIGRATION, REACTION_TIMEVALUES_MIGRATION, REACTION_TIME_HIST_MIGRATION, and REACT_TIMEVAL_HIST_MIGRATION — Convert reaction intervals and their associated time values into the OKS reaction-time framework, including history rows.
• COVERAGE_HISTORY_MIGRATION — Migrates historical coverage rows independently of the current-data routines.

Each procedure accepts rowid boundaries where applicable, enabling the caller to partition the conversion into manageable batches.

Tables Accessed

Source data is read from the OKC contract schema: OKC_K_LINES_B (contract lines), OKC_RULE_GROUPS_B (rule group headers), OKC_RULES_B (rule-information details), OKC_COVER_TIMES and OKC_TIMEVALUES_B (coverage timing), and OKC_REACT_INTERVALS (reaction intervals). Historical source rows are drawn from the _BH and _TLH variants, including OKC_K_LINES_BH, OKC_RULES_BH, OKC_RULES_TLH, OKC_RULE_GROUPS_BH, OKC_TIMEVALUES_BH, OKC_REACT_INTERVALS_H, and OKC_COVER_TIMES_H. Target records are inserted into OKS_K_LINES_B, OKS_K_LINES_TLH, and OKS_ACTION_TIMES. The NOT EXISTS predicate against OKS_K_LINES_B prevents duplicate coverage creation on re-run.

Usage Notes

This package is invoked during upgrade or data-conversion projects, typically from a concurrent program or a controlled SQL*Plus script executed by a DBA, rather than from an application form. Because it is neither referenced by other packages nor exposed as a public API, it should not be called from custom application code. Deployments should run the migration in rowid-range batches during a maintenance window, verify row counts between OKC source and OKS target tables, and retain the return status and message output for audit purposes. In Oracle EBS 12.1.1 and 12.2.2 the object remains present in the APPS schema with the same signature set.