Results for “rcs_tl”

4 results




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

Overview

OKL_FE_RESI_CAT_V is an APPS-owned view within the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management, OKL) module. It exposes residual category set definitions used by the residual value and lease pricing engine, presenting a denormalized, language-filtered read model that joins the base residual category table to its multilingual translation table. In Oracle EBS 12.1.1 and 12.2.2, this view serves as the reporting and integration surface for residual category configuration data, allowing concurrent programs, BI Publisher reports, and external interfaces to retrieve residual category metadata without directly navigating the underlying _B and _TL table pair. Because residual categories drive residual value calculations on lease contracts, the view is central to downstream pricing, accounting, and asset management reporting.

Underlying Base Objects

The view is defined over two documented base objects exposed through APPS synonyms:

  • OKL_FE_RESI_CAT_B — the base (non-translated) table holding residual category set rows, aliased as RCS_B in the view definition. It supplies identifiers, organizational context, status, and audit columns.
  • OKL_FE_RESI_CAT_ALL_TL — the translated table holding language-dependent descriptions, aliased as RCS_TL.

The join is performed on RESI_CATEGORY_SET_ID, with the translation table filtered by RCS_TL.LANGUAGE = USERENV('LANG'), so each query returns descriptions in the session's current language. This structure follows the standard EBS multilingual pattern of a _B base table paired with a _TL translation table and a _V view that masks the join from the caller.

Key Columns

  • RESI_CATEGORY_SET_ID — primary identifier of the residual category set, from the base table.
  • ORIG_RESI_CAT_SET_ID — identifier of the original residual category set, typically populated for copied or derived categories.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/ADF framework during concurrent updates.
  • ORG_ID — operating unit identifier, enabling multi-org security and filtering.
  • SOURCE_CODE, STS_CODE — source and status codes indicating the origin and lifecycle state of the category set.
  • RESI_CAT_NAME — residual category name, used as the display key in list of values and reports.
  • RESI_CAT_DESC — translated description, sourced from the _TL table.
  • SFWT_FLAG — translated flag column carried from the _TL table.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the base table.

Common Use Cases and Queries

The view is commonly used in residual value validation reports, lease pricing setup extracts, and integration loads that must reconcile residual categories across environments. A typical query retrieves active categories with descriptions in the session language:

SELECT resi_category_set_id, resi_cat_name, resi_cat_desc, sts_code, org_id FROM apps.okl_fe_resi_cat_v WHERE org_id = :p_org_id ORDER BY resi_cat_name;

For multilingual audits, developers compare the view against OKL_FE_RESI_CAT_ALL_TL to identify missing translations. Because USERENV('LANG') filters the translation join, queries executed without a valid language context may return no description rows, a frequent diagnostic point in integration troubleshooting. Searches referencing the "rcs_b" alias correspond directly to this view's base table alias RCS_B, confirming the view as the intended access path for residual category set data in Oracle EBS 12.1.1 and 12.2.2.