Results for “fpa_utilities_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FPA_UTILITIES_PVT is a private PL/SQL utility package in the Oracle EBS Applications (APPS) schema, delivered as part of the Enterprise Performance Foundation (FPA) module. In Oracle EBS 12.1.1 and 12.2.2, the FPA schema supports financial planning and performance analytics, and FPA_UTILITIES_PVT functions as a shared internal library that other FPA packages call for common operations. The package is declared with AUTHID CURRENT_USER, meaning its database objects are resolved under the privileges of the calling user rather than the package owner, which is typical for private helper APIs within the APPS tier. It is classified as a PVT (private) API, indicating that it is not intended as a public integration interface but rather as an internal building block used across the FPA product family.

Key Procedures and Functions

The documented metadata lists 13 procedures and functions. The analytical interface procedures attach_AW and detach_AW manage the attachment and detachment of an analytic workspace (AW), consistent with Oracle's OLAP/AWM integration. The duplicate_name function checks for name collisions against a supplied table and column, supporting validation logic elsewhere in FPA. The aw_space_name function returns the analytic workspace space name used by PJP (a planning component) and is referenced in DDL for PJP views. Three numeric calculation helpers are also exposed: Get_Net_Cash_Needed, Get_Overtime_Resources, and Get_Unused_Resources, each deriving a computed figure from two input values. The remaining documented routines form a common API messaging and exception-handling framework created in October 2004. These include INIT_MSG_LIST, START_ACTIVITY, HANDLE_EXCEPTIONS, END_ACTIVITY, and SET_MESSAGE, which together manage message stacks, activity logging, and error propagation. The package also defines record and table types (msg_rec_type, msg_tbl_type, error_rec_type, error_tbl_type) and global constants such as G_FALSE, G_TRUE, G_MISS_NUM, G_MISS_CHAR, and G_MISS_DATE, all mirroring the standard FND_API constants.

Tables Accessed

According to the documented metadata, FPA_UTILITIES_PVT references two objects through APPS synonyms: FND_APPLICATION, the Oracle Application Object Library table that stores application registration and naming data, and DBMS_AW, the Oracle-supplied analytic workspace PL/SQL package. The FND_APPLICATION reference is consistent with the package's need to resolve application identifiers during message and error handling. DBMS_AW is used to support the attach_AW and detach_AW routines that bind analytic workspaces to a session.

Usage Notes

FPA_UTILITIES_PVT is a private utility and is not designed to be called directly from Oracle Forms or concurrent programs by end users. Instead, the ETRM metadata records that it is referenced by 54 other packages, confirming its role as a shared dependency across the FPA module. Custom code should avoid calling PVT-class APIs directly, because their signatures and behavior are not guaranteed across patch levels or releases. When troubleshooting FPA behavior, DBAs and developers typically identify this package through dependency tracing rather than direct invocation. The presence of the standard FND_API constant set and message-handling routines indicates that callers are expected to follow Oracle's API error-handling conventions, checking x_return_status and the associated message count and data outputs after each call.

Note: The search phrase "power factory license perpetual of limited" does not correspond to any documented function or licensing behavior of FPA_UTILITIES_PVT; this package pertains solely to Enterprise Performance Foundation utility operations within Oracle EBS.