Search Results plan_processing_code




Overview
Explore in AI Chat

Overview

PA_FCST_PROJ_PERIODIC_V (internally referenced in some ETRM documentation as PA_PROJ_FCST_PERIODIC_V) is an APPS-owned database view within the Oracle EBS Projects (PA) module. It exposes project periodic forecasting data, presenting forecast amounts, rates, and quantities broken out by assignment, resource assignment, and accounting period. The view functions as a reporting and integration layer rather than a transactional object: it does not store data itself, but reframes the underlying forecast and budgeting tables into a shape suited to inquiry screens, concurrent reports, and downstream extracts.

The view is significant because it applies business rules at query time rather than storing pre-calculated results. Profile-driven behavior controls whether the view returns revenue, cost, labor hours, margin, or margin percentage figures. This design lets the same view serve multiple forecast presentation modes without requiring separate objects, and it ensures the presentation is consistent with the profile settings of the reporting user or session.

Underlying Base Objects

The documented base objects underpinning this view are:

  • PA_BUDGET_LINES (synonym) — provides period-level forecast revenue, burdened cost, and quantity figures (aliased BL in the view text), including period name and period start date.
  • PA_BUDGET_VERSIONS (synonym) — supplies the forecast version context associated with the budget lines.
  • PA_PROJECT_ASSIGNMENTS (synonym) — supplies project and assignment identifiers and assignment names (aliased ASGN).
  • PA_RESOURCE_ASSIGNMENTS (synonym) — supplies resource assignment detail, standard and average bill rates, discount percentage, plan revenue and burdened cost totals, and the plan error code (aliased RA).
  • PA_FCST_PERIODS_TMP_V (view) — contributes the forecast period scaffolding used to align assignments to periods.
  • PA_FCST_GLOBAL (package) — a PL/SQL package whose functions, including GETPROJFCSTSHOWAMOUNT, GETPROBABILITYPERFLAG, and FIND_PROJECT_FIXED_PRICE, drive the conditional presentation logic in the view.
  • PA_PERIOD_PROCESS_PKG (package) and FND_PROFILE (package) — supporting packages used for period processing and profile option retrieval.
  • DUAL (synonym) — the standard Oracle single-row utility table.

Because the view references PL/SQL packages, its output can change based on profile option settings and project-level flags such as fixed-price status, even when the underlying data is unchanged.

Key Columns

  • PROJECT_ID and ASSIGNMENT_ID — identify the project and the assignment being forecast.
  • ASSIGNMENT_NAME — the display name of the assignment.
  • RESOURCE_ASSIGNMENT_ID — links the row to a specific resource assignment.
  • PERIOD_NAME, PERIOD_START_DATE — the accounting period and its start date for the forecasted amounts.
  • PLAN_PROCESSING_CODE — derived from RA.PLAN_ERROR_CODE; a NULL error code yields '-1', otherwise '0', indicating plan processing status.
  • STD_BILL_RATE and AVG_BILL_RATE — standard and average bill rates, conditionally populated based on the forecast show-amount mode. For fixed-price projects, the average bill rate resolves to NULL.
  • AVG_DISCOUNT_PERCENTAGE — the rounded average discount percentage.
  • PROJECT_TOTAL — the period-level total amount, returned as revenue, burdened cost, labor hours, margin, or margin percentage depending on the show-amount setting and the probability performance flag.

Common Use Cases and Queries

Typical scenarios include periodic forecast review by project, rate and margin analysis across assignments, and feeding forecast data into custom extracts. A basic query by project and period is:

  • SELECT project_id, assignment_name, period_name, project_total FROM apps.pa_fcst_proj_periodic_v WHERE project_id = :p_project_id AND period_name = :p_period ORDER BY period_start_date, assignment_name;
  • SELECT resource_assignment_id, std_bill_rate, avg_bill_rate, avg_discount_percentage FROM apps.pa_fcst_proj_periodic_v WHERE project_id = :p_project_id AND period_name = :p_period;
  • SELECT COUNT(*) FROM apps.pa_fcst_proj_periodic_v WHERE plan_processing_code = '0' AND project_id = :p_project_id;

