Search Results fnd_concurrent_programs_tl

Overview

The FND_CONCURRENT_PROGRAMS_TL table is a core Application Object Library table within the Oracle E-Business Suite (EBS) architecture, specifically designed to support multilingual implementations. It stores translated text for concurrent program definitions, enabling the user interface to display program names and descriptions in a user's preferred language. This table operates as a child to the base table FND_CONCURRENT_PROGRAMS, which holds the primary, language-independent program definition. The existence of this translation table is fundamental to the EBS Multi-Org Access Control (MOAC) and global deployment model, ensuring that concurrent programs—a central component of batch processing—are accessible and understandable to users worldwide.

Key Information Stored

The table's structure is centered on a composite primary key that uniquely identifies each translation row. The key columns are APPLICATION_ID, CONCURRENT_PROGRAM_ID, and LANGUAGE. The APPLICATION_ID and CONCURRENT_PROGRAM_ID columns form a foreign key relationship back to the FND_CONCURRENT_PROGRAMS table, linking the translation to its specific program. The LANGUAGE column holds the ISO language code (e.g., 'US' for American English). The primary translated attributes are USER_CONCURRENT_PROGRAM_NAME and DESCRIPTION, which hold the end-user visible name and explanatory text for the program in the specified language. A unique key constraint (FND_CONCURRENT_PROGRAMS_TL_UK1) on APPLICATION_ID, USER_CONCURRENT_PROGRAM_NAME, and LANGUAGE ensures translated names remain unique within an application and language.

Common Use Cases and Queries

This table is primarily accessed for generating localized reports, troubleshooting display issues, and auditing translations. A common technical query involves joining to the base table to retrieve a program's translated name for the current session language, which is essential for custom reports or interfaces. For example:

• SELECT fcp.concurrent_program_name, fcptl.user_concurrent_program_name, fcptl.description FROM fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcptl WHERE fcp.application_id = fcptl.application_id AND fcp.concurrent_program_id = fcptl.concurrent_program_id AND fcptl.language = USERENV('LANG');

Administrators may query this table to identify missing translations for critical programs or to verify that program names are consistent across different language installations. During upgrades or migrations, scripts often reference this table to preserve or update translated content.

Related Objects

The most critical relationship for FND_CONCURRENT_PROGRAMS_TL is its foreign key dependency on the base definition table, FND_CONCURRENT_PROGRAMS. All translations are meaningless without this parent record. From a functional perspective, this table is accessed by the standard Concurrent Manager APIs and the underlying forms and pages used to define concurrent programs (e.g., the "Define Concurrent Program" form). The view FND_CONCURRENT_PROGRAMS_VL, a common source for reporting, typically joins the base and translation tables to present a complete, language-sensitive record. Developers interact with these translations programmatically via the FND_PROGRAM package and related APIs, which handle the logic for retrieving the correct translation based on the user's session.