Search Results concurrent_state_id




Overview
Explore in AI Chat

Overview

The FND_CONC_RELEASE_STATES_TL table is a core translation table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is owned by the APPLSYS schema and functions as the multilingual repository for user-facing descriptions of concurrent processing release states. This table enables the EBS application to display state names and descriptions in the language of the user's session, supporting global deployments. It is a child table to the base table FND_CONC_RELEASE_STATES, storing one record per language for each defined concurrent state. Its existence is critical for the proper localization and user interface presentation of concurrent manager functionality.

Key Information Stored

The table's structure is designed to manage translated text alongside standard EBS audit columns. The primary key is a composite of APPLICATION_ID, CONCURRENT_STATE_ID, and LANGUAGE, ensuring a unique translation per language per state. Key columns include APPLICATION_ID and CONCURRENT_STATE_ID, which together form a foreign key reference to the parent FND_CONC_RELEASE_STATES table, identifying the specific state being translated. The LANGUAGE column holds the language code (e.g., 'US', 'FR') and references the FND_LANGUAGES table. The SOURCE_LANG column, also referencing FND_LANGUAGES, indicates the original language in which the data was entered. The primary translated content is stored in the USER_CONCURRENT_STATE_NAME column. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track record creation and modifications.

Common Use Cases and Queries

This table is primarily accessed by the EBS application's internal localization engine to retrieve state descriptions for the user interface. Common technical and reporting use cases involve querying translated state names for a specific language or verifying translation coverage. A typical query to retrieve all translations for a specific concurrent state would join to the base table and the languages table. For example, to see the French translation for all states, one might use: SELECT crs.concurrent_state_code, tl.user_concurrent_state_name FROM fnd_conc_release_states crs, fnd_conc_release_states_tl tl WHERE crs.application_id = tl.application_id AND crs.concurrent_state_id = tl.concurrent_state_id AND tl.language = 'F';. Administrators may also query this table to identify states missing translations for a target language by performing an outer join between the base table and the TL table filtered for that language.

Related Objects

The FND_CONC_RELEASE_STATES_TL table has defined relationships with several key EBS foundation objects, as documented in the provided metadata. Its primary foreign key dependency is on the base table FND_CONC_RELEASE_STATES, using the columns APPLICATION_ID and CONCURRENT_STATE_ID. For language reference, it has two foreign keys to the FND_LANGUAGES table: one on the LANGUAGE column and another on the SOURCE_LANG column. For audit trail integrity, it references the FND_USER table twice (for CREATED_BY and LAST_UPDATED_BY) and the FND_LOGINS table (for LAST_UPDATE_LOGIN). These relationships ensure data consistency across the application's foundational schema.