Search Results cscpcrtl_pk




Overview
Explore in AI Chat

Overview

The CSC_PROF_CHECK_RULES_TL table is a translation table within the Oracle E-Business Suite Customer Care (CSC) module. It is a core data object that stores the translated, language-specific textual descriptions for profile check rules. Its primary role is to support the multilingual capabilities of the application by holding user-facing rule names and descriptions in multiple languages, while the base transactional data (such as the rule's condition logic and active status) is stored in its parent table, CSC_PROF_CHECK_RULES_B. This separation is a standard Oracle Applications architecture pattern, enabling a single installation to serve users in different locales.

Key Information Stored

The table's structure is designed to manage translations for unique rule definitions. The key columns, which also form the table's primary key (CSCPCRTL_PK), are CHECK_ID, SEQUENCE, and LANGUAGE. The CHECK_ID and SEQUENCE columns together form a foreign key back to the base table (CSC_PROF_CHECK_RULES_B), uniquely identifying a specific rule condition. The LANGUAGE column holds the language code (e.g., 'US' for American English) for the translation. The most critical data columns are typically NAME and DESCRIPTION, which store the translated, user-readable label and explanatory text for the profile check rule. These translations are what appear in the application's user interface.

Common Use Cases and Queries

The primary use case is the dynamic presentation of rule information in the user's session language within the Customer Care application's profile checking features. For reporting and data extraction, queries often join this table with its base table to produce a complete, language-specific view of all configured rules. A common sample SQL pattern is:

  • SELECT b.CHECK_ID, tl.NAME, tl.DESCRIPTION, b.CONDITION
  • FROM csc_prof_check_rules_b b,
  • csc_prof_check_rules_tl tl
  • WHERE b.check_id = tl.check_id
  • AND b.sequence = tl.sequence
  • AND tl.language = USERENV('LANG');

This query retrieves the rule's operational condition from the base table alongside the translated name and description for the current user's language. Administrators may also query this table to audit or manage translation completeness across installed languages.

Related Objects

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

  • CSC_PROF_CHECK_RULES_B: This is the primary related object. The CSC_PROF_CHECK_RULES_TL table references it via the columns CHECK_ID and SEQUENCE (CSC_PROF_CHECK_RULES_TL.CHECK_ID, CSC_PROF_CHECK_RULES_TL.SEQUENCE → CSC_PROF_CHECK_RULES_B). Every record in the translation table must correspond to a valid record in this base table. The base table stores the rule's condition, active date range, and other functional attributes.

This table is typically accessed via the standard Oracle Applications translation views or through the module's public APIs, rather than via direct DML, to maintain data integrity.

  • Table: CSC_PROF_CHECK_RULES_TL 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RULES_TL,  object_name:CSC_PROF_CHECK_RULES_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RULES_TL , 

  • Table: CSC_PROF_CHECK_RULES_TL 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECK_RULES_TL,  object_name:CSC_PROF_CHECK_RULES_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check ,  implementation_dba_data: CSC.CSC_PROF_CHECK_RULES_TL , 

  • 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 , 

  • 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 ,