Search Results stale_portlet

Overview

The APPS.BIS_PMV_UTIL package is a utility package that supports the Oracle E-Business Suite Portlet Manager / PM Viewer infrastructure, commonly associated with the Daily Business Intelligence (DBI) and Portal framework in releases 12.1.1 and 12.2.2. Its declared purpose, as recorded in the package header, is to provide List of Values (LOV) support for the PM Viewer, and it has evolved over multiple releases to encompass date/time formatting, region and dimension resolution, hierarchy lookups, and portlet staleness and update management. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and relies on APPS synonyms for all referenced objects. It is referenced by sixteen other packages, which confirms its role as a shared, low-level utility layer consumed by the broader portal and reporting stack rather than an end-user-facing API.

Key Procedures and Functions

The packaged procedures and functions fall into several functional clusters. Extraction and rendering utilities include READFNDLOBS, which reads large object content from FND_LOBS, and RETRIEVE_DATA, GETAPPENDTITLE, GETREPORTTITLE, GETREPORTREGION, and GET_RENDER_TYPE, which support report and region presentation. Attribute handling is served by SORTATTRIBUTECODE (sorting attribute codes by length), GETDIMENSIONFORATTRIBUTE, GETATTRIBUTEFORDIMENSION, ENCODE, and DECODE1. Date and time utilities include GETCURRENTDATETIME, GETICXCURRENTDATETIME, and GETFORMATTEDDATE. Environment and security helpers include GETPARAMETERVALUE, GETDEFAULTRESPONSIBILITY, and the access-check function HASFUNCTIONACCESS. Portal-specific logic is provided by STALE_PORTLET, UPDATE_PORTLETS_BYPAGE, and GETPORTALPAGEID, while GETHIERARCHYELEMENTID, GETREGIONAPPLICATIONID, GETREGIONDATASOURCETYPE, and GET_LAST_REFRESH_DATE resolve metadata used during viewer rendering.

Tables Accessed

The package reads and writes a range of Oracle EBS dictionary and portal tables through APPS synonyms. Portal and region metadata are obtained from AK_REGIONS and AK_REGION_ITEMS. Security and menu resolution rely on FND_FORM_FUNCTIONS, FND_MENUS, FND_MENU_ENTRIES, FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, and FND_USER. LOB content is retrieved from FND_LOBS. Portlet personalization and staleness data are held in ICX_PORTLET_CUSTOMIZATIONS. Development and object metadata concerning JDR (JDeveloper Repository) definitions are read from JDR_ATTRIBUTES, JDR_COMPONENTS, and JDR_PATHS. Dynamic SQL support is provided by the built-in DBMS_SQL, and LOB operations by DBMS_LOB.

Usage Notes

BIS_PMV_UTIL is not intended to be called directly by end users. It is invoked internally by the portal rendering engine, the PM Viewer, and by other packages in the DBI/BI stack that require LOV population, attribute sorting, or region resolution. The function UPDATE_PORTLETS_BYPAGE, matched by the user search term, is used to refresh or invalidate portlet content at the portal-page level, complementing STALE_PORTLET, which marks individual portlets as stale based on plug identifier. Customizations and extensions that need to obtain the current responsibility, resolve a function-access check, or read FND LOB content may call these utilities directly, provided the executing user has the required APPS privileges. Because the package depends on internal JDR and AK tables, it should be treated as an internal implementation object; Oracle does not guarantee its signature across patches, and any custom code should be validated after applying EBS release updates or family packs.