Search Results forecast_rule_id




Overview
Explore in AI Chat

Overview

The CSP_FORECAST_RULES_TL table is a core data object within the Oracle E-Business Suite (EBS) Spares Management (CSP) module. It functions as the translation table for forecast rule definitions, enabling the support of multiple languages within a global deployment. This table stores the language-specific, user-facing descriptions and names for forecast rules, while the base transactional data, such as the rule logic and system identifiers, is maintained in its parent table, CSP_FORECAST_RULES_B. Its primary role is to facilitate a multilingual user interface and reporting environment, ensuring that forecast rule information is presented in the user's preferred language as defined by the EBS session.

Key Information Stored

The table's structure is characteristic of Oracle EBS translation tables. The most critical columns are those comprising its primary key and the translatable attributes. The FORECAST_RULE_ID column is the foreign key linking each translated record to its corresponding base definition. The LANGUAGE column holds the language code (e.g., 'US', 'DE', 'JA') for the translation. The SOURCE_LANG column typically identifies the original language of the record. The core translatable data is stored in columns such as RULE_NAME and DESCRIPTION, which contain the human-readable name and explanatory text for the forecast rule in the specified language. Standard audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are also present.

Common Use Cases and Queries

The primary use case is retrieving forecast rule descriptions for display in forms, reports, and LOVs in the user's session language. A typical query joins this table with its base table, filtering on both the rule identifier and the session language. For example, to fetch all active forecast rule names for the current EBS session language, a developer might use:

  • SELECT b.FORECAST_RULE_ID, tl.RULE_NAME, tl.DESCRIPTION
  • FROM CSP_FORECAST_RULES_B b, CSP_FORECAST_RULES_TL tl
  • WHERE b.FORECAST_RULE_ID = tl.FORECAST_RULE_ID
  • AND tl.LANGUAGE = USERENV('LANG');

Another common scenario involves data migration or reporting, where all translations for a specific rule are needed, often joined with FND_LANGUAGES to get the language name.

Related Objects

The table has a direct and essential relationship with its base table, as defined by the documented foreign key. The primary related objects are:

  • CSP_FORECAST_RULES_B: This is the base table for forecast rule definitions. The relationship is enforced by the foreign key where CSP_FORECAST_RULES_TL.FORECAST_RULE_ID references CSP_FORECAST_RULES_B.FORECAST_RULE_ID. All transactional integrity and core rule data flow through this relationship.
  • FND_LANGUAGES: Although not a formal foreign key in the provided metadata, this application dictionary table is conceptually related. The LANGUAGE column in CSP_FORECAST_RULES_TL corresponds to valid language codes defined within FND_LANGUAGES.

Any EBS form, concurrent program, or API within the Spares Management module that displays forecast rule information will inherently query this translation table to present localized data.