Search Results get_sec_profile

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.

• GET_MSG / GET_MSG1 — return VARCHAR2 messages keyed by page, user, session, and function name; these drive page-level messaging.
• GET_CURR — returns the current currency as VARCHAR2.
• GET_MANAGER — returns a NUMBER identifying the manager context.
• GET_DBI_PARAMS — returns VARCHAR2 DBI parameters for a given region.
• GET_SEC_PROFILE — returns the NUMBER security profile for the session.
• GET_PRIM_GLOBAL_CURRENCY_CODE / GET_SEC_GLOBAL_CURRENCY_CODE — return primary and secondary global currency codes as VARCHAR2.
• GET_DISPLAY_CURRENCY — returns the display currency for a selected operating unit.
• GET_PARAMETERS — extracts page parameters into typed OUT variables covering as-of date, operating unit, supplier, invoice number, period type, record type, view-by, currency, column/table names, group id, and org/supplier WHERE fragments.
• BIND_VARIABLE — builds bound SQL and attribute tables from a parameter table.
• GET_INVOICE_ID, GET_PERIOD_START, GET_PERIOD_STRT, GET_REPORT_SOURCE, GET_CHECK_ID, GET_BASE_CURR_COLNAME, GET_PERIOD_TYPE_SUFFIX, GET_YES_NO_MSG, GET_FORMAT_MASK — supporting lookups for invoice, period, report source, check, currency column, period suffix, yes/no messaging, and formatting.

Tables Accessed

• AP_SYSTEM_PARAMETERS_ALL / FINANCIALS_SYSTEM_PARAMS_ALL — system parameters and functional currency defaults.
• FII_TIME_DAY, FII_TIME_ENT_PERIOD, FII_TIME_ENT_QTR, FII_TIME_ENT_YEAR, FII_TIME_WEEK — FII time dimension tables for period and calendar resolution.
• PER_ORGANIZATION_LIST / PER_SECURITY_PROFILES — organization and security profile data underpinning GET_SEC_PROFILE and organization constraints.
• PLITBLM — the standard PL/SQL table for character message handling used by the get_msg functions.

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.