Search Results plan_etc_signs_match




Overview
Explore in AI Chat

Overview

PA_FP_FCST_GEN_AMT_UTILS is a PL/SQL utility package in the Oracle EBS Projects (PA) module that supports forecasting and forecast generation logic. It belongs to the Forecast Planning (FP) family of packages and is used to determine whether Estimated To Complete (ETC) quantities and amounts are consistent with the plan values from which they are derived. Its primary role is to validate the sign relationship between plan quantities/amounts and the corresponding ETC values before forecast data is generated, ensuring that forecast generation does not create illogical results such as negative ETC against a positive plan, or vice versa. The package is classified as an OTHER API and is not a public concurrent program entry point; it is an internal utility used by other forecasting and workplan processes. In Oracle EBS 12.1.1 and 12.2.2, this package is typically invoked during forecast generation and workplan progress calculations within the Projects module.

Key Procedures and Functions

  • COMPARE_ETC_SRC_TARGET_FP_OPT: Compares the ETC source, target, and forecast planning options for a given project and set of budget versions. It evaluates whether the source and target plan versions share the same planning option configuration, returning a flag indicating whether the options match along with status and message details for error handling. This is used to validate that forecast generation is comparing like-for-like plan versions.
  • PLAN_ETC_SIGNS_MATCH: Determines whether the plan quantity or amount and the ETC quantity or amount have matching signs. Per the documented logic, it returns TRUE when both values are non-negative or both are negative, and FALSE otherwise. The function accepts a calling module parameter (defaulting to 'FORECAST_GENERATION', with 'WORKPLAN' as another valid value), which allows future behaviour to be tailored to the calling context.
  • GET_ETC_FROM_PLAN_ACT: Computes the ETC quantity based on planned and actual quantities for workplan progress. This function is documented as a variation of the sign-matching logic, applied specifically to derive ETC values from plan and actual data in workplan progress scenarios.

Tables Accessed

  • PA_BUDGET_VERSIONS: Supplies the budget version identifiers used as source and target plan versions when comparing forecast planning options and when deriving ETC values.
  • PA_PROJ_FP_OPTIONS: Stores the forecast planning options for a project, enabling the package to verify that source and target plan versions belong to the same planning option configuration.
  • PA_PROJECTS_ALL: Provides the project definition context required to scope forecast generation logic to the correct project.

Access to these tables occurs through APPS synonyms, consistent with standard EBS coding practice.

Usage Notes

PA_FP_FCST_GEN_AMT_UTILS is invoked internally by other forecasting and workplan processes rather than directly by end users. It is referenced by eight other packages within the Applications schema, confirming its role as a shared utility layer. Typical invocation points include forecast generation routines that evaluate plan-versus-ETC sign consistency, workplan progress computations that derive ETC from planned and actual quantities, and validation logic that compares ETC source and target forecasting options. The P_CALLING_MODULE parameter on PLAN_ETC_SIGNS_MATCH indicates the package was designed for extensibility, allowing behaviour to differ between FORECAST_GENERATION and WORKPLAN contexts. Because the package is classified as OTHER and appears to be an internal helper, customizations should avoid modifying it directly and should instead call the supported public APIs in the Projects forecasting stack. The header version (120.3) reflects a stable release maintained for both 12.1.1 and 12.2.2 environments.