Search Results oki_perf_measures_s1

Overview

The OKI_LOAD_OKV_PVT package body in the APPS schema is a private (PVT) PL/SQL program unit within the Oracle E-Business Suite Order Capture / Service Contracts foundation (OKI) module. Its primary business function is to load and populate performance measurement data — commonly known as OKV (Order/Contract Value) performance measures — into the ETRM (Enterprise Territory and Resource Management) data model. The "LOAD" prefix indicates the package performs bulk insert and refresh operations against the OKI performance measure tables, typically as part of a data collection or staging cycle that feeds downstream analytics, reporting, and territory assignment calculations.

As a PVT classified package, it is intended for internal consumption by other OKI packages — most notably OKI_REFRESH_PVT, which invokes it during refresh cycles — rather than being called directly by external or customizations. The package is currently VALID in the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The ETRM metadata documents a single exposed procedure within the package body:

• CREATE_PERF_MEASURES — The core routine responsible for constructing and loading performance measure records into the OKI_PERF_MEASURES table. It gathers source data from operation instances/lines and sales order headers, applies currency and period conversion logic, and inserts the resulting measure rows. Because the metadata does not expose a formal parameter list, the exact signature is not documented here; it is invoked internally by the refresh framework.

Tables Accessed

The package references the following objects (through APPS synonyms), each serving a distinct role in the load process:

• OKI_PERF_MEASURES — The principal target table; receives the newly created performance measure rows.
• OKI_PERF_MEASURES_S1 — A secondary table (or sequence-backed staging/index structure) associated with the performance measures set. This is the object named in the originating search and directly engages the load logic.
• OKC_CLASS_OPERATIONS, OKC_OPERATION_INSTANCES, OKC_OPERATION_LINES — Contract/order operation data that provides the source transactions from which performance measures are derived.
• OKI_SALES_K_HDRS — Sales order key headers supplying order-level context.
• GL_PERIODS and FND_CURRENCIES — Period and currency reference data used to align measures to accounting periods and convert amounts.
• FND_LOOKUPS — Lookup code validation.
• DUAL — Standard single-row utility access.

Usage Notes

OKI_LOAD_OKV_PVT is a private implementation package. It is not referenced by any database object outside its own package boundary and is therefore not exposed for direct use by forms, concurrent programs, or custom code. It is invoked indirectly through OKI_REFRESH_PVT, which orchestrates ETRM data refresh and calls CREATE_PERF_MEASURES to regenerate performance measures. Its supporting calls to FND_FILE, FND_MESSAGE, FND_GLOBAL, and FND_PROFILE indicate that it participates in concurrent-program style execution, producing log/output via FND_FILE and resolving environment context (organization, user, responsibility) through FND_GLOBAL and FND_PROFILE.

Consultants troubleshooting the OKI_PERF_MEASURES_S1 reference should recognize this object as an internal dependency of the performance measure load logic. Direct invocation is unsupported; any customizations should target the public refresh entry points rather than this PVT package body.