Search Results get_fnd_profile_value

Overview

The APPS.BIS_PMF_PORTLET_UTIL package is a utility package within the Oracle E-Business Suite Business Intelligence System (BIS) module, specifically supporting the Performance Management Framework (PMF) portlet infrastructure. Its primary business function is to provide shared helper logic for rendering, formatting, and managing portlet content that displays performance indicators and measures to end users. In EBS 12.1.1 and 12.2.2, this package underpins the display layer of PMF portlets surfaced through the Oracle Applications Framework (OAF) and the portal infrastructure, ensuring that measure values, currency symbols, scaling factors, and region attributes are consistently formatted and presented.

The package header reveals extensive support for auto-scaling of numeric values (thousands, millions, billions, trillions), currency indicator formatting, and region-level attribute handling. It also manages user-specific and customization-aware behavior, such as detecting demonstration rows, authorized content, and customized portlet rows.

Key Procedures and Functions

The 32 documented procedures and functions fall into several functional categories:

• Value retrieval and formatting: GETVALUE, GET_PL_VALUE, GET_FORMATTED_VALUE, GETAKFORMATVALUE, GET_AK_DISPLAY_FORMAT, and ISFUNCTIONFORMAT obtain raw or display-ready measure values and apply formatting rules such as number scaling and currency symbols.
• Region and hierarchy handling: GET_REGION_CODE, GET_PARENT_VALUE, RETRIEVE_DIM_LEVEL_VALUE, and GET_RANK_LEVEL_INFO resolve region identifiers and dimensional level information used in portlet layout.
• Customization and authorization checks: IS_AUTHORIZED, HAS_ROWS, HAS_CUSTOMIZED_ROWS, HAS_DEMO_ROWS, IS_DEMO_ON, and CLEAN_USER_IND_SEL determine whether a user may view content and whether rows are personalized or demonstrative.
• Presentation and diagnostics: GET_ROW_STYLE, ADD_DEBUG_TEXT, GET_FUNCTION_NAME, and IS_GET_FND_PROFILE support styling, debugging, and profile option evaluation.

These routines are consumed internally by the portlet rendering logic and are not intended as a public API for external callers.

Tables Accessed

The package references the following tables through APPS synonyms, driving its read and write behavior:

• BIS_PMF_POPULATE_PORTLET and BIS_USER_IND_SELECTIONS — store portlet population data and user indicator selections, supporting customization and selection cleanup.
• BIS_INDICATORS_TL, BIS_INDICATOR_RESPS, BIS_LEVELS, BIS_TARGET_LEVELS — provide indicator definitions, responsibility mappings, and level hierarchies used to resolve measure and region context.
• AK_REGION_ITEMS, ICX_PORTLET_CUSTOMIZATIONS, USER_TAB_COLUMNS — supply region metadata, portlet customizations, and column definitions for dynamic formatting.
• HTP — the Oracle HTML toolkit, used to emit markup fragments during portlet rendering.

Usage Notes

BIS_PMF_PORTLET_UTIL is invoked indirectly rather than through direct user interaction. It is called by two other packages in the PMF portlet stack during portlet page generation, typically triggered when a user opens a PMF dashboard or portal page in EBS. In 12.1.1 and 12.2.2 the package operates within the OAF and portal runtime, applying NLS-aware number and currency formatting (as indicated by the auto-scaling constants and thousand/million symbol messages). Because it is classified as a utility package with no documented public API contract, customizations should avoid direct calls and instead rely on the supported portlet configuration mechanisms.