Results for “minimum_interest”

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

Overview

OKL_LATE_INTERESTS is a transaction-facing configuration and reference table within the Oracle E-Business Suite (EBS) Leasing and Finance Management module (OKL), present in releases 12.1.1 and 12.2.2. The table stores the interest definitions that may be charged against overdue receivables arising from lease and loan contracts. Each record effectively defines a late-interest policy — for example, whether interest is permitted, whether it is calculated on a fixed or variable basis, the applicable rate or index, and the floor and ceiling thresholds that constrain the calculated amount.

The object resides in the OKL schema and is documented with 36 columns. A heuristic Data Vault classification mined from its foreign-key structure suggests this object maps to a link table, since it primarily resolves relationships between stream types, indices, and unit-of-measure definitions rather than acting as a standalone hub or a descriptive satellite. This classification should be treated as a modeling suggestion rather than a mandated design.

Key Information Stored

The physical primary key of the table is OKL_LATE_INTERESTS_PK, defined on the surrogate column ID. Two unique indexes expose the business-key candidates: OKL_LATE_INTERESTS_U1 on ID, and OKL_LATE_INTERESTS_U2 on the composite (ISE_ID, STY_ID), which is also reflected as the named unique constraint LIN_LIN_UK.

• ID — surrogate primary key uniquely identifying each late-interest definition.
• ISE_ID — identifier linking the definition to its interest/stream setup context; part of the composite business key.
• STY_ID — stream type identifier; foreign key to OKL_STRM_TYPE_B, and the second component of the business key.
• TDF_ID — foreign key to OKL_TUOM_DFNTNS_B, governing the unit-of-measure definition used for the rate or amount.
• IDX_ID — foreign key to OKL_INDICES, identifying the market index used when the interest is variable.
• DESCRIPTION — user-facing text describing the late-interest rule.
• ALLOWED_YN — flag indicating whether late interest may be charged for this configuration.
• FIXED_YN — flag distinguishing a fixed-rate calculation from an index-based one.
• FIXED_RATE — the rate applied when the definition is fixed rather than index-linked.
• MAXIMUM_INTEREST — ceiling on the interest amount that may be charged.
• MINIMUM_INTEREST — floor on the interest amount that may be charged.
• GRACE_PERIOD and GRACE_PERIOD_YN — the delay period, and flag, before late interest begins to accrue.
• MINIMUM_BALANCE — threshold below which overdue balances do not attract interest.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard concurrency and audit columns.

Common Use Cases and Queries

The table is typically queried when analyzing or reconciling late-interest charges on delinquent lease receivables, or when reporting the configured policy for a given stream type. A representative lookup retrieves the active definitions for a stream type:

• SELECT ID, ISE_ID, STY_ID, IDX_ID, FIXED_YN, FIXED_RATE, ALLOWED_YN FROM OKL_LATE_INTERESTS WHERE STY_ID = :p_sty_id;
• Joining to OKL_INDICES exposes the index name behind index-linked definitions: ... FROM OKL_LATE_INTERESTS li, OKL_INDICES i WHERE li.IDX_ID = i.ID;
• Reporting on thresholds for overdue analysis selects MINIMUM_INTEREST, MAXIMUM_INTEREST, GRACE_PERIOD, and MINIMUM_BALANCE alongside DESCRIPTION.

Related Objects

The foreign-key metadata identifies the directly related configuration tables, and the business key confirms the primary dependents:

• OKL_INDICES — joined via OKL_LATE_INTERESTS.IDX_ID = OKL_INDICES.ID; supplies the index definition for variable-rate interest.
• OKL_STRM_TYPE_B — joined via OKL_LATE_INTERESTS.STY_ID = OKL_STRM_TYPE_B.ID; the stream type the rule applies to.
• OKL_TUOM_DFNTNS_B — joined via OKL_LATE_INTERESTS.TDF_ID = OKL_TUOM_DFNTNS_B.ID; defines the unit of measure for the rate or amount.
• The composite unique constraint LIN_LIN_UK (ISE_ID, STY_ID) links each definition back to its interest/stream setup context, anchoring the table within the broader OKL interest and receivables configuration model.