Results for “probability_percentage”

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

Overview

PA_FCST_PROJECT_DTL_V is a VALID view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the PA (Projects) product family and is documented as a view that presents project forecasting detail. In practice, the view consolidates forecast planning output — the results produced by the Project Forecasting/Project Resource Management forecasting engine — into a single denormalized row-per-project format suitable for reporting, extraction, and downstream integration.

Because the object is a view rather than a table, it holds no data of its own; it is a query definition evaluated at runtime. Its primary role is to expose forecast figures (cost, revenue, margin, labor quantity, and their probability-weighted variants) alongside descriptive project attributes, so that reporting tools, custom concurrent programs, and interfaces can consume forecasting results without navigating the underlying planning tables and packaged APIs directly. It is most commonly accessed read-only, and it is frequently joined to other PA views and tables for dashboard, pipeline, and revenue-forecast reporting.

Underlying Base Objects

The documented base objects referenced by PA_FCST_PROJECT_DTL_V are: FND_GLOBAL (package), HR_ALL_ORGANIZATION_UNITS_TL (synonym), PA_BUDGET_VERSIONS (synonym), PA_FCST_GLOBAL (package), PA_FCST_PROJECT_LIST_V (view), PA_PROJECTS_MAINT_UTILS (package), PA_PROJECT_CLASSES (synonym), PA_PROJECT_STATUSES (synonym), PA_RESOURCE_ASSIGNMENTS (synonym), and PA_UTILS (package).

The view is built as an inline subquery wrapped in an outer projection. Core project attributes come from the project list view PA_FCST_PROJECT_LIST_V, with organizational names sourced from HR_ALL_ORGANIZATION_UNITS_TL, classification codes from PA_PROJECT_CLASSES, and the decoded status name from PA_PROJECT_STATUSES. The as-of date is derived from PA_BUDGET_VERSIONS.PLAN_RUN_DATE, and financial forecast quantities and amounts are drawn from PA_RESOURCE_ASSIGNMENTS. Business logic is largely delegated to PL/SQL packages: PA_FCST_GLOBAL.FIND_PROJECT_OWNER resolves the project owner, while functions such as PA_FCST_GLOBAL.GETPROJFCSTSHOWAMOUNT and PA_FCST_GLOBAL.GETPROBABILITYPERFLAG drive conditional formatting and probability weighting. FND_GLOBAL, PA_UTILS, and PA_PROJECTS_MAINT_UTILS supply session and utility context. Because package calls are involved, this view cannot be treated as a simple static join; its results depend on profile options and session state.

Key Columns

• PROJECT_ID / PROJECT_NAME / PROJECT_NUMBER — Primary project identifiers used for joins and drill-down.
• ORGANIZATION_NAME — Owning organization from HR_ALL_ORGANIZATION_UNITS_TL.
• CUSTOMER_NAME — Customer associated with the project.
• PROJECT_OWNER — Resolved via PA_FCST_GLOBAL.FIND_PROJECT_OWNER using the project start and completion dates.
• PROJECT_TYPE / CLASSIFICATION — Project type and class code, supporting grouping and filtering.
• PROJECT_STATUS — Human-readable status name from PA_PROJECT_STATUSES; this is the column most commonly referenced when users search on "project_status".
• AS_OF_DATE — The plan run date from PA_BUDGET_VERSIONS, identifying which forecast version the figures reflect.
• CURRENCY_CODE — Project currency for the monetary columns.
• DISCOUNT_PERCENTAGE / PROBABILITY_PERCENTAGE — Numeric percentages formatted as character strings via TO_CHAR/ROUND.
• PROJECT_TOTAL — The forecast total amount, conditionally computed based on the configured show-amount mode (for example LABOR_HOURS, COST, REVENUE, MARGIN, or MARGIN_PERCENTAGE) and adjusted by the probability weighting flag.

Common Use Cases and Queries

Typical uses include project pipeline and forecast dashboards, revenue and margin forecasting extracts, and reconciliation of forecast versions by as-of date. Because PROJECT_STATUS is exposed directly, status-based filtering is a frequent access pattern.

Listing forecasted projects by status:

SELECT project_number, project_name, organization_name,
       project_status, as_of_date, currency_code, project_total
  FROM apps.pa_fcst_project_dtl_v
 WHERE project_status = 'Approved'
 ORDER BY project_number;

Aggregating forecast totals by organization and status:

SELECT organization_name, project_status,
       SUM(TO_NUMBER(REPLACE(project_total, ',', ''))) total_forecast
  FROM apps.pa_fcst_project_dtl_v
 GROUP BY organization_name, project_status;

Joining to PA_PROJECTS_ALL on PROJECT_ID is common when additional project attributes are required beyond those surfaced by the view. Users should note that monetary and percentage columns are returned as formatted character strings and require explicit numeric conversion before arithmetic.