Search Results icx_portlet
Overview
The APPS.ICX_PORTLET package body implements the server-side portlet framework used by Oracle E-Business Suite's EBS homepage, the "Personal Home Page" (PHP) and related dashboard regions delivered through the Oracle Applications Framework (OAF) infrastructure. Its central purpose is to control whether a signed-on user is permitted to view a given portlet, to generate the bookmark and execution links that render portlets on the homepage, and to manage the caching layer that stores per-user and per-function portlet state. Access is governed by the standard EBS security model, so that a portlet is displayed only when the underlying function, responsibility, security group, and user-responsibility assignment authorize it. In the 12.1.1 and 12.2.2 code lines the object remains VALID and classified as an OTHER API, indicating it is primarily an internal runtime component rather than a formally published extension interface.
Key Procedures and Functions
The ETRM metadata documents 18 procedures and functions. They fall into three functional groups.
- Security and session validation:
RESPONSIBILITIES(retrieves the responsibilities available to the current user),VALIDATESESSIONPART1,VALIDATESESSIONPART2, andVALIDATESESSION(verify the user's session context),SSOREDIRECT(handles single sign-on redirection), andLISTENER_TOKEN(supports the listener/token mechanism used during portlet invocation). - Link generation:
CREATEBOOKMARKLINKandCREATEFWKBOOKMARKLINKbuild bookmark URLs, whileCREATEEXECLINKandCREATEEXECLINK2build the execution links that run portlets. - Caching utilities:
UPDCACHEBYUSER,UPDCACHEBYFUNCNAME,UPDATECACHEBYUSERFUNC,UPDCACHEKEYVALUEBYUSER,UPDCACHEKEYVALUEBYFUNCNAME,UPDATECACHEKEYVALUEBYUSERFUNC,UPDCACHEKEYVALUEBYPORTLETREF, andGET_CACHING_KEYmaintain and retrieve cache entries scoped by user, function name, or both.
Parameter lists are not exposed in the metadata and should be confirmed from the deployed source before custom invocation.
Tables Accessed
The package reads the standard EBS security and configuration tables through APPS synonyms:
- FND_USER, FND_RESPONSIBILITY, FND_RESPONSIBILITY_VL, FND_USER_RESP_GROUPS, FND_SECURITY_GROUPS, FND_SECURITY_GROUPS_VL — establish the user's responsibilities, security groups, and effective access.
- FND_FORM_FUNCTIONS, FND_MENU_ENTRIES, FND_RUN_FUNCTION — resolve the function that each portlet represents and validate execution privileges.
- FND_PROFILE and FND_WEB_CONFIG — supply profile option values and web configuration settings such as the base URL and cache parameters.
- ICX_PORTLET_CUSTOMIZATIONS — stores user-level portlet personalization used when rendering the homepage.
Database utilities DBMS_SQL, HTP, and OWA_UTIL are used for dynamic SQL and HTML/URL output generation.
Usage Notes
ICX_PORTLET is invoked internally by the EBS homepage and OAF portlet regions rather than by end users directly. It is referenced by nine other database objects, so changes carry downstream impact and the body should not be modified without an approved patch path. Typical invocation points are the Personal Home Page rendering cycle, bookmark/widget link actions, and portlet cache maintenance. Administrators use it indirectly when diagnosing why a portlet is hidden (responsibility/function/security group configuration) or when a portlet displays stale content (cache entries keyed by user and function). It is not a documented public API, so custom code should avoid depending on it; developers requiring portlet customization should use ICX_PORTLET_CUSTOMIZATIONS and supported OAF personalization features instead.
-
PACKAGE BODY: APPS.ICX_PORTLET
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_PORTLET, status:VALID,
-
PACKAGE BODY: APPS.ICX_PORTLET
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_PORTLET, status:VALID,
-
PACKAGE: APPS.ICX_PORTLET
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ICX_PORTLET, status:VALID,
-
PACKAGE: APPS.ICX_PORTLET
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ICX_PORTLET, status:VALID,
-
SYNONYM: APPS.ICX_PORTLET_CUSTOMIZATIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:ICX_PORTLET_CUSTOMIZATIONS, status:VALID,
-
PACKAGE: APPS.ORACLENAVIGATE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ORACLENAVIGATE, status:VALID,
-
PACKAGE BODY: APPS.IRC_LOGIN
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_LOGIN, status:VALID,
-
PACKAGE: APPS.ORACLENAVIGATE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ORACLENAVIGATE, status:VALID,
-
SYNONYM: APPS.ICX_PORTLET_CUSTOMIZATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:ICX_PORTLET_CUSTOMIZATIONS, status:VALID,
-
PACKAGE BODY: APPS.IRC_LOGIN
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_LOGIN, status:VALID,
-
PACKAGE BODY: APPS.IRC_WEB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_WEB, status:VALID,
-
PACKAGE BODY: APPS.IRC_WEB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_WEB, status:VALID,
-
PACKAGE BODY: APPS.FND_PORTLET_DEPENDENCY_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_PORTLET_DEPENDENCY_PKG, status:VALID,
-
PACKAGE BODY: APPS.FND_PORTLET_DEPENDENCY_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_PORTLET_DEPENDENCY_PKG, status:VALID,
-
PACKAGE BODY: APPS.BIS_MV_REFRESH
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BIS_MV_REFRESH, status:VALID,
-
PACKAGE BODY: APPS.ORACLENAVIGATE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLENAVIGATE, status:VALID,
-
PACKAGE BODY: APPS.ORACLENAVIGATE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLENAVIGATE, status:VALID,
-
PACKAGE BODY: APPS.ORACLESSWA
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLESSWA, status:VALID,
-
PACKAGE BODY: APPS.BIS_PMV_UTIL
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BIS_PMV_UTIL, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
PACKAGE BODY: APPS.ORACLEMYPAGE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLEMYPAGE, status:VALID,
-
PACKAGE BODY: APPS.ORACLEMYPAGE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLEMYPAGE, status:VALID,
-
PACKAGE BODY: APPS.BIS_MV_REFRESH
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BIS_MV_REFRESH, status:VALID,
-
PACKAGE BODY: APPS.BIS_PORTLET_PMREGION
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BIS_PORTLET_PMREGION, status:VALID,
-
PACKAGE: APPS.FND_RUN_FUNCTION
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_RUN_FUNCTION, status:VALID,
-
VIEW: APPS.FND_SECURITY_GROUPS_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_SECURITY_GROUPS_VL, object_name:FND_SECURITY_GROUPS_VL, status:VALID,
-
PACKAGE BODY: APPS.ICX_SEC
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_SEC, status:VALID,
-
PACKAGE: APPS.ICX_PORTLET
12.1.1
-
PACKAGE: APPS.ICX_PORTLET
12.2.2
-
12.1.1 DBA Data
12.1.1
-
PACKAGE BODY: APPS.ORACLESSWA
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLESSWA, status:VALID,
-
PACKAGE: APPS.FND_RUN_FUNCTION
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_RUN_FUNCTION, status:VALID,
-
VIEW: APPS.FND_SECURITY_GROUPS_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_SECURITY_GROUPS_VL, object_name:FND_SECURITY_GROUPS_VL, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
SYNONYM: APPS.FND_SECURITY_GROUPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_SECURITY_GROUPS, status:VALID,
-
PACKAGE BODY: APPS.ICX_SEC
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_SEC, status:VALID,
-
PACKAGE BODY: APPS.ORACLEAPPS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLEAPPS, status:VALID,
-
SYNONYM: APPS.FND_SECURITY_GROUPS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_SECURITY_GROUPS, status:VALID,
-
PACKAGE BODY: APPS.ORACLEAPPS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ORACLEAPPS, status:VALID,
-
SYNONYM: APPS.FND_MENU_ENTRIES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_MENU_ENTRIES, status:VALID,
-
SYNONYM: APPS.FND_MENU_ENTRIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_MENU_ENTRIES, status:VALID,
-
PACKAGE: APPS.FND_WEB_CONFIG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_WEB_CONFIG, status:VALID,
-
PACKAGE: APPS.FND_WEB_CONFIG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_WEB_CONFIG, status:VALID,
-
SYNONYM: PUBLIC.OWA_UTIL
12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:OWA_UTIL, status:VALID,
-
SYNONYM: PUBLIC.OWA_UTIL
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:OWA_UTIL, status:VALID,
-
VIEW: APPS.FND_USER_RESP_GROUPS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_USER_RESP_GROUPS, object_name:FND_USER_RESP_GROUPS, status:VALID,
-
VIEW: APPS.FND_USER_RESP_GROUPS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_USER_RESP_GROUPS, object_name:FND_USER_RESP_GROUPS, status:VALID,
-
SYNONYM: APPS.FND_FORM_FUNCTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_FORM_FUNCTIONS, status:VALID,
-
PACKAGE: APPS.ICX_SEC
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ICX_SEC, status:VALID,