Search Results copy_src_attrs_to_target_fcst

Overview

PA_FP_GEN_PUB is a public PL/SQL package owned by the APPS schema that supports the generation and maintenance of financial plan (FP) and forecast data within Oracle Projects. It belongs to the family of PA_FP_* packages that underpin budgetary and forecast processing, including the generation of budget and forecast amounts, the copying of actuals into plan versions, and the maintenance of resource assignments and rate structures. The package is classified as a public (PUB) API, meaning it is intended for invocation from other Oracle EBS modules, concurrent programs, and customer extensions rather than being restricted to internal use.

Its central role is to provide reusable utility logic that governs how financial plan amounts are calculated, prorated across periods, and aligned with project and resource structures. It acts as a shared service consumed by higher-level generation packages such as PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_AMT_PUB, PA_FP_COPY_ACTUALS_PUB, and PA_FP_WP_GEN_BUDGET_AMT_PUB, which call into PA_FP_GEN_PUB for common processing logic.

Key Procedures and Functions

• UPDATE_RES_DEFAULTS — Maintains default values associated with project resource assignments, supporting the resource list setup used during financial plan generation.
• INCLUDE_CHANGE_DOCUMENT_WRP — A wrapper routine that controls whether change documents are included or generated during financial plan processing.
• UNSPENT_AMOUNT — Derives the unspent portion of budget or plan amounts, used in forecast and budget-versus-actual comparisons.
• UPD_WBS_ELEMENT_VERSION_ID — Updates the WBS element version identifier, ensuring plan lines are tied to the correct budget version structure.
• PRORATE_UNALIGNED_PERIOD_AMTS — Distributes amounts across periods that are not aligned to the plan calendar, a key step when resource or project period boundaries differ.
• MAINTAIN_FIXED_DATE_SP — Supports fixed-date processing logic, typically associated with the generation of amounts at a defined point in time.
• COPY_SRC_ATTRS_TO_TARGET_FCST — Copies source attributes to a target forecast, ensuring consistency of descriptors when forecast versions are created or refreshed.

Tables Accessed

The package reads and writes against core Oracle Projects and general ledger tables, including PA_BUDGET_LINES and PA_BUDGET_VERSIONS (plan amounts and version control), PA_BUDGET_LINES_S (the multi-language/secure variant), PA_PERIODS_ALL and GL_PERIOD_STATUSES (period definitions and open/close status), PA_PROJECTS_ALL (project master data), and PA_RESOURCE_ASSIGNMENTS (resource-to-project mapping). Additional working and control structures include PA_FP_CALC_AMT_TMP1 and PA_FP_CALC_AMT_TMP3 (calculation staging), PA_FP_GEN_RATE_TMP (rate staging), PA_RES_LIST_MAP_TMP1 and PA_RES_LIST_MAP_TMP4 (resource mapping), PA_FP_MERGED_CTRL_ITEMS (control items), PA_PROJ_FP_OPTIONS (financial plan options), and PA_IMPLEMENTATIONS_ALL (installation control).

Usage Notes

PA_FP_GEN_PUB is not typically invoked directly by end users. It is called by the financial plan and forecast generation concurrent programs and by higher-level public APIs such as PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_AMT_PUB, PA_FP_GEN_FCST_AMT_PUB1, PA_FP_COPY_ACTUALS_PUB, and PA_FP_WP_GEN_BUDGET_AMT_PUB. It is referenced by five other packages in total. Because it manipulates plan staging and budget version data, it should be called only through supported entry points and within the same transaction scope as the calling generation process to avoid inconsistent plan results.