Results for “fnd_conc_state_lookups_tl”

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

Overview

FND_CONC_STATE_LOOKUPS_TL is the translation table for FND_CONC_STATE_LOOKUPS, residing in the APPLSYS schema and belonging to the FND — Application Object Library product. It stores the language-specific display text (meaning and description) associated with each concurrent program state lookup value defined in the base table. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the multilingual rendering of concurrent manager state values such as Pending, Running, Completed, Error, and Inactive, ensuring that users see state names in their session language rather than an internal code.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification identifies this object as a link. This classification is a modeling suggestion rather than a physical design directive: the table joins the base lookup entity to a language dimension, making it structurally comparable to a relationship or reference-language bridge. In practice it functions as a translation satellite attached to the FND_CONC_STATE_LOOKUPS hub, keyed by the combination of lookup identity and language.

Key Information Stored

The documented physical schema for 12.2.2 contains eleven columns. The most significant are:

• LOOKUP_TYPE_ID — Identifier linking the row to its parent lookup definition in FND_CONC_STATE_LOOKUPS; part of the primary key and the foreign key to the base table.
• LOOKUP_VALUE — The internal lookup code (for example, the concurrent state code); part of the primary key.
• LANGUAGE — The language for which this translation applies, validated against FND_LANGUAGES; completes the primary key.
• SOURCE_LANG — The source language from which the translation was derived, also validated against FND_LANGUAGES.
• MEANING — The translated, user-visible label for the lookup value.
• DESCRIPTION — The translated descriptive text for the lookup value.
• CREATED_BY, CREATION_DATE — Standard audit columns capturing row creation context.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns capturing the most recent modification.
• LAST_UPDATE_LOGIN — The login session associated with the last update, referencing FND_LOGINS.

The surrogate primary key is defined by FND_CONC_STATE_LOOKUPS_TL_PK, comprising LOOKUP_TYPE_ID, LOOKUP_VALUE, and LANGUAGE. A unique index, FND_CONC_STATE_LOOKUPS_TL_U1, covers the same three columns and serves as the documented business-key candidate, enforcing that only one translated row exists per lookup value per language.

Common Use Cases and Queries

The table is most frequently used to resolve the display text for concurrent request states in user-facing reports, concurrent manager dashboards, and custom notification logic. A typical reporting query joins it to the base lookup table and filters to the session language:

• State label resolution — Join FND_CONC_STATE_LOOKUPS_TL to FND_CONC_STATE_LOOKUPS on LOOKUP_TYPE_ID and LOOKUP_VALUE, selecting MEANING for a specified LANGUAGE, to render human-readable state names for concurrent requests in FND_CONCURRENT_REQUESTS.
• Multi-language validation — Group by LOOKUP_VALUE and count distinct LANGUAGE values to determine which states lack translation in specific installed languages.
• Translation maintenance — Filter by LANGUAGE to audit existing translations or identify rows where MEANING remains untranslated relative to SOURCE_LANG.
• Audit extraction — Restrict on LAST_UPDATE_DATE and join LAST_UPDATED_BY to FND_USER to track who modified state descriptions and when.

Related Objects

The following objects are the most significant dependencies based on the documented foreign keys and primary key structure:

• FND_CONC_STATE_LOOKUPS — The base lookup table; joined on LOOKUP_TYPE_ID and LOOKUP_VALUE to associate translations with their parent definitions.
• FND_LANGUAGES — Referenced twice, via LANGUAGE and SOURCE_LANG, providing installed language validation.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY for audit attribution.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN to identify the update session.
• FND_CONCURRENT_REQUESTS — Stores the state code that this translation table ultimately renders into a user-visible label.