Search Results gen_org_fcst




Overview
Explore in AI Chat

Overview

The APPS.PA_FP_ORG_FCST_GEN_PUB package body supports the generation of organization-level forecasts within the Oracle E-Business Suite Project Accounting module. It belongs to the Project Forecasting (PA_FP) family of APIs and provides the public entry points used to build forecast budget versions from source planning data. The package carries a public API classification, meaning its procedures are intended for invocation by external callers such as concurrent programs, forms, and custom extensions rather than being restricted to internal package use.

The header comment identifies an origin in the FPB2 release cycle and documents a series of incremental enhancements spanning 2002 through 2013. Notable among these are the introduction of budget_line_id and txn_currency_code into PA_BUDGET_LINES, the correction of source transaction currency population in PA_FIN_PLAN_LINES_TMP, a shift to the PJI data model for utilization figures, and a CBS enhancement (Bug 16200605). A debug-mode flag is initialized from the PA_DEBUG_MODE profile option, and a module-level constant limits the PL/SQL array size used during processing.

Key Procedures and Functions

The documented public interface exposes four procedures or functions:

  • GEN_ORG_FCST — The principal driver routine. It generates the organization forecast by populating the financial plan temporary structures and the associated budget line records for a given budget version.
  • CREATE_RES_TASK_MAPS — This is the routine the user searched for. It builds the mapping between resources and tasks that the forecast generation relies upon, writing the resulting rows into the temporary mapping table PA_FP_RA_MAP_TMP. It establishes which resource assignments apply to which tasks before amounts are computed.
  • COPY_RESOURCE_ASSIGNMENTS — Copies resource assignment records, allowing an existing set of assignments to be reused or transferred when constructing a new forecast version.
  • COPY_BUDGET_LINES — Copies budget line records, supporting the duplication or carry-forward of budget line detail into a target budget version.

An internal helper, budget_version_in_error, is also present. It updates PA_BUDGET_VERSIONS.plan_processing_code to 'E' and commits, marking a budget version as failed so downstream processing halts cleanly. The package is referenced by three other packages, confirming its role as a shared dependency in the forecasting flow.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. Budget definition and control data reside in PA_BUDGET_VERSIONS, PA_BUDGET_LINES, and PA_BUDGET_LINES_S, with the latter supplying the new budget_line_id and txn_currency_code columns referenced in the change history. Planning structures are held in PA_FIN_PLAN_LINES_TMP, PA_FIN_PLAN_TYPES_B, PA_FIN_PLAN_AMOUNT_SETS, and PA_AMOUNT_TYPES_B. Forecast configuration is drawn from PA_FORECASTING_OPTIONS_ALL and PA_FORECAST_ITEMS. Temporary mapping tables PA_FP_BL_MAP_TMP and PA_FP_RA_MAP_TMP hold intermediate budget-line and resource-assignment mappings. Calendar and organizational context come from GL_PERIODS, GL_DATE_PERIOD_MAP, HR_ALL_ORGANIZATION_UNITS, and HR_ALL_ORGANIZATION_UNITS_TL.

Usage Notes

These procedures are typically invoked from Project Accounting forecast-generation concurrent programs and from the relevant forecast forms, with GEN_ORG_FCST acting as the orchestration point that calls CREATE_RES_TASK_MAPS, COPY_RESOURCE_ASSIGNMENTS, and COPY_BUDGET_LINES as required. Custom code should call only the documented public procedures, pass valid budget version identifiers, and honor the PA_DEBUG_MODE profile setting when diagnosing failures. Because budget_version_in_error issues an explicit commit, callers should account for this side effect when integrating the package into larger transactions.