Search Results okl_sif_lines




Overview
Explore in AI Chat

Overview

The OKL_SIF_LINES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a detailed repository for asset line information specifically utilized during the external pricing process. This table is integral to the interface that transmits financial stream data, such as lease payments and asset details, from the core leasing contracts to external pricing engines. Its primary role is to store granular, line-level data that corresponds to a broader pricing request, enabling the system to perform complex financial calculations and evaluations outside the native EBS environment before returning the results for contract booking or modification.

Key Information Stored

The table stores detailed attributes for each asset line submitted for external pricing. While the full column list is not provided in the metadata, the documented foreign key relationships indicate the presence of critical identifier columns. The ID column serves as the primary key (SIL_PK). The SIF_ID column links each line to its parent pricing request header in the OKL_STREAM_INTERFACES table. The KLE_ID column establishes the relationship to the originating lease line in the OKL_K_LINES table, which is the central transactional line table for the OKL module. Additional columns would typically store asset-specific financial details required for pricing, such as cost, description, quantity, and categorization codes that the external engine processes.

Common Use Cases and Queries

The primary use case revolves around troubleshooting and reporting on external pricing submissions. For instance, an analyst may need to identify all asset lines associated with a failed or pending pricing request. A common query pattern involves joining to the header interface table to filter by request status or date.

SELECT sil.id, sil.kle_id, sif.request_number, sif.status
FROM okl_sif_lines sil,
     okl_stream_interfaces sif
WHERE sil.sif_id = sif.id
AND sif.creation_date > TRUNC(SYSDATE-1);

Another frequent scenario is tracing the lifecycle of a specific lease line through the pricing interface, which requires joining back to the transactional lease line table to pull in contract and asset details for reconciliation.

Related Objects

  • OKL_STREAM_INTERFACES (Table): The parent header table. Each row in OKL_SIF_LINES is associated with a single pricing request header via the SIF_ID foreign key column.
  • OKL_K_LINES (Table): The source transactional lease line table. The KLE_ID foreign key in OKL_SIF_LINES references this table to identify the original lease line being priced.
  • OKL_SIF_STREAM_TYPES (Table): This table holds a foreign key reference (SIL_ID) back to OKL_SIF_LINES, indicating that OKL_SIF_LINES is a parent table for stream type details. This relationship likely stores the different financial streams (e.g., rent, residual) generated for each asset line during the pricing process.