Search Results fpa_global_pvt




Overview
Explore in AI Chat

Overview

FPA_GLOBAL_PVT is a private (PVT-classified) PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Enterprise Planning and Budgeting (EPB) / Financial Planning and Analysis product family, identified by the FPA prefix. The package encapsulates global state and utility routines shared across the FPA codebase, most notably the management of an Oracle OLAP Analytic Workspace (AW) association for the current database session.

The package is declared with AUTHID CURRENT_USER, meaning its routines execute with the privileges of the invoking schema rather than the definer. This is consistent with a private utility package intended to be called by other FPA packages running under the same session context. The header revision ($Header: FPAVGLBS.pls 120.2 2011/08/03) confirms the source file is FPAVGLBS.pls, which was current for the 12.1.1 era and remained stable in 12.2.2.

Key Procedures and Functions

  • AW_SPACE_NAME — A function that returns a VARCHAR2 value. It supplies the name of the Analytic Workspace space associated with FPA processing. The commented declaration -- fpa_aw VARCHAR2(30); indicates the package previously maintained the AW name as a package-level global; the function now serves as the accessor for that value. Callers use it to obtain the workspace identifier before issuing OLAP operations.
  • IS_AW_ATTACHED — A function returning BOOLEAN. As stated in the embedded comment, it "determines if the AW workspace is attached in the current session." This is the routine matched by the search term is_aw_attached. Callers invoke it to test whether the session already holds an attached Analytic Workspace before attempting to attach or query one, thereby avoiding redundant attach operations or attachment errors.

No parameter lists are documented for either routine; neither takes arguments according to the source excerpt.

Tables Accessed

The documented reference list identifies FND_APPLICATION, DBMS_AW, and DBMS_LOB as the objects referenced through APPS synonyms. Strictly speaking, only FND_APPLICATION is a table; DBMS_AW and DBMS_LOB are supplied PL/SQL packages rather than relational tables.

  • FND_APPLICATION — The EBS application registry. FPA_GLOBAL_PVT reads this to resolve the application identifier and associated short name context for the FPA product, which is then used to derive the Analytic Workspace naming convention returned by AW_SPACE_NAME.
  • DBMS_AW — The Oracle OLAP analytic workspace PL/SQL API. The package uses it to test and manage workspace attachment state, underpinning IS_AW_ATTACHED.
  • DBMS_LOB — The large-object utility package, referenced for handling AW metadata or workspace content held in LOB columns.

Usage Notes

FPA_GLOBAL_PVT is a private package and is not exposed directly to end users. It is referenced by at least one other FPA package, which supplies the public API surface. Typical invocation occurs from server-side PL/SQL within the EPB/Financial Planning modules, including concurrent programs that build or refresh planning data, and from any custom code that interacts with the FPA Analytic Workspace. Callers normally test IS_AW_ATTACHED before invoking OLAP operations, then retrieve the workspace name via AW_SPACE_NAME. Because the package is AUTHID CURRENT_USER, custom code invoking it must run under a schema with the appropriate privileges on the APPS synonyms. Direct dependence on these private routines is discouraged, as the interface may change without notice across patches or releases.