Results for “okl_fe_std_rt_tmp_vers”

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

Overview

OKL_FE_STD_RT_TMP_VERS is the Standard Rate Template Versions table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It stores the versioned definitions of standard rate templates used by the OKL Fee and Rate engine to derive pricing, spreads, and adjustment behavior for lease and loan contracts. Each row represents a discrete version of a standard rate template, enabling historical tracking, effective-dated pricing, and reproducible rate calculations across the contract lifecycle. The table is owned by the OKL schema and is marked VALID in both 12.1.1 and 12.2.2.

From a dimensional modeling perspective, the FK structure suggests this object behaves like a satellite. It carries descriptive, effective-dated attributes (rates, spreads, status, adjustment maturity references) attached to a parent hub key — OKL_FE_STD_RT_TMP_ALL_B via STD_RATE_TMPL_ID — rather than acting as an independent hub or a pure many-to-many link. This classification is a heuristic, not an enforced rule.

Key Information Stored

• STD_RATE_TMPL_VER_ID — Surrogate primary key of the version row; also the target of the unique index OKL_FE_STD_RT_TMP_VERS_U1 (business-key candidate).
• STD_RATE_TMPL_ID — Foreign key to OKL_FE_STD_RT_TMP_ALL_B; identifies the parent standard rate template. Part of the composite primary key OKL_FE_STD_RT_TMP_VERS_PK.
• VERSION_NUMBER — Sequence number of this template version, used for version ordering.
• OBJECT_VERSION_NUMBER — Optimistic locking column maintained by the framework for concurrent update control.
• EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — Date range during which the version is valid.
• STS_CODE — Status code indicating lifecycle state of the version (e.g., active, draft, obsolete).
• ADJ_MAT_VERSION_ID — Foreign key to OKL_FE_ADJ_MAT_VERSIONS, linking the template version to its adjustment maturity definition.
• SRT_RATE / SPREAD — The base standard rate and the spread applied when pricing contracts.
• DAY_CONVENTION_CODE — Day-count convention governing interest accrual calculations.
• MIN_ADJ_RATE / MAX_ADJ_RATE — Floor and cap thresholds applied to adjusted rates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield columns for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

The documented schema contains 34 columns; the fields above represent the functionally significant subset for rate and versioning logic.

Common Use Cases and Queries

Typical reporting queries resolve the currently active rate template version for a given template, or reconstruct the rate that applied on a historical date. A representative pattern:

• Point-in-time lookup: filter on STD_RATE_TMPL_ID, then constrain EFFECTIVE_FROM_DATE <= :as_of AND NVL(EFFECTIVE_TO_DATE, SYSDATE) >= :as_of.
• Version history: join to OKL_FE_RATE_SET_VERSIONS via STD_RATE_TMPL_VER_ID to see which rate sets reference a given template version.
• Rate validation: compare SRT_RATE and SPREAD against MIN_ADJ_RATE/MAX_ADJ_RATE bounds for anomaly detection.
• Audit and compliance: use WHO columns and VERSION_NUMBER to track changes to standard rates over time.

Related Objects

• OKL_FE_STD_RT_TMP_ALL_B — Parent template table; joined on STD_RATE_TMPL_ID.
• OKL_FE_ADJ_MAT_VERSIONS — Referenced via ADJ_MAT_VERSION_ID to obtain adjustment maturity definitions.
• OKL_FE_RATE_SET_VERSIONS — Child table referencing STD_RATE_TMPL_VER_ID; links rate sets to template versions.
• OKL_FE_STD_RT_TMP_VERS_PK — Primary key constraint on STD_RATE_TMPL_ID.
• OKL_FE_STD_RT_TMP_VERS_U1 — Unique index guaranteeing uniqueness of STD_RATE_TMPL_VER_ID.