Search Results bis_graph_region_html_forms




Overview
Explore in AI Chat

Overview

BIS_GRAPH_REGION_HTML_FORMS is an Oracle E-Business Suite package body owned by APPS that supports the Oracle Business Intelligence System (BIS) graphing framework. Its primary business function is to render the HTML forms through which users enter and maintain the parameters stored for a PHP chart (report graph). In the Oracle EBS 12.1.1 and 12.2.2 environments these forms constitute the parameter-entry and chart-rendering region of the BIS/Web-based reporting interface, allowing a user to select a trend plug, supply report parameters, preview the resulting graph, and submit the chart definition.

The package header history confirms it was created in June 2000 by Walid Nasrallah and evolved through 2001 with fixes contributed by Ganesh Sanap and Maneesha Damle. Notable enhancements include preview support via BIS_TREND_PLUG.GET_GRAPH_FROM_URL, exclusion of designated reports, movement of the "WHO" column definition into the database, clearing of cookies on cancel, wrapping of exception messages in HTML comments so they are invisible to end users, and wrapper routines exposing responsibility and function lists to Java. The package is classified as OTHER in the ETRM repository and is referenced by one other package.

Key Procedures and Functions

Three documented program units are exposed by this package body:

  • REVIEW_CHART_RENDER — Renders the chart review/preview region, producing the HTML output used to display the configured graph to the user. It is the principal rendering entry point for the parameter-entry forms.
  • GET_GRAPH_TITLE — Returns the title text associated with a chart or graph, used when composing the HTML header of the rendered region.
  • HASFUNCTIONACCESS — Determines whether the current user holds access to a given function, enabling the forms to conditionally present or suppress options based on function-level security.

The metadata records these names and purposes only; no parameter lists are documented, and none should be assumed. The historical comments additionally indicate wrapper routines that return responsibility and function lists to Java, consistent with the function-access checking behavior of HASFUNCTIONACCESS.

Tables Accessed

The package reads from several APPS synonyms to resolve security context and chart configuration:

  • FND_FORM_FUNCTIONS — supplies function definitions used by HASFUNCTIONACCESS to validate user access.
  • FND_MENU_ENTRIES — provides menu structure used when resolving the responsibilities and functions exposed to the Java client.
  • FND_RESPONSIBILITY — resolves responsibility information for the current session.
  • BIS_USER_TREND_PLUGS — stores the user's saved trend plug and chart parameter definitions, the core data the forms create and maintain.
  • HTF and HTP — the Oracle HTML Toolkit PL/SQL packages used to generate the HTML tags, banners, and markup emitted by REVIEW_CHART_RENDER and the form routines.

Usage Notes

The package is typically invoked from the BIS HTML-based reporting interface or an Oracle Applications Framework region rather than from a standard Oracle Forms module, since it emits HTML directly through HTP and HTF. It is called when a user opens a chart configuration page, selects parameters for a PHP chart, previews the graph through BIS_TREND_PLUG.GET_GRAPH_FROM_URL, and saves the resulting definition into BIS_USER_TREND_PLUGS.

Because the historical notes reference FND_GLOBAL.APPS_INITIALIZE and ICX_PAGE_PLUGS updates, custom code invoking these routines should ensure the session context is properly initialized; the package itself performs that initialization internally in later revisions. Where the search term "g_initialize" is concerned, the only documented reference to initialization behavior is the internal call to FND_GLOBAL.APPS_INITIALIZE, which establishes the APPS security context before function-access and responsibility queries execute. The package is not intended for direct invocation outside the BIS chart administration flow.