Search Results okl_service_integration_pvt




Overview
Explore in AI Chat

Overview

OKL_SERVICE_INTEGRATION_PVT is a private PL/SQL package in the APPS schema that supports Oracle Lease and Finance Management (OLFM/ETRM) service contract integration. It is classified as a PVT (private) API package, meaning it is not intended for direct invocation by external consumers; instead it is called by public wrapper packages such as OKL_SERVICE_INTEGRATION_PUB and its _W variants, and by other internal processing packages that must create, link, update, or remove service lines and coverage assets against lease contracts.

The package bridges the lease contract schema (OKL/OKC) and the Oracle Service (CSI) and Trading Community (HZ) schemas. It handles the mechanics of integrating service-oriented line items with lease contract headers and lines, including linking service lines to coverage assets, initiating service bookings, and creating service contracts from Oracle Knowledge Source (OKS) data. Because it is a private package, its procedures are exposed only indirectly, and Oracle documents it primarily through dependency and object metadata rather than as a supported public API.

Key Procedures and Functions

The package exposes 17 documented procedures and functions covering the service integration lifecycle:

Tables Accessed

The package reads and writes through APPS synonyms across several schemas. Contract structures are accessed via OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_REL_OBJS, OKC_CLASS_OPERATIONS, OKC_LINE_STYLES_B, and OKC_STATUSES_B, which provide header, line, relationship, class, style, and status information used to build and validate service lines. OKL_K_LINES supplies lease-specific contract line data. Service and asset data flow through CSI_ITEM_INSTANCES and CSI_TXN_TYPES. Party and location data come from HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES. Inventory item references use MTL_SYSTEM_ITEMS, and workflow parameter handling uses WF_PARAMETER_LIST_T.

Usage Notes

OKL_SERVICE_INTEGRATION_PVT is not a supported entry point for custom code. It is invoked internally by OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_SERVICE_K_INT_WF, OKL_AM_TERMNT_QUOTE_PVT, OKL_CONTRACT_BOOK_PVT, OKL_CONTRACT_LINE_ITEM_PVT, OKL_CONTRACT_TOP_LINE_PVT, OKL_QA_DATA_INTEGRITY, and by the public service integration packages OKL_SERVICE_INTEGRATION_PUB and its _W wrappers. It also references OKC_API, OKL_API, OKL_CONTRACT_PUB, OKL_KLE_PVT, and OKL_OKC_MIGRATION_PVT.

In practice, the package executes during lease contract booking, termination, and quote processing, and during data integrity validation. Customizations and extensions should call OKL_SERVICE_INTEGRATION_PUB or the corresponding public API rather than invoking this private package directly; direct calls bypass the public validation layers and are unsupported across upgrades. The package behaves equivalently in EBS 12.1.1 and 12.2.2, with minor online patching considerations in 12.2.2 that do not alter its interface.