Results for “as_forecast_prob_all_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AS_FORECAST_PROB_ALL_TL is a translation (Multi-Lingual Support, MLS) table owned by the OSM schema within the AS – Sales Foundation product of Oracle E-Business Suite. Its documented purpose is to hold the translated columns of the base table AS_FORECAST_PROB_ALL_B, which stores forecast probability definitions used by the sales forecasting functionality. In the standard EBS MLS architecture, the "_B" table carries language-independent attributes and one row per entity, while the "_TL" table carries the language-dependent descriptive text, typically one row per entity per installed language. This table therefore supplies the user-facing meaning of each forecast probability, resolved at runtime according to the session's language.

Based on the foreign key and primary key structure mined from the ETRM metadata, the recommended Data Vault classification is satellite-leaning. The table does not introduce its own business entity; it depends on AS_FORECAST_PROB_ALL_B, which functions as the hub-like parent, and the "_TL" rows behave as descriptive satellites keyed by the parent identifier plus language.

Key Information Stored

The table contains 10 documented columns. The primary key AS_FORECAST_PROB_ALL_TL_PK is composite, consisting of PROBABILITY_VALUE and LANGUAGE. PROBABILITY_VALUE is the identifier that links back to AS_FORECAST_PROB_ALL_B and is the effective business-key candidate; the unique index AS_FORECAST_PROB_ALL_TL_UK also spans LANGUAGE and PROBABILITY_VALUE, confirming that the pair is unique across the table. LANGUAGE identifies the translated language of the row.

• PROBABILITY_VALUE – parent identifier and part of the composite primary key, joined to AS_FORECAST_PROB_ALL_B.
• LANGUAGE – language code for the translated content; second component of the primary key.
• SOURCE_LANG – the source language from which the translation originated.
• MEANING – the translated descriptive text of the forecast probability, the principal user-facing value.
• SECURITY_GROUP_ID – foreign key to FND_SECURITY_GROUPS, supporting multi-tenant/security-group data isolation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – standard EBS WHO columns providing audit and concurrency information.

Note that the descriptive text is physically modeled through MEANING rather than an explicitly named column per locale, and the surrogate identity is effectively the (PROBABILITY_VALUE, LANGUAGE) pair.

Common Use Cases and Queries

Typical usage is to resolve the display name of a forecast probability for reporting, extraction, or LOV population in a specific language. A translation lookup joins the base and translation tables on the shared key and filters by language:

• Reporting the probability label: SELECT b.probability_value, t.meaning FROM as_forecast_prob_all_b b, as_forecast_prob_all_tl t WHERE b.probability_value = t.probability_value AND t.language = USERENV('LANG');
• Auditing missing translations by comparing base rows against available language rows in AS_FORECAST_PROB_ALL_TL.
• Extracting a multi-language dataset for data warehouse loading, using SECURITY_GROUP_ID to scope results by security group.
• Validating referential integrity between the "_B" and "_TL" tables when diagnosing incomplete MLS setups.

Related Objects

• AS_FORECAST_PROB_ALL_B – base table; joined on AS_FORECAST_PROB_ALL_TL.PROBABILITY_VALUE = AS_FORECAST_PROB_ALL_B.PROBABILITY_VALUE.
• FND_SECURITY_GROUPS – referenced via SECURITY_GROUP_ID for data security grouping.
• AS_FORECAST_PROB_ALL_TL_PK / AS_FORECAST_PROB_ALL_TL_UK – primary and unique constraints enforcing key integrity.
• FND_LANGUAGES – indirectly related through the LANGUAGE column for language validation.
• AS forecast setup and sales forecasting forms/LOVs – consumer components that display translated probability meanings.