Search Results oki_load_okv_pvt




Overview
Explore in AI Chat

Overview

OKI_LOAD_OKV_PVT is a private PL/SQL package owned by the APPS schema within Oracle E-Business Suite. It forms part of the Oracle Knowledge Integration (OKI) module, which underpins the Oracle Contract Terms Management (OKC/OKV) and related order-to-cash performance-measurement functionality. In EBS terminology, the PVT suffix classifies the package as private: its procedures are not published as a stable integration API but are called internally by a corresponding public (_PUB) package, in this case OKI_LOAD_OKV_PUB. The package is documented as VALID in both 12.1.1 and 12.2.2, indicating it remains intact and supported across those releases.

The business purpose of the package is the creation and loading of performance measures used by the OKI subsystem to evaluate contract operations and their outcomes. Performance measures are the metrics against which contract operation instances and lines are assessed; the private package therefore plays a supporting role in moving data from transactional contract operation structures into the OKI performance-measure store.

Key Procedures and Functions

ETRM documents a single procedure or function within OKI_LOAD_OKV_PVT:

  • CREATE_PERF_MEASURES — The documented entry point for generating performance measure records. It is responsible for deriving and inserting performance-measure data into the OKI_PERF_MEASURES table. The parameter list is not published in the ETRM metadata and should not be assumed; callers should invoke the public wrapper OKI_LOAD_OKV_PUB rather than calling this procedure directly.

The package body additionally references the OKI_REFRESHS object and the STANDARD package, which is consistent with routine internal utility calls used to refresh measure data and to raise or handle standard PL/SQL conditions. No other public program units are documented for this package.

Tables Accessed

The documented tables referenced through APPS synonyms, and the reasons for their access, are as follows:

  • OKI_PERF_MEASURES and OKI_PERF_MEASURES_S1 — The primary target of CREATE_PERF_MEASURES; the base measure table and its sequence for key generation.
  • OKC_CLASS_OPERATIONS, OKC_OPERATION_INSTANCES, and OKC_OPERATION_LINES — Source contract-operation definitions, runtime instances, and detail lines from which the measures are derived.
  • OKI_SALES_K_HDRS — Sales header information used to qualify or scope the measures being created.
  • GL_PERIODS — The accounting period calendar, used to associate measures with the correct reporting period.
  • FND_CURRENCIES — Currency validation and conversion context for monetary measures.
  • DUAL — Standard single-row selection utility.

Usage Notes

Because OKI_LOAD_OKV_PVT is a private package, it is not intended for direct invocation from forms, concurrent programs, or custom code. The ETRM dependency information shows that it is referenced by OKI_LOAD_OKV_PUB, which serves as the sanctioned public interface; customers and integrators should call the public package instead. Internal callers within the OKI subsystem may invoke CREATE_PERF_MEASURES when performance-measure data must be refreshed or regenerated following changes to contract operations. Customization of this package should be avoided, as it is an Oracle-owned, non-published component whose signature and behaviour may change independently of the public API, and direct modifications risk invalidating the dependency chain between the public and private layers.