Results for “cure_refund_header_id”

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

Overview

OKL_CURE_REFUND_HEADERS_TL is the translation (TL) table belonging to the Oracle Lease and Finance Management (OKL) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-dependent, translatable columns associated with refund request headers originating from refund processing for terminated or restructured lease contracts. Per the documented ETRM metadata, this table holds "translatable columns from OKL_CURE_REFUND_REQUESTS_B, per MLS standards," meaning it follows the Oracle Multi-Lingual Support (MLS) model where each base row is represented in one or more installed languages.

Under the heuristic Data Vault classification mined from its foreign-key structure, this object is identified as standalone. As a modeling suggestion, a standalone classification indicates the table does not participate in a traditional parent-child FK chain that would mark it as a pure hub or link; instead its identity is defined entirely by its composite primary key. It functions conceptually as a satellite-like repository of descriptive, translatable attributes keyed to the refund header, but the documentation treats it as an independent translation entity.

Key Information Stored

The table is composed of 10 documented columns. The most significant are described below.

• CURE_REFUND_HEADER_ID — The surrogate identifier of the refund header. It is the first component of the composite primary key OKL_CURE_REFUND_HEADERS_TL_PK and also appears in the unique index OKL_CURE_REFUND_HEADERS_TL_U1. It joins the translation rows back to the base refund header record.
• LANGUAGE — The installation language code for the translatable text. Combined with CURE_REFUND_HEADER_ID it forms the composite primary key and the unique business-key candidate.
• SOURCE_LANG — The source language from which the translation was derived, per MLS conventions.
• SFWT_FLAG — The "Seed/Fully Translated/Word Translated" flag characteristic of Oracle MLS translation tables, used to track translation completeness and seeding status.
• DESCRIPTION — The translated, user-visible description text of the refund header.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle who-columns recording audit and concurrency information.

The surrogate primary key is the combination of CURE_REFUND_HEADER_ID and LANGUAGE. The unique index OKL_CURE_REFUND_HEADERS_TL_U1 on the same two columns confirms the business-key candidate: a refund header may have only one translation row per language.

Common Use Cases and Queries

Typical usage centers on presenting refund header descriptions in the user's session language while preserving base (untranslated) data in the corresponding _B table. A common retrieval pattern joins the translation table to the base refund header on CURE_REFUND_HEADER_ID and filters by the current language, or falls back to the source language when no translation exists.

• Refund inquiry screens displaying a localized DESCRIPTION for a given refund header.
• Multilingual reporting that lists refund requests with translated descriptions alongside operational amounts from the base table.
• Data-quality checks that detect missing translations, for example refund headers lacking a row for a required language.
• Audit queries examining CREATED_BY, CREATION_DATE, and LAST_UPDATED_BY to trace who introduced or modified a translation.

A representative query selecting a specific translation would filter on CURE_REFUND_HEADER_ID and LANGUAGE, returning DESCRIPTION and the audit columns. A translation-completeness query would aggregate by LANGUAGE and compare translated row counts against the base table.

Related Objects

The principal dependency is the base entity from which the translatable columns originate. The most significant related objects include:

• OKL_CURE_REFUND_REQUESTS_B — The base table holding the untranslated refund header columns; joined on CURE_REFUND_HEADER_ID.
• OKL_CURE_REFUND_HEADERS_TL_PK — The primary-key constraint on CURE_REFUND_HEADER_ID and LANGUAGE.
• OKL_CURE_REFUND_HEADERS_TL_U1 — The unique index enforcing one translation per header per language.
• FND_LANGUAGES — The language definition reference validating LANGUAGE values in MLS deployments.
• Other OKL_CURE_REFUND_* objects — Companion refund request components in the OKL module that share the refund header identity.

Because the metadata classifies this object as standalone, dependencies are primarily translational rather than participating in complex foreign-key chains.