Search Results okl_indices

Overview

The OKL_INDICES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master or header table for defining interest rate indices. An index, in this financial context, represents a published benchmark interest rate, such as LIBOR or a prime rate, which is used to calculate variable interest charges on leases, loans, and other financial instruments. The table stores the fundamental definition and identification of each index, enabling the system to link to detailed historical rate values stored in related tables for accurate financial calculations and accruals.

Key Information Stored

While the provided metadata does not list all columns, the primary and unique keys indicate the critical data points. The table's primary key is the ID column, a unique system-generated identifier for each index record. A significant business key is the NAME column, which holds the unique, descriptive name of the interest rate index (e.g., "US 30-Day LIBOR"). This column is enforced by the IDX_IDX_UK unique key constraint. Other typical columns in such a header table, inferred from standard practice, would include control attributes like ENABLED_FLAG, START_DATE, END_DATE for validity periods, and descriptive fields such as DESCRIPTION. The table serves as the authoritative source for all valid indices used across the leasing and finance operations.

Common Use Cases and Queries

The primary use case is the setup and maintenance of interest rate benchmarks within the system. This table is referenced whenever a financial product, contract, or late fee policy is configured to use a variable rate tied to a published index. Common reporting and operational queries include listing all active indices or finding a specific index by name for validation. For example, a query to retrieve all currently enabled indices would be fundamental for setup tasks:

• SELECT NAME, DESCRIPTION FROM OKL.OKL_INDICES WHERE ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);

Another critical use is tracing the usage of an index by joining to related transactional tables to understand its impact on contracts and calculations.

Related Objects

As indicated by the foreign key relationships, OKL_INDICES is a central reference table for several key transactional and setup tables in the OKL module. The most direct relationship is with OKL_INDEX_VALUES, which stores the actual historical or current interest rate values for each index defined in OKL_INDICES, linked via IDX_ID. Furthermore, the table is referenced by policy and calculation entities: OKL_LATE_POLICIES_B and OKL_LATE_POLICIES_ALL_B (for defining late payment interest policies), OKL_LATE_INTERESTS (for late interest calculations), and OKL_TXD_AR_LN_DTLS_B (likely for transaction details in accounts receivable or loan processes). These dependencies underscore its role as a master data source for interest rate-driven logic throughout the application.