Search Results pa_probability_members_u2

Overview

The PA.PA_PROBABILITY_MEMBERS table is a seeding and configuration table within the Oracle E-Business Suite Projects (PA) schema. It stores the individual members that collectively define a probability list, where each member carries a probability percentage representing the likelihood that a project will be approved. Probability lists are used during project creation and funding to apply weighted probability percentages that drive revenue and cost forecasting, particularly in the context of Project Resource Management and Project Billing.

The table resides in the APPS_TS_SEED tablespace, consistent with its role as reference or seeded configuration data. Under the heuristic Data Vault classification derived from its foreign-key structure, this object is best described as a standalone table, functioning effectively as a hub candidate keyed on the surrogate PROBABILITY_MEMBER_ID, with the business key anchored by the combination of PROBABILITY_LIST_ID and PROBABILITY_PERCENTAGE. Because no explicit foreign key relationships are documented in the ETRM metadata, this classification is offered as a suggested modeling interpretation rather than an enforced constraint.

Key Information Stored

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

• PROBABILITY_MEMBER_ID (NUMBER 15) — System-generated surrogate identifier that uniquely identifies each probability list member. This column is enforced by the unique index PA_PROBABILITY_MEMBERS_U2.
• PROBABILITY_LIST_ID (NUMBER 15) — Identifier of the parent probability list to which the member belongs. Together with the percentage it forms a business-key candidate via the unique index PA_PROBABILITY_MEMBERS_U1.
• PROBABILITY_PERCENTAGE (NUMBER) — The probability percentage that the project will be approved; this is the core functional value of the member.
• DESCRIPTION (VARCHAR2 240) — Free-text description of the probability member.
• START_DATE_ACTIVE and END_DATE_ACTIVE (DATE) — Define the effective date range during which the member is active.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who audit columns maintained by the application.
• ATTRIBUTE_CATEGORY (VARCHAR2 30) and ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2 150) — Descriptive flexfield (DFF) structure and segment columns enabling client-specific extensibility.

The primary key is PA_PROBABILITY_MEMBERS_PK, defined on the combination of PROBABILITY_LIST_ID and PROBABILITY_PERCENTAGE. Note that the surrogate column PROBABILITY_MEMBER_ID is protected by a separate unique index rather than being part of the PK, a design pattern common in seeded EBS configuration tables.

Common Use Cases and Queries

Typical usage includes retrieving all members of a given probability list, validating that percentages within a list total 100, and joining to project records to derive weighted forecasts. A representative query is:

• SELECT probability_member_id, probability_list_id, probability_percentage, description, start_date_active, end_date_active FROM pa.pa_probability_members WHERE probability_list_id = :list_id ORDER BY probability_percentage;
• Validation of percentage totals: SELECT probability_list_id, SUM(probability_percentage) FROM pa.pa_probability_members GROUP BY probability_list_id HAVING SUM(probability_percentage) <> 100;
• Active member lookup as of a date: filter on SYSDATE BETWEEN NVL(start_date_active, SYSDATE-1) AND NVL(end_date_active, SYSDATE+1).

Reporting scenarios include probability list maintenance inquiries and revenue forecast weighting in Project Billing and Project Costing.

Related Objects

• PA_PROBABILITY_LISTS — Parent list definition; join on PROBABILITY_LIST_ID.
• PA_PROJECTS — Projects reference a probability list that resolves to member percentages.
• PA_PROJECT_TYPES — Project types may default a probability list used at project creation.
• PA_PROPOSALS — Proposal records may carry associated probability percentages.
• FND_DESCR_FLEX_COL_USAGE_VL — Descriptive flexfield configuration for the ATTRIBUTE columns.
• FND_FLEX_VALUES_VL — Where segments reference validated flexfield values.

Because the ETRM metadata classifies this object as standalone, no enforced foreign keys are documented; relationships above are functional references commonly applied in reporting and extension development.