Search Results display_value

Overview

PA_AS_PROBABILITIES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) product family. In ETRM 12.2.2 the object is documented as a VIEW with a status of VALID. Its purpose is to expose the set of enabled forecast probabilities used in project forecasting and, by extension, in the derivation of forecast revenue, cost, and quantity distributions within Oracle Projects.

The view presents a simplified, query-friendly projection of the forecast probability definitions rather than exposing the full underlying descriptive flexfield structure. Each row represents a single enabled probability that may be selected during forecast entry. Consumers typically use it to populate list of values (LOVs), reports, and outbound integration extracts where a human-readable combination of the probability value and its meaning is required.

The user search term "display_value" maps directly to the DISPLAY_VALUE column defined in the view text, indicating that the requester was interested in the concatenated presentation value used by LOVs and descriptive display regions.

Underlying Base Objects

The documented metadata identifies a single referenced base object, AS_FORECAST_PROB_ALL_VL (itself a VIEW). The view text is:

• SELECT PROBABILITY_VALUE PROBABILITY_VALUE, MEANING MEANING, PROBABILITY_VALUE||' - '||MEANING DISPLAY_VALUE FROM AS_FORECAST_PROB_ALL_VL WHERE ENABLED_FLAG = 'Y'

Two behaviours follow from this definition. First, the view is a filtered projection: only rows where ENABLED_FLAG equals 'Y' are returned, so disabled probabilities are never surfaced. Second, it inherits the translation semantics of the _VL suffix on the base view, meaning MEANING is resolved according to the language of the session. Because PA_AS_PROBABILITIES_V is itself defined over a view, it does not carry stored data of its own; performance depends on the underlying probability setup tables accessed through AS_FORECAST_PROB_ALL_VL.

Key Columns

• PROBABILITY_VALUE — The stored numeric or coded value of the enabled forecast probability. This is the operational key used when a probability is attached to a forecast line.
• MEANING — The translated, user-facing description of the probability as resolved from the _VL base view for the current session language.
• DISPLAY_VALUE — A derived concatenation of PROBABILITY_VALUE, a space-hyphen-space separator, and MEANING. This column is not stored; it is computed at query time and is the column referenced by the "display_value" search term.

Common Use Cases and Queries

The view is most often used as the source for a selection list in forecast entry forms, and as a lookup in custom reports and interface extracts. A typical query returning the full ordered set is:

• SELECT display_value, probability_value, meaning FROM apps.pa_as_probabilities_v ORDER BY probability_value;

To resolve the meaning for a specific probability captured on a forecast, a join-style lookup is used:

• SELECT display_value FROM apps.pa_as_probabilities_v WHERE probability_value = :p_probability_value;

For integration interfaces that must emit only the descriptive label, the MEANING column may be selected directly. Because the view already restricts to enabled rows, no additional filter on ENABLED_FLAG is required or permitted at the consumer level.