Search Results lin_lin_uk

Overview

The OKL_LATE_INTERESTS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the master repository for defining and storing late interest policies. These policies govern the calculation of interest charges that are applied to overdue receivables, such as delinquent lease or loan payments. The table's existence is critical for automating and enforcing financial terms related to delinquency, ensuring accurate revenue recognition and compliance with contractual agreements. Its role is integral to the receivables management lifecycle within the leasing and finance business processes of EBS.

Key Information Stored

The table stores configuration data that defines how late interest is calculated for specific financial products or streams. Based on the provided metadata, key columns include a system-generated primary key (ID) and foreign key columns that link to related setup entities. The column STY_ID (Stream Type ID) links the late interest rule to a specific revenue or payment stream type defined in OKL_STRM_TYPE_B. The IDX_ID (Index ID) column references a financial index in OKL_INDICES, which is likely used as the basis for the interest rate calculation. The TDF_ID (Time Unit of Measure Definition ID) column links to OKL_TUOM_DFNTNS_B, specifying the time period (e.g., daily, monthly) for interest accrual. The table also enforces a unique constraint (LIN_LIN_UK) on the combination of ISE_ID and STY_ID, preventing duplicate policy definitions for a given context.

Common Use Cases and Queries

The primary use case is the system's backend process for assessing and generating late interest charges on delinquent transactions. A financial administrator may query this table to audit or report on active late interest policies. Common SQL patterns include joining to related setup tables to produce a readable policy definition. For example, a query to list all configured late interest rules would typically join OKL_LATE_INTERESTS (LI) to OKL_STRM_TYPE_B (STY) for the stream type name and to OKL_INDICES (IDX) for the index name. Reporting use cases involve verifying that the correct interest policy is attached to a contract stream or troubleshooting discrepancies in calculated late charge amounts by examining the underlying rule definitions.

Related Objects

The OKL_LATE_INTERESTS table maintains defined foreign key relationships with several other setup tables in the OKL schema, as documented in the ETRM metadata. These relationships are fundamental to its configuration.

• OKL_INDICES: Joined via the IDX_ID column. This provides the financial index (e.g., a prime rate) used as the basis for the late interest rate calculation.
• OKL_STRM_TYPE_B: Joined via the STY_ID column. This links the late interest rule to a specific type of financial stream (e.g., lease payment, interest income).
• OKL_TUOM_DFNTNS_B: Joined via the TDF_ID column. This defines the time unit of measure (e.g., day, month) for the interest accrual period.

The table's primary key (ID) is referenced by its primary key constraint (OKL_LATE_INTERESTS_PK) and may be referenced by other application tables or views not listed in the provided excerpt.