Results for “okl_cure_refund_requests_b”

8 results




Overview
Explore in AI Chat

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

Overview

The table OKL.OKL_CURE_REFUND_HEADERS_TL is the translation (TL) companion table to the base entity OKL_CURE_REFUND_HEADERS_B within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It stores multilingual, language-specific descriptive attributes for cure and refund request header records associated with lease contract cure processing and refund transactions. As a translation table, it permits the same underlying business record to carry user-entered descriptions in multiple installed languages, in accordance with Oracle's Multi-Lingual Support (MLS) architecture.

The object is owned by the OKL schema and resides in the APPS_TS_TX_DATA tablespace, with its unique index in APPS_TS_TX_IDX. Its status is VALID in both EBS 12.1.1 and 12.2.2. Because the metadata classifies this object as standalone under the heuristic Data Vault model, it is best treated as a satellite candidate: it carries contextual, language-dependent descriptive attributes keyed to the parent header identifier rather than acting as an independent hub or link. This classification is a modeling suggestion derived from the FK structure, not a mandated Oracle construct.

Key Information Stored

The table contains ten documented columns. The most significant are:

  • CURE_REFUND_HEADER_ID (NUMBER) — Primary key column and foreign reference to the base header record. Identifies which cure/refund header the translation belongs to.
  • LANGUAGE (VARCHAR2(12)) — Language column indicating the locale for this translated row.
  • SOURCE_LANG (VARCHAR2(12)) — The source language from which the translation was derived.
  • SFWT_FLAG (VARCHAR2) — Flag used by the translation batch program to track translation status.
  • DESCRIPTION (VARCHAR2(1995)) — The user-entered, language-specific description of the header record; this is the primary translatable business attribute.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS "Who" audit columns capturing record creation and modification history.

The composite primary key is OKL_CURE_REFUND_HEADERS_TL_PK (CURE_REFUND_HEADER_ID, LANGUAGE). A unique index, OKL_CURE_REFUND_HEADERS_TL_U1, mirrors these same two columns (CURE_REFUND_HEADER_ID, LANGUAGE), confirming the business key that guarantees one translation row per header per language. The surrogate identifier is CURE_REFUND_HEADER_ID; the LANGUAGE column distinguishes variants within the same header.

Common Use Cases and Queries

Typical uses include multilingual reporting of cure and refund requests, auditing of translated descriptions, and verifying translation completeness across installed languages. A common query retrieves the localized description for a given header:

  • Join to the base table to display header context alongside the translated description filtered by the session language.
  • Filter rows where LANGUAGE = 'US' (or the target locale) after joining on CURE_REFUND_HEADER_ID.
  • Detect missing translations by comparing the set of languages in the TL table against expected installed languages for each header.
  • Reconcile the SOURCE_LANG and SFWT_FLAG columns after running the translation batch program to confirm processing status.

The documented query pattern is a straightforward SELECT over the ten columns from OKL.OKL_CURE_REFUND_HEADERS_TL. Reporting should always join to the base header table via CURE_REFUND_HEADER_ID to obtain non-translatable attributes, since only DESCRIPTION is language-specific here.

Related Objects

The metadata indicates that OKL.OKL_CURE_REFUND_HEADERS_TL does not reference any database object, and is referenced only by the internal object OKL_CURE_REFUND_HEADERS_TL#. The principal relationships to consider are:

  • OKL_CURE_REFUND_HEADERS_B — The base (B) table holding the language-independent header attributes; joined on CURE_REFUND_HEADER_ID.
  • OKL_CURE_REFUND_HEADERS_TL_PK / OKL_CURE_REFUND_HEADERS_TL_U1 — Primary key and unique index enforcing uniqueness on (CURE_REFUND_HEADER_ID, LANGUAGE).
  • OKL_CURE_REFUND_HEADERS_TL# — The internal dependent object that references this table.
  • Any OKL cure/refund API or concurrent program that reads translated descriptions will traverse this table alongside the base header.

Because the object is classified as standalone, no additional foreign key dependencies are documented; consumers should rely on the parent header identifier for all joins.