Results for “okl_txl_rcpt_apps_tl”

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

Overview

OKL_TXL_RCPT_APPS_TL is the translation (TL) table for the Oracle Leasing and Finance Management (OKL) receipts application entity. It stores the language-dependent, translatable attributes of the base table OKL_TXL_RCPT_APPS_B, following Oracle Multi-Lingual Support (MLS) standards. The "_TL" suffix denotes a translated table that carries one row per installed language, whereas the "_B" base table holds language-independent columns shared across all languages. This pairing is a standard EBS pattern and allows the application to present user-facing descriptive text in the session language without duplicating non-translatable data.

Per the supplied metadata, the object resides in the OKL schema, is valid, and is documented as part of the ETRM 12.2.2 physical schema with 10 columns. The heuristic Data Vault classification mined from the foreign-key structure is standalone. As a modeling suggestion, this implies the table is best treated as a descriptive satellite of the base entity rather than as a hub or link, since no outgoing foreign keys are documented. The translation rows are keyed to the base entity and a language code, so they naturally behave as a language-attribute satellite.

Key Information Stored

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

• ID — surrogate identifier of the underlying base record; part of the primary key.
• LANGUAGE — the language code of the translation; the second component of the primary key.
• SOURCE_LANG — the source language from which the translation was derived, supporting MLS language hierarchy.
• SFWT_FLAG — the "Seed/Force/Translate" flag used by Oracle's translation framework to indicate the translation state of the row.
• DESCRIPTION — the translated descriptive text for the receipt application.
• CREATED_BY, CREATION_DATE — standard WHO columns recording row authorship and creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns recording the last modifier, timestamp, and login.

The primary key is documented as OKL_TXL_RCPT_APPS_TL_PK (ID, LANGUAGE). A unique index, OKL_TXL_RCPT_APPS_TL_U1 (ID, LANGUAGE), is also documented. Because the unique index mirrors the primary key columns, it functions as the business-key candidate. No separate surrogate or business key column beyond the composite (ID, LANGUAGE) is documented here; the composite key alone distinguishes translations of the same base record across languages.

Common Use Cases and Queries

Typical use is joining the translation table to its base table to retrieve descriptive text in the current session language, and to report on translation coverage per language. A representative query pattern:

• Join OKL_TXL_RCPT_APPS_B b, OKL_TXL_RCPT_APPS_TL t ON t.ID = b.ID AND t.LANGUAGE = USERENV('LANG') to retrieve translated DESCRIPTION for the active language.
• Query t.LANGUAGE = 'US' for the seeded American English row, or count rows grouped by LANGUAGE to measure translation completeness.
• Filter on SOURCE_LANG and SFWT_FLAG to audit translation state or identify rows pending translation.
• Report on LAST_UPDATE_DATE and LAST_UPDATED_BY to track recent translation maintenance.

Because the table is small and keyed by ID and LANGUAGE, these queries are inexpensive and suitable for concurrent reporting and concurrent-manager jobs.

Related Objects

The following objects are the most significant related items, based on the documented relationship data:

• OKL_TXL_RCPT_APPS_B — the language-independent base table; joined on ID.
• OKL_TXL_RCPT_APPS_TL_PK — the documented primary key constraint on (ID, LANGUAGE).
• OKL_TXL_RCPT_APPS_TL_U1 — the documented unique index on (ID, LANGUAGE).

Because the table is documented as standalone, no further FK-dependent child objects are confirmed in the supplied metadata. Implementers should treat OKL_TXL_RCPT_APPS_B as the authoritative parent and this table as its language-dependent companion.