Search Results csc_plan_headers_tl_pk

Overview

The CSC_PLAN_HEADERS_TL table is a core data object within the Oracle E-Business Suite Customer Care (CSC) module. It functions as a translation table, specifically designed to store multilingual versions of the name and description for plan templates. Its primary role is to support the global deployment of the application by enabling the presentation of plan template information in a user's preferred language. The table operates in conjunction with its base table, CSC_PLAN_HEADERS_B, which holds the language-independent, transactional data for plan templates. This separation of language-specific attributes from core business data is a standard Oracle Applications architecture pattern for enabling multilingual capabilities.

Key Information Stored

The table stores translated text attributes for each plan template. While the full column list is not detailed in the provided metadata, the structure of a typical Translation (TL) table and the documented primary key imply the presence of several critical columns. The composite primary key consists of PLAN_ID and LANGUAGE. The PLAN_ID is a foreign key that uniquely identifies the associated plan template record in the CSC_PLAN_HEADERS_B table. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'KO' for Korean) for the translation. Based on the description, the table's main data columns are NAME and DESCRIPTION, which contain the translated text for the plan template's title and descriptive details, respectively. Additional standard TL table columns often include SOURCE_LANG, CREATED_BY, and LAST_UPDATED_BY for tracking data origin and changes.

Common Use Cases and Queries

The primary use case is retrieving plan template information in a specific language for user interfaces, reports, and integrations. A common query pattern joins this table with its base table to fetch a complete, localized view of a plan. For example, to retrieve all plan details in American English, a developer might use:

SELECT b.plan_id, tl.name, tl.description, b.other_columns
FROM csc_plan_headers_b b, csc_plan_headers_tl tl
WHERE b.plan_id = tl.plan_id
AND tl.language = USERENV('LANG');

Another critical scenario involves data migration or initialization scripts, where translated seed data for plan templates must be populated into this table for each supported language. Reporting on the availability of translations for audit purposes is also a common administrative task.

Related Objects

The CSC_PLAN_HEADERS_TL table has a direct and essential relationship with its base table, as documented in the provided metadata. The key relationship is:

Foreign Key Reference to CSC_PLAN_HEADERS_B: The PLAN_ID column in CSC_PLAN_HEADERS_TL is a foreign key that references the PLAN_ID in the CSC_PLAN_HEADERS_B table. This enforces referential integrity, ensuring every translation record is linked to a valid base plan template. Any query for localized plan data will typically involve an equi-join on this column.

As a TL table, it is also intrinsically related to the Oracle Applications' multilingual architecture (FND_LANGUAGES), which provides the valid list of language codes. The table's primary key constraint, CSC_PLAN_HEADERS_TL_PK, ensures uniqueness for each combination of language and plan.

Table: CSC_PLAN_HEADERS_TL 12.1.1
owner:CSC, object_type:TABLE, fnd_design_data:CSC.CSC_PLAN_HEADERS_TL, object_name:CSC_PLAN_HEADERS_TL, status:VALID, product: CSC - Customer Care , description: CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEADERS_B table. , implementation_dba_data: CSC.CSC_PLAN_HEADERS_TL ,
Table: CSC_PLAN_HEADERS_TL 12.2.2
owner:CSC, object_type:TABLE, fnd_design_data:CSC.CSC_PLAN_HEADERS_TL, object_name:CSC_PLAN_HEADERS_TL, status:VALID, product: CSC - Customer Care , description: CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEADERS_B table. , implementation_dba_data: CSC.CSC_PLAN_HEADERS_TL ,
eTRM - CSC Tables and Views 12.1.1
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,
eTRM - CSC Tables and Views 12.2.2
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,
eTRM - CSC Tables and Views 12.2.2
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,
eTRM - CSC Tables and Views 12.1.1
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,