Search Results collect_projects

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:

• Scenario scoring color functions — GET_SCENARIO_WSCORE_COLOR, GET_SCENARIO_NPV_COLOR, and GET_SCENARIO_ROI_COLOR compare a scenario's weighted score, net present value, or return on investment against planning cycle target thresholds and return a color indicator (G/Y/R). The documented implementation for GET_SCENARIO_WSCORE_COLOR queries FPA_AW_SCE_STR_SCORES_V and FPA_AW_PC_INV_CRITERIA_V, filtering on a specific investment criteria identifier, and traps all exceptions by returning null.
• Score and approval evaluation — SCENARIOS_RECOMMENDED and SCENARIO_APPROVED translate raw scoring outcomes into business decisions regarding scenario recommendation and approval status.
• Checklist and hierarchy validation — DETERMINE_PC_CHECKLIST_STATUS evaluates planning cycle checklist completion. IS_ORG_IN_PJP_ORG_HIER, IS_CLASS_CODE_AVAILABLE, and IS_ORGANIZATION_AVAILABLE perform existence and hierarchy membership checks used to validate data entry against organizational and classification rules.
• Calendar and lookup utilities — LOAD_GL_CALENDAR populates general ledger calendar data, while GET_INV_CATEGORY_NAME, GET_APPROVER_NAME, GET_FIN_METRIC_UNIT, and GET_FORMATTED_NUM return display-ready category names, approver names, financial metric units, and formatted numeric strings.

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.