Search Results okl_cure_report_amount_pk

Overview

The OKL_CURE_REPORT_AMOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a line-level detail table, storing specific financial amounts associated with a cure report. In the context of leasing and asset finance, a cure report is a formal notification or statement detailing outstanding obligations, such as delinquent payments or other contractual breaches, and the amounts required to "cure" or rectify the default. This table is essential for maintaining a granular, auditable record of the individual monetary components that comprise the total cure obligation reported to a customer or counterparty.

Key Information Stored

The table's primary purpose is to link individual cure amount line items to a specific parent cure report. Its structure is defined by key foreign key relationships. The primary identifier for each row is the CURE_REPORT_AMOUNT_ID, enforced by the primary key constraint OKL_CURE_REPORT_AMOUNT_PK. Two critical foreign keys establish its relationships: the CURE_REPORT_ID column links the line item to its parent document in the OKL_CURE_REPORTS table, which holds the header-level report information. The CURE_AMOUNT_ID column links to the OKL_CURE_AMOUNTS table, which is the master repository for defined cure amount types and calculations. Through this link, the OKL_CURE_REPORT_AMOUNTS table effectively instances a specific cure amount (e.g., past due principal, late fee, tax) onto a specific report.

Common Use Cases and Queries

The primary use case is generating and analyzing detailed cure reports for lease or finance contract delinquencies. A common operational query would retrieve all line items for a specific report to validate the total cure amount before issuance. For reporting and reconciliation, analysts often aggregate amounts by cure type across multiple reports or contracts. A typical SQL pattern involves joining this table to its parent and master tables:

• Joining to OKL_CURE_REPORTS to filter by report number, contract, or status.
• Joining to OKL_CURE_AMOUNTS to categorize and sum amounts by type (e.g., interest, fee, principal).
• This enables creation of detail reports that show a breakdown of every charge contributing to a customer's total delinquency.

It is critical to note that the provided ETRM metadata states this table is "Not implemented in this database," which may indicate it is a standard Oracle table not currently installed in a specific instance, or its use depends on particular module configurations.

Related Objects

The functionality of OKL_CURE_REPORT_AMOUNTS is intrinsically tied to a small hierarchy of related tables within the OKL module.

• OKL_CURE_REPORTS: This is the direct parent table. Every record in OKL_CURE_REPORT_AMOUNTS must correspond to a single header record in this table, which manages the overall report lifecycle and summary totals.
• OKL_CURE_AMOUNTS: This is a key master table. It defines the valid types and calculation rules for cure amounts. The foreign key relationship ensures that only pre-defined, valid amount types can be added to a cure report line.
• The table's existence suggests related program units, such as concurrent request programs for report generation and public APIs (likely within the OKL_CURE_PUB package) for creating and updating cure reports and their associated line amounts.