Search Results okl_fe_eo_term_values_pk

Overview

The OKL_FE_EO_TERM_VALUES table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Lease and Finance Management (OKL) module. It functions as the master transactional table for storing specific end-of-term (EOT) value data associated with financial agreements. This table is essential for managing lease and finance contracts where the agreement specifies a predetermined residual or buyout value at the conclusion of its term. The data stored here supports critical downstream processes, including end-of-term accounting, asset disposition, and the calculation of financial obligations for lessees.

Key Information Stored

The table's primary purpose is to record the monetary values and related attributes for end-of-term options. While the full column list is not detailed in the provided metadata, its structure is anchored by a primary key and a critical foreign key. The END_OF_TERM_VALUE_ID column serves as the unique primary key identifier for each value record. The END_OF_TERM_VER_ID is a mandatory foreign key that links each value to its parent version record in the OKL_FE_EO_TERM_VERS table. Typically, other columns in such a table would store the actual monetary value (e.g., END_OF_TERM_VALUE), the applicable currency, the effective date range for the value, and potentially the type of end-of-term option (e.g., fair market value purchase option, fixed price purchase option, or return conditions).

Common Use Cases and Queries

This table is central to operational and reporting activities concerning lease maturity. A common use case is generating a report of all active leases with their associated end-of-term buyout values for portfolio analysis and cash flow forecasting. System processes query this table to determine the financial settlement amount when a lessee exercises a purchase option at lease termination. A typical SQL pattern involves joining to the version table to retrieve a complete context. For example, to list values for a specific contract header, one might use a query pattern such as:

• SELECT val.end_of_term_value, val.currency_code, ver.contract_id
• FROM okl_fe_eo_term_values val,
• okl_fe_eo_term_vers ver
• WHERE val.end_of_term_ver_id = ver.end_of_term_ver_id
• AND ver.contract_id = :p_contract_id;

Related Objects

The OKL_FE_EO_TERM_VALUES table has a defined, dependent relationship within the EBS schema, as per the provided metadata. Its sole documented foreign key relationship is to the OKL_FE_EO_TERM_VERS (End-of-Term Versions) table. This relationship is enforced through the column OKL_FE_EO_TERM_VALUES.END_OF_TERM_VER_ID, which references the primary key of the OKL_FE_EO_TERM_VERS table. This design indicates that multiple value records (e.g., for different asset lines or date-effective changes) can roll up to a single contractual version. The table is itself protected by the primary key constraint OKL_FE_EO_TERM_VALUES_PK on the END_OF_TERM_VALUE_ID column.