Because returned amounts depend on PA_FCST_GLOBAL profile logic, identical SQL can yield revenue, cost, hours, or margin values for different sessions. Consumers should therefore confirm the relevant profile settings before interpreting PROJECT_TOTAL, and should apply project and period predicates to limit the volume of package-driven evaluations.

  • View: PA_FCST_PROJ_PERIODIC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_PERIODIC_V,  object_name:PA_FCST_PROJ_PERIODIC_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_FCST_PERIODIC_V is a view that shows project periodic forecasting ,  implementation_dba_data: APPS.PA_FCST_PROJ_PERIODIC_V , 

  • View: PA_FCST_PROJ_PERIODIC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_PERIODIC_V,  object_name:PA_FCST_PROJ_PERIODIC_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_FCST_PERIODIC_V is a view that shows project periodic forecasting ,  implementation_dba_data: APPS.PA_FCST_PROJ_PERIODIC_V , 

  • View: PA_FCST_PROJ_DTL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_DTL_V,  object_name:PA_FCST_PROJ_DTL_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting ,  implementation_dba_data: APPS.PA_FCST_PROJ_DTL_V , 

  • View: PA_FCST_PROJ_DTL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_DTL_V,  object_name:PA_FCST_PROJ_DTL_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting ,  implementation_dba_data: APPS.PA_FCST_PROJ_DTL_V , 

  • View: PA_FP_BASELINED_REVENUE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_REVENUE_V,  object_name:PA_FP_BASELINED_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves budget versions whose version type is Revenue ,  implementation_dba_data: APPS.PA_FP_BASELINED_REVENUE_V , 

  • View: PA_FP_BASELINED_REVENUE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_REVENUE_V,  object_name:PA_FP_BASELINED_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves budget versions whose version type is Revenue ,  implementation_dba_data: APPS.PA_FP_BASELINED_REVENUE_V , 

  • View: PA_FP_WORKING_REVENUE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_REVENUE_V,  object_name:PA_FP_WORKING_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions whose version type is Revenue. ,  implementation_dba_data: APPS.PA_FP_WORKING_REVENUE_V , 

  • View: PA_FP_BASELINED_COST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COST_V,  object_name:PA_FP_BASELINED_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all baselined budget versions whose version type is COST ,  implementation_dba_data: APPS.PA_FP_BASELINED_COST_V , 

  • View: PA_FP_WORKING_REVENUE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_REVENUE_V,  object_name:PA_FP_WORKING_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions whose version type is Revenue. ,  implementation_dba_data: APPS.PA_FP_WORKING_REVENUE_V , 

  • View: PA_FP_WORKING_COST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COST_V,  object_name:PA_FP_WORKING_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all working budget versions whose version type is COST. ,  implementation_dba_data: APPS.PA_FP_WORKING_COST_V , 

  • View: PA_FP_BASELINED_COST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COST_V,  object_name:PA_FP_BASELINED_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all baselined budget versions whose version type is COST ,  implementation_dba_data: APPS.PA_FP_BASELINED_COST_V , 

  • View: PA_FP_BASELINED_COSTREV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COSTREV_V,  object_name:PA_FP_BASELINED_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type ,  implementation_dba_data: APPS.PA_FP_BASELINED_COSTREV_V , 

  • View: PA_FP_WORKING_COST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COST_V,  object_name:PA_FP_WORKING_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all working budget versions whose version type is COST. ,  implementation_dba_data: APPS.PA_FP_WORKING_COST_V , 

  • View: PA_FP_WORKING_COSTREV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COSTREV_V,  object_name:PA_FP_WORKING_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions, regardless of version type. ,  implementation_dba_data: APPS.PA_FP_WORKING_COSTREV_V , 

  • View: PA_FP_WORKING_COSTREV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COSTREV_V,  object_name:PA_FP_WORKING_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions, regardless of version type. ,  implementation_dba_data: APPS.PA_FP_WORKING_COSTREV_V , 

  • View: PA_FP_BASELINED_COSTREV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COSTREV_V,  object_name:PA_FP_BASELINED_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type ,  implementation_dba_data: APPS.PA_FP_BASELINED_COSTREV_V ,