Search Results fpa_utils_pvt




Overview
Explore in AI Chat

Overview

FPA_UTILS_PVT is a private utility package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified as a PVT (private) API. It supports the Financial Planning and Analysis (FPA) product family, delivering shared helper logic consumed by other FPA packages and concurrent processes. Rather than exposing a public interface, the package centralizes reusable computations that would otherwise be duplicated across the FPA codebase. Documented functionality includes scoring and color-coding of investment scenarios, evaluation of project and organization hierarchies, validation of class codes and organizations, formatting of numeric metrics, name and category lookups, and integration with Oracle's Analytic Workspace (DBMS_AW) infrastructure. The package is referenced by one other package, confirming its role as an internal dependency rather than a standalone entry point. The header notation ($Header: FPAVUTIB.pls 120.6 2006/05/08) indicates legacy lineage carried forward from earlier FPA releases.

Key Procedures and Functions

The fourteen documented functions and procedures split into distinct functional groups:

Tables Accessed

The package operates against several APPS synonyms for Oracle EBS base tables and views:

  • FND_FORM_FUNCTIONS and FND_MENU_ENTRIES — Foundation tables used to resolve form function and menu security definitions, supporting availability and access validation routines.
  • PA_CLASS_CATEGORIES — Projects class category definitions, referenced by IS_CLASS_CODE_AVAILABLE to verify whether a class code is valid for use.
  • PA_PROJECT_PARTIES — Project party assignments, used for scenario or approver-related lookups.
  • PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — HR person and assignment data, queried by GET_APPROVER_NAME to resolve approver identities.
  • PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_ELEMENTS — Organization hierarchy definitions, used by IS_ORG_IN_PJP_ORG_HIER to determine whether an organization participates in the planning hierarchy.
  • DBMS_AW — The OLAP analytic workspace PL/SQL interface, invoked through dynamic SQL for scenario scoring and analysis operations.
  • NLS_SESSION_PARAMETERS — Session localization settings, supporting numeric and date formatting in GET_FORMATTED_NUM.

Usage Notes

As a private package, FPA_UTILS_PVT is not intended for direct invocation by external custom code. It is called by other FPA packages, FPA-related Oracle Forms, and concurrent programs that require scenario scoring, color-coding, hierarchy validation, or formatting services. The color functions are typically invoked when rendering scenario comparison dashboards, where the returned G/Y/R indicator drives visual highlighting against planning cycle targets. The validation functions support data entry workflows, ensuring organizations and class codes conform to configured hierarchies and category definitions before records are saved. Because the documented scoring functions include broad exception handlers that return null, callers should implement defensive checks against null return values rather than assuming a color will always be produced. Any customization or extension of FPA functionality should reference these utilities through their owning parent packages rather than calling the PVT body directly, and upgrade testing should confirm continued compatibility, since the package header reflects an older code line carried unchanged into current 12.1.1 and 12.2.2 environments.