Search Results okl_cure_amounts




Overview
Explore in AI Chat

Overview

The OKL_CURE_AMOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. Its primary function is to serve as the transactional repository for calculated cure and repurchase amounts associated with lease or finance contracts. These amounts are generated on a periodic basis, typically as part of delinquency processing or contract management workflows. The table plays a critical role in tracking the financial obligations a customer must fulfill to bring a delinquent contract back into good standing or to repurchase an asset. Its existence is fundamental to the module's capabilities for managing contract defaults, recoveries, and associated financial reporting.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the primary key, the table's description and relationships define its core data structure. The central identifier is the CURE_AMOUNT_ID, a system-generated unique key. Each record logically stores financial amounts tied to a specific contract for a specific accounting period. This would typically include the calculated cure amount, the repurchase amount, the applicable contract identifier, the period for which the calculation is valid, and the currency. The table likely also contains audit columns such as creation date, created by, last update date, and last updated by to track record lifecycle, along with attributes indicating the calculation status and source.

Common Use Cases and Queries

The primary use case for OKL_CURE_AMOUNTS is supporting the generation and review of cure notices and repurchase invoices. Financial controllers and lease administrators query this table to analyze outstanding cure obligations across a portfolio. A common reporting pattern involves joining to contract header tables to summarize total cure amounts by customer or product line. Sample SQL to retrieve basic cure data might resemble:

  • SELECT contract_id, period_date, cure_amount, repurchase_amount FROM okl_cure_amounts WHERE contract_id = :p_contract_id ORDER BY period_date DESC;

This data is essential for period-end close processes within OKL, ensuring all calculated delinquent financial obligations are accurately captured and available for integration to the general ledger or for dunning communication workflows.

Related Objects

The table maintains a direct foreign key relationship with the OKL_CURE_REPORT_AMOUNTS table, as documented in the ETRM metadata. This relationship is established via the CURE_AMOUNT_ID column, where OKL_CURE_REPORT_AMOUNTS.CURE_AMOUNT_ID references OKL_CURE_AMOUNTS.CURE_AMOUNT_ID. This indicates that the detailed cure amounts stored in OKL_CURE_AMOUNTS are aggregated or summarized into broader cure reports. The table is also inherently related to the core contract header table (likely OKL_K_HEADERS) and period tables, though these specific foreign keys are not enumerated in the provided excerpt. Access and manipulation of data in this table are typically performed through dedicated OKL public APIs rather than via direct SQL.