Results for “adj_mat_version_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_FE_ADJ_MAT_VERSIONS is a core pricing configuration table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The table stores versioned instances of pricing adjustment matrices, which drive the rate and fee adjustments applied to lease and finance contracts during pricing and rate-set generation. Each row represents a single version of an adjustment matrix, allowing the application to maintain effective-dated history and multiple concurrent or superseded definitions without destroying prior pricing logic.

The table operates within the OKL schema and is validated against the ETRM data model. Functionally, it sits between the adjustment matrix header (OKL_FE_ADJ_MAT_ALL_B) and the downstream rate-set version and standard-rate template version tables that consume an adjustment matrix version during pricing calculations. The presence of OBJECT_VERSION_NUMBER, VERSION_NUMBER, EFFECTIVE_FROM_DATE, and EFFECTIVE_TO_DATE confirms that the application enforces optimistic locking and date-driven version resolution.

From a dimensional modeling perspective, ETRM's heuristic Data Vault classification for this object is hub-leaning. In Data Vault terms, OKL_FE_ADJ_MAT_VERSIONS is best modeled as a hub-like entity keyed by its surrogate identifier, with the ADJ_MAT_ID acting as a link to the matrix header hub and the descriptive attributes (status, effective dates, attribute columns) forming a satellite.

Key Information Stored

The table contains 28 documented columns. The most significant are:

  • ADJ_MAT_VERSION_ID — the surrogate primary key (OKL_FE_ADJ_MAT_VERSIONS_PK). It is also exposed through a unique index (OKL_FE_ADJ_MAT_VERSIONS_U1) and serves as the foreign key target for dependent table versions.
  • ADJ_MAT_ID — foreign key to OKL_FE_ADJ_MAT_ALL_B, identifying the parent adjustment matrix header to which this version belongs.
  • VERSION_NUMBER — the human-readable version sequence for the matrix, used in pricing rule resolution.
  • OBJECT_VERSION_NUMBER — supports Oracle EBS optimistic locking (OAF/BC4J concurrency control).
  • STS_CODE — the status of the version (for example, active, draft, or obsolete), governing whether the version may be applied to new pricing.
  • EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE — define the effective-dating window for the version, used to select the correct matrix version for a given transaction date.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS DFF (descriptive flexfield) columns, available for customer-specific extensions in pricing configuration.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns tracking who created and last modified the version.

Common Use Cases and Queries

Typical uses include retrieving the currently active matrix version for a given matrix and date, auditing version history, and diagnosing why a contract received a particular rate adjustment. A common pattern is to join version to header and filter on effective dates and status:

  • SELECT v.ADJ_MAT_VERSION_ID, v.VERSION_NUMBER, v.STS_CODE, v.EFFECTIVE_FROM_DATE, v.EFFECTIVE_TO_DATE FROM OKL.OKL_FE_ADJ_MAT_VERSIONS v WHERE v.ADJ_MAT_ID = :p_adj_mat_id AND TRUNC(SYSDATE) BETWEEN v.EFFECTIVE_FROM_DATE AND NVL(v.EFFECTIVE_TO_DATE, TRUNC(SYSDATE)+1);
  • Version-history reporting: ordering by ADJ_MAT_ID and VERSION_NUMBER to trace how pricing rules evolved.
  • Referential integrity checks: identifying version rows not referenced by OKL_FE_RATE_SET_VERSIONS or OKL_FE_STD_RT_TMP_VERS.
  • Audit queries using CREATED_BY/LAST_UPDATED_BY and audit dates to satisfy SOX and change-management controls.

Related Objects

The most significant related objects, based on documented key relationships, are:

  • OKL_FE_ADJ_MAT_ALL_B — parent matrix header; joined via OKL_FE_ADJ_MAT_VERSIONS.ADJ_MAT_ID.
  • OKL_FE_RATE_SET_VERSIONS — references this table through ADJ_MAT_VERSION_ID; ties matrix versions to rate sets.
  • OKL_FE_STD_RT_TMP_VERS — standard rate template versions referencing ADJ_MAT_VERSION_ID.
  • OKL_FE_ADJ_MAT_VERSIONS_PK and OKL_FE_ADJ_MAT_VERSIONS_U1 — primary and unique indexes on the version identifier.
  • Standard EBS audit columns and DFF ATTRIBUTE1–15, which interact with the flexfield definition registers for OKL.