Results for “interest_amt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_CNTRCT_BALANCES_ALL is the contract balances table within the Oracle Leasing and Finance Management (OKL) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the financial position of a lease or finance contract at a point in time, capturing principal, interest, accrual, billing, and termination amounts together with the dates on which those amounts were established or recognized. Because the table name carries the _ALL suffix, it is multi-organization aware and is filtered by ORG_ID; the operating unit therefore forms part of the effective access key for every row.

The ETRM metadata classifies this object heuristically as standalone within a Data Vault style model. In practice this suggests treating the table as a satellite-like store of descriptive, time-stamped balance measures attached to a contract hub, rather than as a link table that resolves many-to-many relationships. It has a single documented foreign key to OKL_PRTFL_CNTRCTS_B through KHR_ID, confirming that the contract header acts as the parent entity and that balance rows are attribute-bearing children.

Key Information Stored

The table contains 42 documented columns. The most significant are:

• ID — surrogate primary key, enforced by OKL_CNTRCT_BALANCES_ALL_PK and duplicated by unique index OKL_CNTRCT_BALANCES_ALL_U1. This is a system-generated identifier with no business meaning.
• KHR_ID — foreign key to OKL_PRTFL_CNTRCTS_B; identifies the contract to which the balance belongs and is the primary business-key candidate for joins.
• KLE_ID — asset or line-level reference linking the balance to the contract's leased asset or stream structure.
• ACTUAL_PRINCIPAL_BALANCE_AMT and ACTUAL_PRINCIPAL_BALANCE_DATE — the outstanding principal balance and the date it was measured.
• INTEREST_AMT and INTEREST_CALC_DATE — interest calculated for the period and its calculation date.
• INTEREST_ACCRUED_AMT and INTEREST_ACCRUED_DATE — accrued but unbilled interest and accrual date.
• INTEREST_BILLED_AMT and INTEREST_BILLED_DATE — interest invoiced to the lessee and the billing date.
• INTEREST_RECEIVED_AMT and INTEREST_RECEIVED_DATE — interest collected and the receipt date.
• TERMINATION_VALUE_AMT and TERMINATION_DATE — the payoff or termination value and its effective date.
• ORG_ID — operating unit, required for multi-org security and reporting.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle framework on update.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context identifying the process that last wrote the row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the reserved descriptive flexfield segment columns.

Common Use Cases and Queries

The table is used primarily for contract-level financial reporting: outstanding principal exposure, interest accrual versus billing reconciliation, and termination value analysis. A typical join retrieves the contract number alongside its latest balance:

• SELECT b.khr_id, c.contract_number, b.actual_principal_balance_amt, b.interest_accrued_amt, b.termination_value_amt FROM okl_cntrct_balances_all b, okl_prtfl_cntrcts_b c WHERE b.khr_id = c.id AND b.org_id = :org_id;
• Accrual-to-billing variance: compare INTEREST_ACCRUED_AMT against INTEREST_BILLED_AMT for a period to detect unbilled interest.
• Collections analysis: contrast INTEREST_BILLED_AMT with INTEREST_RECEIVED_AMT to identify arrears.
• Portfolio exposure: aggregate ACTUAL_PRINCIPAL_BALANCE_AMT by ORG_ID or by contract, using ACTUAL_PRINCIPAL_BALANCE_DATE to select the most recent measurement.
• Termination reporting: list contracts where TERMINATION_VALUE_AMT is populated and TERMINATION_DATE falls in the reporting window.

Related Objects

• OKL_PRTFL_CNTRCTS_B — parent contract header table; joined on OKL_CNTRCT_BALANCES_ALL.KHR_ID = OKL_PRTFL_CNTRCTS_B.ID. This is the only documented foreign key.
• OKL_PRTFL_CNTRCTS_TL — translation table supplying contract names and descriptions for reporting joins through the header.
• OKL_CONTRACTS_ALL / OKL_K_LINES — contract and line structures referenced indirectly through KHR_ID and KLE_ID for asset-level balance breakdown.
• OKL_CNTRCT_BALANCES_ALL_PK / _U1 — the primary key constraint and unique index enforcing row identity on ID.
• OKL Streams and billing tables (OKL_STRM_SCHEDULES, OKL_TRX_BILL_LINES) — sources from which billed and received interest figures are derived.
• OKL_CNTRCT_BALANCES_ALL_WHO and related audit triggers or history objects, where deployed, mirror the WHO columns for change tracking.
• OKL APIs — contract balance maintenance is generally performed through OKL public APIs and concurrent programs rather than direct DML, given the program/request columns present on the table.