Search Results pa_probability_lists_u1

Overview

PA.PA_PROBABILITY_LISTS is a seed-data reference table in the Oracle Projects (PA) schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the probability lists that Oracle Projects uses to qualify pipeline and forecast information, most notably in Oracle Project Resource Management, Oracle Project Management, and opportunity-style reporting where a set of weighted probabilities is associated with a project or resource forecast. Each row defines one named probability list, together with its validity window and a descriptive flexfield structure.

The table is registered in FND Design Data as PA.PA_PROBABILITY_LISTS and is assigned to the APPS_TS_SEED tablespace, confirming its role as reference/seed data rather than high-volume transactional data. Under the heuristic Data Vault classification supplied in the metadata, this object is modeled as a standalone structure — effectively a hub candidate keyed on its business key, with no downstream link or satellite dependencies mined from the foreign key graph. Its primary key is documented as PA_PROBABILITY_LISTS_PK.

Key Information Stored

The table contains 26 documented columns. The most significant are:

• PROBABILITY_LIST_ID (NUMBER 15) — the system-generated surrogate identifier uniquely identifying each probability list. In practice this is the value propagated to dependent child tables.
• NAME (VARCHAR2 80) — user-defined name that uniquely identifies the probability list. This is the business key; it is protected by the unique index PA_PROBABILITY_LISTS_U1 and is also documented as the primary key column of PA_PROBABILITY_LISTS_PK.
• DESCRIPTION (VARCHAR2 240) — free text describing the purpose or scope of the list.
• START_DATE_ACTIVE and END_DATE_ACTIVE (DATE) — the effective-dating window controlling when the list may be selected or used. A null end date conventionally indicates an open-ended list.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns for audit and concurrency tracking, populated by the framework on insert and update.
• ATTRIBUTE_CATEGORY (VARCHAR2 30) plus ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2 150 each) — the descriptive flexfield structure and segment columns, allowing installations to capture additional site-specific attributes without a schema change.

The distinction between surrogate and business keys is important: developers should join child tables on PROBABILITY_LIST_ID, while user-facing lookups and validation logic typically resolve via NAME, whose uniqueness is enforced by PA_PROBABILITY_LISTS_U1.

Common Use Cases and Queries

Typical usage includes validating a list name entered in a setup form, retrieving the identifier for a named list prior to inserting dependent rows, and reporting all currently active lists. Queries commonly filter on the DATE columns to exclude expired entries and on ATTRIBUTE_CATEGORY when a descriptive flexfield context is in use.

• Resolve a list by name: SELECT probability_list_id, name, start_date_active, end_date_active FROM pa.pa_probability_lists WHERE name = :p_name;
• Enumerate active lists: SELECT probability_list_id, name, description FROM pa.pa_probability_lists WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
• Audit recently changed setup: SELECT name, last_updated_by, last_update_date FROM pa.pa_probability_lists ORDER BY last_update_date DESC;
• Dependent-row validation: join child records to this table on PROBABILITY_LIST_ID to detect orphans or verify the associated NAME.

Related Objects

Because the metadata classifies this object as standalone, no foreign keys were mined from it; relationships are therefore expressed from the dependent side. The most significant related objects are those that carry PROBABILITY_LIST_ID as a lookup to this table, together with the standard setup validation and flexfield components:

• PA_PROBABILITY_LIST_LINES (or equivalent line-level table in the PA probability model) — joins on PROBABILITY_LIST_ID and holds the individual probability values and weights belonging to each list.
• PA_PROJECTS_ALL and PA_PROJECTS — may reference a probability list for project-level forecast qualification.
• PA_PROJECT_RESOURCES / resource forecast tables — consume probability lists when weighting resource pipeline entries.
• PA_LOOKUPS and other PA setup tables — referenced alongside NAME for validation and value-set behaviour.
• FND_DESCR_FLEX_COLUMN_USAGES and the PA descriptive flexfield definition — supports ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.
• FND_FLEX_VALUES_VL — where list names are surfaced through a value set for user selection.

Pluggable consumers such as Oracle Project Resource Management and Oracle Project Management read these relationships through the Projects foundation APIs rather than direct DML; direct inserts should therefore be avoided except during controlled data migration.