Search Results bsc_sys_image_id_s

Overview

APPS.BSC_PORTLET_GRAPH is a PL/SQL package body in the Oracle E-Business Suite Balanced Scorecard (BSC) module. It renders graphical KPI portlets within the Oracle EBS dashboard framework, generating the HTML and image markup required to display scorecard graphs in portal regions. The package bridges the BSC KPI data model, the ICX (Interaction Center/portal) infrastructure, and the HTML output toolkit, allowing users to embed graphical indicators of key performance metrics directly into personalized dashboard pages. It is classified as an OTHER API rather than a public-method interface, meaning it is intended primarily for internal consumption by the BSC and portal layers rather than direct invocation by external customizations. It resides in the APPS schema, holds VALID status, and carries no dependencies from other database objects.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions. PLUG is the entry point that renders the portlet content. HAS_ACCESS enforces user authorization to view a given portlet or KPI graph, and SHOW_ERR formats error output. DRAW_KPI_GRAPH generates the actual graphical representation of a KPI. URL-oriented helpers include GET_TAB_URL, GET_KPI_URL, GET_PORTLET_KPIGRAPH_URL, and GET_CUSTOMIZED_KPIGRAPH_URL, which construct navigation and drill-down links. Customization logic is handled by GET_CUSTOMIZATION, SET_CUSTOMIZATION, GET_CUSTOMIZED_DATA_PRIVATE, and SET_CUSTOMIZED_DATA_PRIVATE, which read and persist per-user portlet settings. GET_PLUGINFO_PARAMS extracts plug definition parameters, GET_GRAPH_IMAGE retrieves the stored graph image, SAVE_GRAPHKEY persists the graph key, LAUNCH_BSCKPI_JSP redirects to the JSP-based KPI detail view, and RE_ALIGN_HTML_PIECES corrects HTML fragment alignment within the portlet layout.

Tables Accessed

The package reads BSC_KPI_GRAPHS for graph definitions and metadata, BSC_SYS_IMAGES together with the sequence BSC_SYS_IMAGE_ID_S for stored image content and identifier generation, BSC_TAB_INDICATORS for scorecard tab indicator definitions, and BSC_USER_KPIGRAPH_PLUGS for user-specific graph plug configurations. Access control is enforced through BSC_USER_KPI_ACCESS and BSC_USER_TAB_ACCESS, while BSC_USER_RESPONSIBILITY_V, FND_RESPONSIBILITY, and FND_USER_RESP_GROUPS supply responsibility and responsibility-group context used to validate that the current user may see the requested KPI. Portal integration relies on ICX_PAGE_PLUGS. Output and transport utilities include HTP, PLITBLM, UTL_HTTP, and UTL_RAW, used for HTML generation and raw image handling.

Usage Notes

BSC_PORTLET_GRAPH is invoked through the portal plug framework rather than by direct call from forms or concurrent programs. When a user views a dashboard region containing a KPI graph portlet, the ICX page plug invokes the PLUG procedure, which resolves the graph URL, verifies access, retrieves the image, and emits HTML via HTP. The GET_GRAPH_IMAGE and SAVE_GRAPHKEY routines interact with BSC_SYS_IMAGES and the BSC_SYS_IMAGE_ID_S sequence to manage stored graph artifacts. Customizations are scoped per user and per plug through the GET_CUSTOMIZATION and SET_CUSTOMIZATION routines, which read from and write to BSC_USER_KPIGRAPH_PLUGS. Because the package is not referenced by any other database object and is not a public API, customizations should avoid calling its internal procedures directly; integrators should instead extend behavior through the standard portal plug configuration and the documented BSC user-access tables. All objects reside in the APPS schema in both 12.1.1 and 12.2.2.