Search Results as_forecast_prob_all_tl




Overview
Explore in AI Chat

Overview

The AS_FORECAST_PROB_ALL_TL table is a core translation table within the Oracle E-Business Suite (EBS) Sales Foundation module. It functions as the Multi-Language Support (MLS) layer for its base table, AS_FORECAST_PROB_ALL_B. Its primary role is to store translated textual descriptions for sales forecast probability values, enabling the application to display user-friendly probability names (e.g., "High," "Medium," "Low") in the language of the user's session. This design is a standard Oracle EBS pattern for supporting global deployments, separating language-invariant data (stored in the "_B" base table) from language-specific descriptions (stored in the "_TL" table). The table is owned by the OSM schema and is valid for both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and unique keys, which dictate the data it holds. The primary data elements are the probability value and its corresponding translated description for a specific language. According to the provided metadata, the table has two defined keys: a primary key (AS_FORECAST_PROB_ALL_TL_PK) on the combination of PROBABILITY_VALUE and LANGUAGE, and a unique key (AS_FORECAST_PROB_ALL_TL_UK) on LANGUAGE and PROBABILITY_VALUE. This indicates that for each unique probability value, there can be one translated record per language code (e.g., US, DE, FR). A typical implementation would include columns such as PROBABILITY_VALUE (the key linking to the base table), LANGUAGE (the ISO language code), SOURCE_LANG, DESCRIPTION (the translated text), and CREATION_DATE/CREATED_BY columns for auditing.

Common Use Cases and Queries

The primary use case is the dynamic rendering of forecast probability lists in Oracle EBS forms and reports based on the user's session language. Application logic automatically joins this table to the base table using the PROBABILITY_VALUE and the NLS_LANGUAGE session parameter. A common reporting query would retrieve all translations for administrative purposes. For example:

  • SELECT PROBABILITY_VALUE, LANGUAGE, DESCRIPTION FROM OSM.AS_FORECAST_PROB_ALL_TL WHERE LANGUAGE = 'DE'; – To review German translations.
  • SELECT B.PROBABILITY_VALUE, TL.DESCRIPTION FROM OSM.AS_FORECAST_PROB_ALL_B B, OSM.AS_FORECAST_PROB_ALL_TL TL WHERE B.PROBABILITY_VALUE = TL.PROBABILITY_VALUE AND TL.LANGUAGE = USERENV('LANG'); – To join the base and translation tables for the current session language.

Direct data manipulation in this table is typically performed via Oracle's standard translation utilities or APIs rather than manual DML.

Related Objects

This table has a direct and fundamental relationship with its base table, AS_FORECAST_PROB_ALL_B, as indicated by the documented foreign key. The foreign key constraint on the PROBABILITY_VALUE column ensures referential integrity, meaning every record in the "_TL" table must correspond to a valid probability value in the "_B" table. As part of the Sales Foundation module, it supports objects within the Oracle Sales (AS) application, particularly those involving sales forecasting and pipeline management. The table may be accessed by various application programming interfaces (APIs) in the OSM schema and by views that present a language-aware perspective on forecast probability data.