Search Results fii_pmv_util




Overview
Explore in AI Chat

Overview

FII_PMV_UTIL is a PL/SQL utility package in the APPS schema that supports the Oracle EBS Financials Intelligence (FII) Performance Management Viewer (PMV) framework, primarily within the Payables Manager (AP) and related financials dashboards. Declared with AUTHID CURRENT_USER, the package executes with the privileges of the invoking user, allowing it to resolve synonyms and apply row-level security as the calling session. The package centralizes a set of reusable helper functions and procedures that PMV pages and Business Intelligence System (BIS) query pages rely on: message retrieval, currency determination, manager and security profile resolution, parameter extraction from page parameter tables, and dynamic SQL bind construction. Its header dates to 2005 (FIIPMVUS.pls 120.2), reflecting its role as a long-lived foundation utility for the FII PMV reporting stack across 12.1.1 and 12.2.2.

Key Procedures and Functions

The user's search for "get_sec_profile" points directly to one member of this package. GET_SEC_PROFILE is a function returning a NUMBER, and is used to resolve the current user's security profile identifier so that PMV queries can constrain data by organization or operating unit access.

Tables Accessed

Usage Notes

FII_PMV_UTIL is not an end-user API; it is invoked indirectly by FII PMV pages, BIS query pages, and other utilities. The referenced-by count of 12 packages confirms broad reuse within the PMV layer. Customizations should call it only from APPS-owned code running with appropriate privileges, given AUTHID CURRENT_USER. Because page parameter tables (BIS_PMV_PAGE_PARAMETER_TBL) are passed directly, callers must supply correctly structured parameters. For privilege-sensitive operations such as GET_SEC_PROFILE, ensure the invoking session has organization access defined.