Results for “okl_cost_adjustments_tl”

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

Overview

OKL_COST_ADJUSTMENTS_TL is the translation table for OKL_COST_ADJUSTMENTS_B within the OKL (Lease and Finance Management) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-dependent, user-facing text attributes associated with cost adjustment records, allowing the same underlying adjustment definition to be presented in multiple installed languages. In the standard Oracle EBS multilingual architecture, the _B table holds language-independent business data while the _TL table holds the translatable descriptive columns; each row in the TL table is uniquely identified by the combination of the base record identifier and a LANGUAGE code.

From a Data Vault modeling perspective, the mined foreign-key and key structure classifies this object heuristically as a standalone table. It can therefore be treated as a satellite-type structure attached to the business key of its base table, capturing descriptive, time-variant text rather than relationships between entities. No link semantics are implied by the documented key structure.

Key Information Stored

The table is documented with 12 columns in the ETRM 12.2.2 physical schema. The most significant are:

• ID — Surrogate identifier inherited from OKL_COST_ADJUSTMENTS_B; part of the composite primary key OKL_CDJT_PK.
• LANGUAGE — The NLS language code for the translated row; the second component of the composite primary key and the discriminator that makes each ID unique per language.
• SOURCE_LANG — The language in which the source record was originally created, used by the translation framework to detect whether a translation reflects the base language.
• SFWT_FLAG — The "Seed/Force/Whatever/Translation" flag used by Oracle's translation seed framework to control how translated rows are generated and refreshed.
• SHORT_DESCRIPTION — The translatable short name or label for the cost adjustment.
• DESCRIPTION — The translatable long description of the cost adjustment, typically the primary user-facing text.
• COMMENTS — Additional translatable free-text commentary.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns providing audit and concurrency information.

The surrogate primary key is (ID, LANGUAGE). The base-table ID is the business-key candidate that links a TL row to its corresponding language-independent record in OKL_COST_ADJUSTMENTS_B.

Common Use Cases and Queries

Typical usage involves joining the TL table to its base table and filtering on the session language, or reporting across languages for translation completeness. A representative query pattern is:

• Retrieve translated descriptions for the current language: SELECT b.id, t.short_description, t.description FROM okl.okl_cost_adjustments_b b, okl.okl_cost_adjustments_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Detect missing translations: compare the count of rows per ID in the TL table against the set of installed languages to identify adjustments lacking entries for a given LANGUAGE.
• Copy or update translations: insert or update TL rows keyed by (ID, LANGUAGE), maintaining the audit columns and SOURCE_LANG for framework consistency.
• Reporting: join to the base table and downstream lease/finance objects to present localized adjustment labels on cost adjustment reports.

Direct DML should generally be avoided in favor of the supported Lease Management APIs that maintain both the _B and _TL rows in sync.

Related Objects

• OKL_COST_ADJUSTMENTS_B — The base (language-independent) table; joined on B.ID = TL.ID and the foundation for all translation rows.
• OKL_COST_ADJUSTMENTS_VL — The standard EBS view that unions the base and translated tables, commonly queried in place of the underlying tables.
• OKL_COST_ADJUSTMENTS — Where present, the primary transactional or header entity for cost adjustment data referenced by the base table.
• FND_LANGUAGES — Reference table providing valid values for the LANGUAGE column.
• OKL_LEASE_COST_ADJUSTMENTS — Lease-level association linking adjustments to leases, dependent on the base table's ID.

Because the documented relationship classification is standalone, no mandatory foreign keys within the TL table itself are asserted beyond its dependency on the base table's ID.