Results for “okl_sif_lines”

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

Overview

OKL_SIF_LINES is a table in the OKL (Leasing and Finance Management) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It holds the asset line details used for external pricing, acting as the storage point for the individual asset-level attributes that flow into the Stream Interface Framework (SIF) pricing process. In practice this is the table an ETRM developer or analyst inspects when investigating why a leased asset received a particular depreciation schedule, residual treatment, or tax-basis result, since the table carries the federal, state, and book depreciation parameters alongside the residual and purchase-option terms.

From a Data Vault modeling perspective, the FK topology behind this table is satellite-leaning: it carries the descriptive measures and attributes surrounding a central relationship rather than serving as a pure hub or link. This classification is a heuristic mined from the FK structure and should be treated as a modeling suggestion, not a documented EBS fact.

Key Information Stored

The table exposes 63 documented columns under the OKL owner in 12.2.2. The surrogate primary key is SIL_PK, protected by the unique index OKL_SIL_UK1; ID is the business-key candidate on that unique index and is distinct from the surrogate. Among the most operationally significant columns are:

• SIF_ID and KLE_ID — the two foreign key columns that anchor each row to its stream interface header and to the contract line, respectively.
• SIL_TYPE — the line type discriminator that drives downstream processing logic.
• ASSET_COST, RESIDUAL_AMOUNT, RESIDUAL_DATE, RESIDUAL_GUARANTEE_AMOUNT, RESIDUAL_GUARANTEE_METHOD, and RESIDUAL_GUARANTEE_TYPE — the core pricing and residual-position attributes.
• PURCHASE_OPTION and PURCHASE_OPTION_AMOUNT — the end-of-term buyout terms.
• DATE_START, DATE_DELIVERY, DATE_FUNDING, DATE_BOOK, DATE_LENDING, and DATE_STATE_DEPRE — the funding, booking, and depreciation-effective dates.
• BOOK_METHOD, BOOK_TERM, BOOK_SALVAGE, BOOK_BASIS_PERCENT, and BOOK_ADR_CONVENTION — the book depreciation rule set.
• FED_DEPRE_METHOD, FED_DEPRE_TERM, FED_DEPRE_SALVAGE, FED_DEPRE_BASIS_PERCENT, FED_DEPRE_ADR_CONVE, and FED_DEPRE_DMNSHING_VALUE_RATE — the federal tax depreciation rule set.
• STATE_DEPRE_METHOD, STATE_DEPRE_ADR_CONVENT, STATE_DEPRE_BASIS_PERCENT, and STATE_DEPRE_TERM — the parallel state tax rule set.
• DOWN_PAYMENT_AMOUNT, CAPITALIZE_DOWN_PAYMENT_YN, ORIG_CONTRACT_LINE_ID, OBJECT_VERSION_NUMBER, and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).
• STREAM_INTERFACE_ATTRIBUTE01 through STREAM_INTERFACE_ATTRIBUTE15 — a fifteen-column descriptive flexfield-style extension area reserved for implementation-specific pricing attributes.

Common Use Cases and Queries

Typical scenarios include diagnosing a failed or unexpected pricing result, reconciling residual and purchase-option amounts against the contract, and feeding asset-level analytics into a lease portfolio report. A common pattern joins the line to its header and contract line:

SELECT l.SIL_PK, l.SIF_ID, l.KLE_ID, l.SIL_TYPE, l.ASSET_COST, l.RESIDUAL_AMOUNT, l.DATE_BOOK, l.BOOK_METHOD FROM OKL.OKL_SIF_LINES l WHERE l.SIF_ID = :p_sif_id ORDER BY l.SIL_PK;

Because OKL_SIF_LINES also holds the federal and state depreciation rate columns, it is a frequent source for tax-basis variance queries comparing BOOK_METHOD against FED_DEPRE_METHOD and STATE_DEPRE_METHOD for the same asset. Reporting queries should always filter on SIF_ID or KLE_ID to avoid full scans, and should account for the OBJECT_VERSION_NUMBER when the row is being modified through the leasing APIs.

Related Objects

The FK metadata identifies the principal dependencies around this object:

• OKL_SIF_LINES.SIF_ID → OKL_STREAM_INTERFACES — the parent stream interface header supplying the pricing run context.
• OKL_SIF_LINES.KLE_ID → OKL_K_LINES — the contract line that owns the asset being priced.
• OKL_SIF_STREAM_TYPES.SIL_ID → OKL_SIF_LINES — the dependent stream type rows that hang off each line, one of the key child relationships to join when reconstructing a full pricing record.
• OKL_SIF_LINES primary key SIL_PK, with OKL_SIL_UK1 on ID as the unique business-key index.

These relationships make OKL_SIF_LINES the joining surface between contract structure (OKL_K_LINES), the pricing execution header (OKL_STREAM_INTERFACES), and the stream type detail (OKL_SIF_STREAM_TYPES). Any query that needs a complete view of external pricing data should traverse all three.