Search Results oki_perf_measures_u2




Overview
Explore in AI Chat

Overview

The OKI.OKI_PERF_MEASURES table is a Contracts Intelligence (OKI) repository object in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Key Performance Indicator (KPI) values for contracts, aggregated by accounting period and by the operating unit in which the contract was authored. The table is populated and maintained exclusively by the Load Performance Measures, Contracts Intelligence concurrent manager job; it is not a transactional entry table, and no forms or concurrent programs write to it outside that program. Its physical home is the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes reside in APPS_TS_TX_IDX.

The ETRM metadata classifies this object heuristically as standalone in Data Vault terms. Under that reading, it is best modeled as a satellite-style table: the KPI measurement is the descriptive payload, and its natural business key is the composite of period, period set, authoring organization, KPI code, and sub-class (SCS) code. There is no hub-and-link chain through this table; its only foreign key targets the security framework rather than another domain entity.

Key Information Stored

The table documents 14 columns. The most significant are:

  • ID — the surrogate primary key (OKI_PERF_MEASURES_PK), also carried by unique index OKI_PERF_MEASURES_U2. The internal identifier for the row.
  • PERIOD_NAME, PERIOD_SET_NAME, PERIOD_TYPE — the General Ledger period name, the GL period set used to validate periods, and the GL period type, respectively.
  • AUTHORING_ORG_ID — the operating unit ID in which the contract was authored. This is the column most often implicated in the search term authoring_org_name, since the numeric ID is the filtered key while the name is denormalized alongside it.
  • AUTHORING_ORG_NAME — a VARCHAR2(240) display name of that operating unit, stored directly on the row so that KPI reporting does not require a join to the operating unit definition.
  • KPI_CODE — the code identifying which Key Performance Indicator the row measures.
  • KPI_VALUE — the numeric value of that indicator for the given period, organization, and contract sub-class.
  • SCS_CODE — the contract sub-class (category) code, the fifth element of the business key.
  • SECURITY_GROUP_ID — used for application hosting; this is the only documented foreign key, referencing FND_SECURITY_GROUPS.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard Concurrent Manager audit columns identifying the load run.

Unique index OKI_PERF_MEASURES_U1 spans (PERIOD_NAME, PERIOD_SET_NAME, AUTHORING_ORG_ID, KPI_CODE, SCS_CODE) and is the documented business-key candidate; it guarantees one measurement per period, organization, indicator, and contract sub-class.

Common Use Cases and Queries

Typical consumption is reporting on contract performance across periods and operating units. Because the unique index leads with PERIOD_NAME and includes AUTHORING_ORG_ID, period- and organization-driven queries are well supported:

  • KPI trend by operating unit — filter on AUTHORING_ORG_ID or AUTHORING_ORG_NAME and PERIOD_NAME, ordering by period to produce a time series per KPI_CODE.
  • Period-over-period comparison — self-join or aggregate on KPI_VALUE grouped by PERIOD_NAME, KPI_CODE, and SCS_CODE.
  • Load reconciliation — group by REQUEST_ID and PROGRAM_UPDATE_DATE to confirm which performance-measure load produced a given set of rows.

A representative query selects PERIOD_NAME, AUTHORING_ORG_NAME, KPI_CODE, KPI_VALUE from OKI.OKI_PERF_MEASURES where PERIOD_SET_NAME and PERIOD_NAME match the reporting calendar and SCS_CODE restricts the contract category of interest.

Related Objects

  • FND_SECURITY_GROUPS — referenced by OKI_PERF_MEASURES.SECURITY_GROUP_ID; the application-hosting boundary for the stored rows.
  • OKI_PERF_MEASURES_PK and OKI_PERF_MEASURES_U1/U2 — the primary and unique access paths used by the concurrent load and by reporting queries.
  • Load Performance Measures, Contracts Intelligence — the concurrent program that is the sole writer of this table, identifiable through PROGRAM_ID and PROGRAM_APPLICATION_ID.
  • GL period definitions (PERIOD_NAME, PERIOD_SET_NAME, PERIOD_TYPE) — the General Ledger calendar providing the validity context for the period columns.
  • Operating unit / organization definitions — the source of AUTHORING_ORG_ID and the denormalized AUTHORING_ORG_NAME.
  • OKI contract KPI and sub-class definitions — the reference data behind KPI_CODE and SCS_CODE.