Search Results okl_sif_pricing_params




Overview
Explore in AI Chat

Overview

OKL_SIF_PRICING_PARAMS is a table in the OKL schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Lease and Finance Management (OKL) product family, which supports leasing, financing, and asset-based contract origination. As its description indicates, the table holds the stream interface pricing parameters—configuration and runtime values that govern how pricing data flows between a source system (often an external quoting, pricing, or point-of-sale application) and the contract pricing engine through the Stream Interface Framework (SIF).

In the Stream Interface architecture, pricing attributes are passed as parameterized inputs. This table stores the definition and value of each pricing parameter delivered per stream interface record. Because pricing behavior is highly business-dependent, the table allows parameter-level control over whether a pricing input is displayed, editable, defaulted, or fixed. This supports both interactive entry through the Oracle forms UI and batch/interface processing from external applications.

The table is documented as a standalone object under the heuristic Data Vault classification mined from its foreign key structure. This suggests it behaves as an independent data structure rather than a pure hub, link, or satellite. It includes a foreign key to OKL_PRTFL_CNTRCTS_B via KHR_ID, meaning each pricing parameter row is tied to a contract record in the portfolio contract area. The record is versioned and auditable, containing the standard EBS WHO columns plus an object version number.

Key Information Stored

The table contains 32 documented columns. The most significant are the following:

  • ID — the surrogate primary key, enforced by OKL_SIF_PRICING_PARAMS_PK and also the sole column of the unique index OKL_SIF_PRICING_PARAMS_U1. No alternate business-key column is documented.
  • SIF_ID — identifies the stream interface header/record with which these pricing parameters are associated.
  • KHR_ID — the foreign key to OKL_PRTFL_CNTRCTS_B, linking the parameter set to a specific contract.
  • NAME — the parameter name as recognized by the pricing engine or interface.
  • PRC_ENG_IDENT — the pricing engine identifier, indicating which pricing component consumes the parameter.
  • DEFAULT_VALUE — the starting value applied when no explicit value is supplied.
  • PARAMETER_VALUE — the actual value of the parameter used during pricing.
  • DISPLAY_YN — flags whether the parameter is presented to the user.
  • UPDATE_YN — flags whether users may change the parameter value.
  • DESCRIPTION — free-text explanation of the parameter.
  • OBJECT_VERSION_NUMBER — optimistic locking/versioning column used by the framework.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns present on EBS transactional tables.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns, which allow customers to extend the parameter model without customization.

Common Use Cases and Queries

Typical scenarios include debugging why a contract priced at an unexpected value, confirming which parameters were passed through the stream interface, and auditing user changes. A simple lookup by contract looks like:

SELECT p.id, p.name, p.parameter_value, p.default_value, p.prc_eng_ident
FROM okl.okl_sif_pricing_params p
WHERE p.khr_id = :contract_id;

To find all parameters for a specific interface record, query by SIF_ID. To identify parameters that users were permitted to override, filter where UPDATE_YN = 'Y'. To identify parameters whose current value differs from the default, compare PARAMETER_VALUE to DEFAULT_VALUE. Auditors commonly restrict results with CREATION_DATE or LAST_UPDATE_DATE ranges.

Related Objects

  • OKL_PRTFL_CNTRCTS_B — parent contract table; joined via OKL_SIF_PRICING_PARAMS.KHR_ID = OKL_PRTFL_CNTRCTS_B.ID.
  • OKL_SIF_PRICING_PARAMS_PK — primary key constraint on ID.
  • OKL_SIF_PRICING_PARAMS_U1 — unique index on ID.
  • The stream interface header and other OKL_SIF_ tables — associated SIF records referenced through SIF_ID.
  • Lease and Finance Management pricing engine APIs — consume PARAMETER_VALUE and DEFAULT_VALUE during quote and contract pricing.