Search Results link_oks_header




Overview
Explore in AI Chat

Overview

OKL_UBB_INTEGRATION_PVT is a private PL/SQL package in the APPS schema that supports the integration between Oracle Lease and Finance Management (OKL) and Oracle Service Contracts (OKC) for Usage-Based Billing (UBB) contracts. In Oracle E-Business Suite Release 12.1.1 and 12.2.2, lease agreements often include service or usage components that must be represented as service contracts so that meters, counters, and usage-based pricing rules are administered through the Service Contracts framework. This package encapsulates the internal logic required to create the corresponding service contract and to establish the links between the lease contract structures and their service contract counterparts.

The package is classified as a private (PVT) API. This means it is not intended to be called directly by external consumers; it exists as the implementation layer behind the public API OKL_UBB_INTEGRATION_PUB, which is the documented caller of this package. The package body is marked VALID, confirming that all PL/SQL references compile successfully against the dependent objects.

Key Procedures and Functions

The documented package exposes three procedures, all oriented toward building the UBB contract representation inside Service Contracts:

  • CREATE_UBB_CONTRACT — Creates the service contract that represents the usage-based billing portion of the lease. This is the primary entry point and orchestrates the population of contract headers, lines, rules, and related Service Contracts entities.
  • LINK_OKS_HEADER — Establishes the association between the lease contract header and the corresponding OKC service contract header, ensuring the two records remain synchronized for downstream billing and reconciliation.
  • LINK_OKS_LINE — Establishes the association at the line level, linking lease contract lines to their corresponding service contract lines. This relationship is essential for accurate usage capture and pricing of individual leased items or services.

Tables Accessed

The package reads and writes an extensive set of Service Contracts and lease-related tables, accessed through APPS synonyms. The Service Contracts tables include OKC_K_HEADERS_B and OKC_K_LINES_B (contract header and line base tables), OKC_K_ITEMS, OKC_K_PARTY_ROLES_B, OKC_CLASS_OPERATIONS, OKC_PROCESS_DEFS_B, OKC_STATUSES_B, OKC_RULE_GROUPS_B, OKC_RULES_B, and OKC_LINE_STYLES_B (line styling attributes). These provide the structural components used when the UBB contract is assembled.

Usage and counter data come from CSI_COUNTERS_B, CS_COUNTERS, and CS_COUNTER_GROUPS, which underpin meter and counter definitions. Item information is sourced from MTL_SYSTEM_ITEMS. Pricing logic for usage tiers is drawn from RA_RULES. The dependency listing also confirms references to OKC_K_HEADERS_V and OKC_K_LINES_V, the contract header and line views used for validation or querying. The package depends on OKC_API and OKL_API for the sanctioned insert and update operations on contract structures, ensuring that business rules and validation logic are not bypassed.

Usage Notes

OKL_UBB_INTEGRATION_PVT is invoked indirectly through the public wrapper OKL_UBB_INTEGRATION_PUB, typically during lease authoring or booking flows when a usage-based billing arrangement must be mirrored into Service Contracts. Standard end-user touchpoints include the Lease Management forms, where contract creation triggers the public API, which in turn delegates to this private package. Because the package is private and subject to change without notice, customizations should invoke the public API rather than call these procedures directly. Any extension work should preserve the dependency on OKC_API and OKL_API so that Service Contracts validation and lease business rules continue to apply.