Search Results okl_ls_rt_fctr_sets_v




Overview
Explore in AI Chat

Overview

OKL_LS_RT_FCTR_SETS_V is a Multi-Lingual Support (MLS) view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL – Lease and Finance Management product. It presents lease and finance rate factor set definitions in a language-aware, denormalized form suitable for reporting, integration, and inquiry screens. The view resolves the language-specific descriptive attributes from a translation table and merges them with the transactional and operational attributes stored in the base table, controlled by the session language environment (USERENV('LANG')). Its status is VALID in both EBS 12.1.1 and 12.2.2, and it is the standard interface an application or report should use to read rate factor set data without having to join the underlying base and translation tables manually.

Underlying Base Objects

The view is defined over two synonyms in the APPS schema, each resolving to a base table in the OKL schema:

  • OKL_LS_RT_FCTR_SETS_B — the base (non-translatable) table holding the operational and financial attributes of each rate factor set, including identifiers, rate values, date ranges, status, currency, and descriptive flexfield segments.
  • OKL_LS_RT_FCTR_SETS_TL — the translation table holding the language-specific NAME and DESCRIPTION columns.

The join is performed on LRT.ID = LRTT.ID with the additional filter LRTT.LANGUAGE = USERENV('LANG'), guaranteeing that only the row matching the current session language is returned. Because the join restricts to a single language, the view returns exactly one row per rate factor set for the active session, presenting NAME and DESCRIPTION in the user's own language while leaving the remaining attributes untouched.

Key Columns

  • ROW_ID — the base table ROWID, useful for direct row access or updates through the base object.
  • ID — the primary key of the rate factor set.
  • NAME and DESCRIPTION — sourced from the translation table and returned in the session language.
  • RATE, FRQ_CODE, ARREARS_YN — the core rate factor definition: the rate value, its frequency code, and whether the rate is applied in arrears.
  • START_DATE, END_DATE — the effective date range for the factor set.
  • STS_CODE — the status of the rate factor set record.
  • TRY_ID, PDT_ID, LRS_TYPE_CODE, END_OF_TERM_ID, ORIG_RATE_SET_ID — identifiers linking the rate factor set to its treasury/interest index, product, lease type, end-of-term treatment, and originating rate set.
  • ORG_ID — the operating unit that owns the record, enabling multi-org security filtering.
  • CURRENCY_CODE — the denomination of the rate.
  • SFWT_FLAG — a flag column carried from the base table.
  • OBJECT_VERSION_NUMBER — used for optimistic locking and concurrency control.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segment values.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle who-columns for auditing.

Common Use Cases and Queries

The view is typically queried for reporting on configured rate factor sets, for validating rate setup, and for integration extracts that feed downstream calculations. A representative query lists active rate factor sets for a given operating unit and currency:

  • SELECT id, name, rate, frq_code, currency_code, sts_code FROM apps.okl_ls_rt_fctr_sets_v WHERE org_id = :p_org_id AND sts_code = 'ACTIVE' ORDER BY name;
  • Joining to product or index reference tables via PDT_ID or TRY_ID to resolve the rate structure for a lease transaction.
  • Filtering by START_DATE and END_DATE to determine which factor set was effective at a point in time for an audit or recalculation exercise.
  • Extracting NAME and DESCRIPTION for localized UI or report output without manual translation-table joins.

As with any MLS view, the language filter is implicit; callers never supply the language predicate themselves. When invoking the view from a custom report or interface, ensure the concurrent program or session language is set appropriately so the correct translation row is returned.