Search Results okl_itm_cat_rv_prcs




Overview
Explore in AI Chat

Overview

OKL_ITM_CAT_RV_PRCS is a transactional configuration table within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. Its documented purpose is to store item residual value percentages, which drive residual value calculations for lease and finance agreements organized by item category and lease term. Each row associates a category pairing (CAT_ID1, CAT_ID2) and a contract duration (TERM_IN_MONTHS) with a RESIDUAL_VALUE_PERCENT, enabling the leasing engine to derive expected end-of-term asset values used in pricing, quoting, and accounting.

From a dimensional-modeling perspective, the metadata's foreign key structure suggests a hub-leaning classification. The table owns a surrogate primary key (OKL_ITM_CAT_RV_PRCS_PK on ID) and an additional unique business key (OKL_ITM_CAT_RV_PRCS_UK across CAT_ID1, CAT_ID2, and TERM_IN_MONTHS), while also referencing OKL_FE_ITEM_RESIDUAL_ALL through ITEM_RESIDUAL_ID. This combination of an independent identity plus outbound references is characteristic of a hub entity that could anchor a Data Vault model, with the attribute-heavy payload (percentages, effective dates, descriptive flexfields) potentially modeled as a dependent satellite.

Key Information Stored

The documented physical schema contains 32 columns. The most operationally significant are:

  • ID — Surrogate primary key, enforced by OKL_ITM_CAT_RV_PRCS_PK and the unique index OKL_ITM_CAT_RV_PRCS_U1.
  • CAT_ID1, CAT_ID2, TERM_IN_MONTHS — The composite business key defined by OKL_ITM_CAT_RV_PRCS_UK. Together they identify the category pairing and the lease term length to which a residual percentage applies.
  • RESIDUAL_VALUE_PERCENT — The core business value; the percentage of original item value expected to remain at lease maturity.
  • START_DATE, END_DATE — Effective dating that allows historical percentage sets to coexist without overwriting prior agreements.
  • ITEM_RESIDUAL_ID — Foreign key to OKL_FE_ITEM_RESIDUAL_ALL, tying the percentage record to the residual value entity.
  • STS_CODE — Status indicator governing whether the record is active or obsolete for selection.
  • VERSION_NUMBER, OBJECT_VERSION_NUMBER — Versioning columns supporting concurrent update control and audit lineage.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns for auditability.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments for customer-specific extensions.

Common Use Cases and Queries

Typical usage centers on residual valuation lookups during lease origination and on audit reporting. A representative query retrieves the effective percentage for a category and term:

  • SELECT residual_value_percent FROM okl.okl_itm_cat_rv_prcs WHERE cat_id1 = :p_cat1 AND cat_id2 = :p_cat2 AND term_in_months = :p_term AND sysdate BETWEEN start_date AND NVL(end_date, sysdate+1) AND sts_code = 'ACTIVE';
  • Bulk extraction for analytics: joining to OKL_FE_ITEM_RESIDUAL_ALL on ITEM_RESIDUAL_ID to report residual percentages by residual version.
  • Effective-date history reporting using START_DATE and END_DATE to reconstruct the percentage in force at a prior contract signing.
  • Data quality checks confirming the UK (CAT_ID1, CAT_ID2, TERM_IN_MONTHS) has no overlapping effective windows.

Related Objects

The most significant related objects, derived from the documented foreign key relationships, are:

  • OKL_FE_ITEM_RESIDUAL_ALL — Referenced via OKL_ITM_CAT_RV_PRCS.ITEM_RESIDUAL_ID; the parent residual value entity.
  • OKL_FE_ITEM_RESDL_VALUES — References this table through ITEM_RESDL_VERSION_ID, consuming residual percentage versions downstream.
  • OKL_ITM_CAT_RV_PRCS_PK and OKL_ITM_CAT_RV_PRCS_U1 — Primary key and unique index objects enforcing identity on ID.
  • OKL_ITM_CAT_RV_PRCS_UK — Unique index enforcing the CAT_ID1, CAT_ID2, TERM_IN_MONTHS business key sought by the user query.

Collectively, these relationships position OKL_ITM_CAT_RV_PRCS as a central reference for residual percentage determination within the OKL residual value subsystem.