Search Results cs_cf_flow_pages_tl_pk




Overview
Explore in AI Chat

Overview

The CS_CF_FLOW_PAGES_TL table is a core translation table within the Oracle E-Business Suite Service (CS) module, specifically supporting the Configurator Framework. Its primary role is to store language-specific, translatable text for the user interface pages defined within a configuration flow. As a translation (TL) table, it operates in conjunction with its base table, CS_CF_FLOW_PAGES_B, which holds the language-independent structural data. This design is a standard Oracle EBS pattern, enabling the application to present flow page descriptions and other textual elements in the user's session language, thereby supporting global deployments in versions 12.1.1 and 12.2.2.

Key Information Stored

The table stores translated attributes for configuration flow pages. Its structure is defined by a composite primary key and several foreign key relationships. The primary key columns are FLOW_ID, FLOW_TYPE_PAGE_ID, and LANGUAGE, which together uniquely identify a single translation record. The most critical data column is typically a description or name field (not explicitly named in the provided metadata but standard for TL tables) that holds the translated text. The SOURCE_LANG column is a standard TL table field that records the original language in which the data was entered, serving as the source for subsequent translations. The integrity of the data is enforced through foreign keys to the base flow pages table, the flows table, and the application's language tables.

Common Use Cases and Queries

This table is primarily accessed by the application runtime to render the Configurator UI in the correct language. Common technical use cases include extracting translated text for reporting, auditing translation coverage, and troubleshooting UI display issues. A typical query would join this table to its base table and the language tables to retrieve all translations for a specific flow or page. For example, to see all French translations for pages in a specific flow, one might use a query pattern such as:

  • SELECT tl.flow_id, tl.flow_type_page_id, tl.language, tl.description FROM cs_cf_flow_pages_tl tl, fnd_languages l WHERE tl.language = l.language_code AND tl.flow_id = :p_flow_id AND l.nls_language = 'FRENCH';

Data maintenance for this table is typically performed via Oracle's standard translation tools, not via direct DML.

Related Objects

The CS_CF_FLOW_PAGES_TL table has defined dependencies on several key EBS objects, as documented in the provided relationship data:

  • CS_CF_FLOW_PAGES_B (Base Table): Linked via the FLOW_TYPE_PAGE_ID foreign key. This is the primary relationship, where the TL table provides translations for the records in this base table.
  • CS_CF_FLOWS_B: Linked via the FLOW_ID foreign key, anchoring the translated page to a specific configuration flow.
  • FND_LANGUAGES (Two Relationships): The table references FND_LANGUAGES twice. The LANGUAGE foreign key validates the translation language code. The SOURCE_LANG foreign key identifies the original language of the data.

The primary key constraint CS_CF_FLOW_PAGES_TL_PK ensures uniqueness across the combination of FLOW_ID, FLOW_TYPE_PAGE_ID, and LANGUAGE.