Search Results bill_types_migrate




Overview
Explore in AI Chat

Overview

The APPS.OKS_COVERAGES_MIGRATION package is a legacy data migration utility within the Oracle E-Business Suite Service (OKS) and Contracts (OKC) modules. It belongs to the coverage and subscription management functional area, which governs service contracts, warranties, extended warranties, and billed coverage lines in Oracle Service Contracts. The package exists to move legacy coverage, billing, and transactional group data from interface staging tables into the production contract repository during upgrade or implementation projects.

The header declares the package with AUTHID CURRENT_USER, meaning procedures execute with the privileges of the invoking user rather than the package owner. The source header comment ($Header: OKSIMCVS.pls 115.2 2003/02/04) indicates a file that has changed little since the early 11i era, confirming its role as a stable migration-era utility rather than an actively enhanced API. Globally declared PL/SQL tables reference the OKC_*_PVT private APIs (okc_cle_pvt, okc_cim_pvt, okc_rgp_pvt, okc_time_pvt, okc_rul_pvt, okc_cti_pvt, okc_cpl_pvt, okc_ctc_pvt, okc_ril_pvt), and the package initialises migration audit columns with defaults of -1 for the CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN fields. The timezone context is resolved from the profile option CS_UPG_CONTRACTS_TIMEZONE, defaulting to 47 when the profile is null.

Key Procedures and Functions

The package exposes five documented procedures:

  • COVERAGE_MIGRATE — the principal migration routine. It accepts a source range (P_FromId, P_ToId) and a P_VALIDATE_FLAG parameter that drives validation-only execution versus actual data creation. This flag is the element most frequently referenced by implementers and support analysts, since it allows a dry run before committing coverage records.
  • BUSINESS_PROCESSES_MIGRATE — migrates business process definitions associated with coverage data.
  • BILL_TYPES_MIGRATE — migrates billing type records for coverages into the production billing tables.
  • BILL_RATES_MIGRATE — migrates billing rate definitions tied to coverage and billing type combinations.
  • PRINT_REPORT — produces a report of migration results, typically using DBMS_OUTPUT and the PLITBLM utility for formatted output.

Tables Accessed

The package reads staging data from the interface tables OKS_COVERAGES_INT_ALL, OKS_COV_BILL_TYPES_INT_ALL, OKS_COV_BILL_RATES_INT_ALL, OKS_COV_TXN_GROUPS_INT_ALL, OKS_CON_HEADERS_INT_ALL, and OKS_CON_LINES_INT_ALL. These _INT_ALL tables are the standard migration conduits for Oracle Service Contracts and are populated by external extraction scripts or legacy conversion programs. Validated and migrated data is written to the production tables OKC_K_ITEMS and OKC_K_LINES_B, which hold contract line and item details. Reference data is validated against MTL_SYSTEM_ITEMS (inventory items) and CS_CONTRACT_STATUSES (contract lifecycle statuses). Output and diagnostics use the DBMS_OUTPUT and PLITBLM packages.

Usage Notes

OKS_COVERAGES_MIGRATION is not registered as a concurrent program in the standard ETRM 12.1.1 or 12.2.2 application, and it is referenced by zero other packages. It is therefore invoked from custom PL/SQL conversion scripts, SQL*Plus sessions, or bespoke concurrent programs created specifically for a Service Contracts upgrade or data conversion project. Typical invocation calls COVERAGE_MIGRATE first with P_VALIDATE_FLAG set to request validation only; if no errors are raised through the message stack, the caller re-invokes with the flag set to perform the actual insert. Because the package uses AUTHID CURRENT_USER, the executing schema must hold direct privileges on all referenced OKS, OKC, MTL, and CS objects. Given the 2003 vintage of the source header, implementers should treat this package as unsupported legacy code and validate behaviour carefully against the target 12.2.2 schema before use in production migrations.