Search Results pa_fp_rev_gen_pub




Overview
Explore in AI Chat

Overview

PA_FP_REV_GEN_PUB is a public PL/SQL package in the APPS schema that forms part of the Oracle Project Financial Planning (FP) revenue generation framework. Its business purpose is to generate and maintain cost-based revenue plan amounts for financial plan versions, and to propagate resource and schedule data into the budget or forecast structures that underpin project revenue planning. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, financial plans allow project managers to model budgets, forecasts, and revenue against a project's tasks and resources. PA_FP_REV_GEN_PUB acts as a controlled API layer within that flow, accepting the results of generation logic and persisting them into the planning tables.

The package holds VALID status in the ETRM registry and is classified as a PUB (public) API, which indicates it is intended to be called by other Oracle modules and by integrators rather than being an internal-only helper. It depends on standard Oracle utilities (SYS.STANDARD) and on several project planning tables and utility packages.

Key Procedures and Functions

  • GEN_COST_BASED_REVENUE — The primary documented entry point. It drives the generation of cost-based revenue amounts for a financial plan version. In practice this procedure evaluates the cost basis associated with a plan version and derives the corresponding revenue figures, writing them into the appropriate plan amount structures. It is the procedural core that other generation packages delegate to.
  • PUSH_RES_SCH_DATA_TO_BL — A supporting procedure that pushes resource and schedule data into the budget lines structure. This ensures that resource assignment data and scheduling information are reflected in the plan lines that revenue generation reads, keeping the planning model consistent before revenue amounts are computed.

Both routines are consumed by related generation packages, notably PA_FP_GEN_BUDGET_AMT_PUB and PA_FP_GEN_FCST_AMT_PUB, which invoke PA_FP_REV_GEN_PUB as part of budget-amount and forecast-amount generation respectively.

Tables Accessed

Usage Notes

PA_FP_REV_GEN_PUB is not typically invoked directly by end users. It is called by concurrent programs and by the higher-level financial plan generation packages (PA_FP_GEN_BUDGET_AMT_PUB and PA_FP_GEN_FCST_AMT_PUB) when a project manager generates budget or forecast amounts for a plan version that includes revenue planning. The Project Financial Planning forms and the corresponding generation concurrent programs therefore act as the practical invocation points. Custom code should treat these routines as an API and call them through the supported generation packages rather than bypassing the framework, since the procedures rely on correctly staged resource, schedule, and rollup data. Because the package is PUBLIC, it is a supported integration surface, but its internal dependencies on temporary and rollup tables mean it must be called in the correct sequence following resource and schedule population.