Search Results pa_fp_gen_fcst_pg_pkg




Overview
Explore in AI Chat

Overview

PA_FP_GEN_FCST_PG_PKG is a private PL/SQL package body owned by the APPS schema that supports forecast generation for project financial plans in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It sits within the Project Financial Planning (PA_FP) module and provides period-level processing logic used when generating forecast amounts for a project financial plan version. The package is not a public API; it is invoked internally by higher-level forecast generation routines, as evidenced by its reference to companion packages such as PA_FP_GEN_FCST_AMT_PUB and PA_FP_GEN_AMOUNT_UTILS. Its role is to resolve and validate the date and period boundaries that drive forecast calculations, including actuals-to-date, estimate-to-complete (ETC), and unspent amounts.

The package is documented as STATUS VALID, classified as OTHER, and exposes 13 stored program units. It is not referenced by any database object, confirming its position as a private implementation package rather than a callable interface.

Key Procedures and Functions

  • GET_REV_GEN_METHOD — Retrieves the revenue generation method applied when deriving forecast revenue.
  • GET_ACTUALS_THRU_PERIOD_DTLS — Returns actuals-through period detail used to establish the cut-off between actual and forecast portions of the plan.
  • GET_ACT_FRM_PERIOD — Determines the "actuals from" period for the forecast generation window.
  • GET_ACT_TO_PERIOD — Determines the "actuals to" period, i.e. the last period containing actual costs.
  • GET_ETC_FRM_PERIOD — Resolves the "estimate-to-complete from" period.
  • GET_ETC_TO_PERIOD — Resolves the "estimate-to-complete to" period, defining the horizon of the forecast.
  • GET_UNSPENT_AMT_PERIOD — Retrieves the period associated with unspent or remaining budget/commitment amounts.
  • GET_VERSION_DETAILS — Returns attribute details for the financial plan version being processed.
  • UPD_VER_DTLS_AND_GEN_AMT — Updates the version details and triggers generation of forecast amounts.
  • VALIDATE_PERIODS — Validates the derived actual and ETC period ranges for consistency.
  • VALIDATE_PA_GL_PERIODS — Validates the corresponding Oracle General Ledger period statuses before generation proceeds.
  • VALIDATE_PLAN_TYPE_OR_VERSION — Validates the plan type or financial plan version supplied for generation.
  • VALIDATION_FOR_COPY_ETC_FLAG — Validates the copy-ETC flag that controls whether ETC values are carried forward.

Tables Accessed

Usage Notes

PA_FP_GEN_FCST_PG_PKG is a private support package. It is not intended for direct invocation by custom code. Instead, it is called internally by the public forecast API PA_FP_GEN_FCST_AMT_PUB and by the Forecast Generation concurrent program launched from project financial plan windows in Oracle Projects. When a planner initiates forecast generation for a plan version, the calling API invokes this package to resolve the actuals-to period, ETC window, revenue generation method, and to validate the plan version and GL period statuses before amounts are written to PA_BUDGET_LINES.

Dependencies include FND_API, FND_GLOBAL, FND_MSG_PUB, FND_PROFILE, PA_DEBUG, PA_FIN_PLAN_PVT, PA_FP_CONSTANTS_PKG, PA_FP_COPY_FROM_PKG, PA_FP_WP_GEN_AMT_UTILS, PA_PERIOD_PROCESS_PKG, PA_RATE_PVT_PKG, PA_RES_ASG_CURRENCY_PUB, PA_UTILS, PA_INTERFACE_UTILS_PUB, and PJI_PJP_EXTRACTION_UTILS, indicating significant involvement of the shared PA utilities and API message framework. Because the package performs writes to plan data and validates GL period state, it should only be executed within a committed planning transaction and under standard EBS concurrency controls. Custom extensions should invoke the public API rather than this private package body.