Search Results okl_fe_item_resdl_values




Overview
Explore in AI Chat

Overview

OKL_FE_ITEM_RESDL_VALUES is a transactional table in the Oracle Leasing and Finance Management (OKL) module of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. Its business description is Item Residual Line Values. The table stores the time-phased residual value amounts attached to an item residual definition within a specific residual version, providing the term-by-term schedule that drives residual accounting, contract pricing, and end-of-term processing.

Functionally, the table sits between the residual version definition (OKL_ITM_CAT_RV_PRCS) and the item residual records (OKL_FE_ITEM_RESIDUAL_ALL). Each row represents one residual value effective for a given term in months, so a single residual version may produce many rows across the lease term horizon. From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning: it carries descriptive, version- and time-dependent measures hanging off parent keys rather than acting as a pure hub or a many-to-many link.

Key Information Stored

The documented physical schema exposes eleven columns. The most significant are:

The combination of ITEM_RESIDUAL_ID, ITEM_RESDL_VERSION_ID, and TERM_IN_MONTHS forms the logical grain: one residual value per term per residual version.

Common Use Cases and Queries

Typical usage includes reconstructing residual value schedules for reporting, validating that residual amounts are monotonically decreasing to zero across terms, and tracing a contract’s residual back to its originating version.

  • Retrieving the full schedule for an item residual: 
    SELECT term_in_months, residual_value
FROM   okl.okl_fe_item_resdl_values
WHERE  item_residual_id = :p_item_residual_id
AND    item_resdl_version_id = :p_version_id
ORDER BY term_in_months;
  • Joining to the residual version to report version context: 
    SELECT v.term_in_months, v.residual_value, p.version_number
FROM   okl.okl_fe_item_resdl_values v,
       okl.okl_itm_cat_rv_prcs p
WHERE  v.item_resdl_version_id = p.item_resdl_version_id;
  • Reconciliation of residual values against contract terms to detect gaps in the TERM_IN_MONTHS sequence.
  • Audit queries filtering on LAST_UPDATE_DATE to identify residual schedules altered after initial setup.

Related Objects

  • OKL_ITM_CAT_RV_PRCS — parent residual version table; joined on ITEM_RESDL_VERSION_ID.
  • OKL_FE_ITEM_RESIDUAL_ALL — parent item residual table; joined on ITEM_RESIDUAL_ID.
  • OKL_FE_ITEM_RESDL_VALUES_PK / _U1 — primary key and unique index on ITEM_RESDL_VALUE_ID.
  • OKL_FE_ITEM_RESIDUAL_VERSIONS and other OKL residual setup tables reached through OKL_ITM_CAT_RV_PRCS.
  • OKL_ITM_CAT_RV_PRCS-related item category residual processes that generate or version the value schedules.

Because the table is a child of both the residual and residual-version entities, any inquiry or reporting layer that displays item residuals should join through these parents to obtain descriptive context, since this table itself holds only numeric residual measures and audit columns.