Search Results okl_sif_ret_levels

Overview

The OKL_SIF_RET_LEVELS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product module. It serves as the repository for detailed payment level data returned by an external pricing engine during the contract pricing process. This table is integral to the Service Integration Framework (SIF) interface, which facilitates communication between Oracle Leasing and third-party pricing systems. Its primary role is to store the granular, multi-level payment schedule results—such as periodic payment amounts, dates, and balances—that are calculated externally and then integrated back into the leasing application for contract booking and servicing.

Key Information Stored

The table stores the decomposed results from a pricing engine's response for a given quote or contract. Key columns, as indicated by its constraints, include the unique identifier ID (primary key) and the columns that define the structure of the returned payment stream. The SIR_ID is a critical foreign key column that links each payment level record to its parent response header in the OKL_SIF_RETS table. The INDEX_NUMBER and LEVEL_INDEX_NUMBER columns work together to define the hierarchy and sequence of the payment levels, allowing for complex schedules with multiple tiers or periods. While specific amount and date columns are not detailed in the provided metadata, the table's description confirms it holds the calculated payment levels, which would typically include columns for payment amount, due date, period start/end dates, and outstanding balance amounts for each level.

Common Use Cases and Queries

The primary use case is the storage and subsequent retrieval of externally calculated lease payment schedules for review, validation, and contract creation. A common operational query involves joining this table to its parent to fetch all payment levels for a specific pricing request to display a payment schedule. For reporting and reconciliation, analysts may query this table to compare pricing engine outputs over time or across different asset classes. A typical SQL pattern involves filtering by the parent response ID:

• SELECT * FROM OKL.OKL_SIF_RET_LEVELS WHERE SIR_ID = <response_id> ORDER BY INDEX_NUMBER, LEVEL_INDEX_NUMBER;

Data from this table is also critical for downstream processes that create the actual financial streams and schedules within the OKL module after a quote is accepted.

Related Objects

OKL_SIF_RET_LEVELS has a direct and essential foreign key relationship with the OKL_SIF_RETS table. This relationship is defined as:

• Foreign Key: OKL_SIF_RET_LEVELS.SIR_ID → OKL_SIF_RETS

Every record in OKL_SIF_RET_LEVELS must correspond to a single parent record in OKL_SIF_RETS, which holds the header information for the entire response from the external pricing engine. This structure ensures that all detailed payment levels are correctly associated with their originating pricing request. The table is also referenced by its primary key constraint SRL_PK (ID) and unique key constraint SRL_SRL_UK (SIR_ID, INDEX_NUMBER, LEVEL_INDEX_NUMBER), which enforce data integrity. While not listed in the provided metadata, this table is likely referenced by various OKL pricing and servicing APIs and may be the base for certain reporting views within the module.