Search Results bis_utilities_pub




Overview
Explore in AI Chat

Overview

APPS.BIS_REPORT_UTIL_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Business Intelligence System (BIS) product family. It provides the shared rendering infrastructure used by the BIS web-based reporting framework to assemble HTML report pages served through the Oracle HTTP Server / mod_plsql stack. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the package owner, which is consistent with its role as an internal helper invoked from other BIS reporting packages.

Functionally, the package abstracts the presentation-layer concerns of BIS reports: locating the images and HTML servers, resolving the session NLS language, producing report headers, banners, titles, and footers, building parameter entry forms, and emitting localized icon text. Its most visible members are the server-locator functions, including GET_IMAGES_SERVER and GET_HTML_SERVER, which return the configured base URLs used to construct image and hyperlink references in generated HTML. The source header identifies the file as BISVRUTS.pls (version 115.31), confirming it as a long-standing component of the BIS reporting stack.

Key Procedures and Functions

  • Get_Images_Server — Returns the base URL or virtual directory where report image assets are hosted.
  • Get_HTML_Server — Returns the base URL of the HTML server used for BIS-generated pages.
  • Get_NLS_Language — Returns the current session language code, driving localization of all generated output.
  • Get_Report_Title — Derives the display title for a report from its function code.
  • Build_Report_Header — Emits the HTML document header, including inline JavaScript supplied by the caller.
  • Build_More_Info_Directory — Resolves the help/More Info directory for a given RDF file and language.
  • Get_Translated_Icon_Text — Returns the localized meaning and description for an icon code.
  • Get_Image_File_Structure — Constructs the fully qualified image file path for a report and language.
  • Build_HTML_Banner — Assembles the report banner, including More Info, related reports, and parameter-page links.
  • Build_Report_Title — Renders the report title block using function code, RDF filename, and body attributes.
  • Build_Parameter_Form — Generates the HTML parameter entry form from a BIS parameter table type.
  • Get_After_Form_HTML — Emits trailing HTML after the parameter form.
  • Get_Server_Directory and Get_Home_Page — Return server directory and home page locations for navigation.

Tables Accessed

  • FND_FORM_FUNCTIONS — Resolves function codes to report titles and related metadata.
  • FND_LANGUAGES — Validates and resolves installed NLS languages.
  • FND_CURRENCIES — Supports currency display in titled report output.
  • NLS_SESSION_PARAMETERS — Supplies the active session language and territory.
  • HTP — The PL/SQL HTML generation package used to emit markup.
  • PLITBLM — Provides message/lookup translation for icon and label text.

Usage Notes

BIS_REPORT_UTIL_PVT is not intended for direct customer invocation. It is called by the BIS report-rendering packages and BIS Utilities public APIs, with eleven dependent packages documented. Administrators typically encounter it indirectly through the profile options and configuration that determine the images server, HTML server, and home page values returned by its getter functions. When diagnosing broken images, incorrect hyperlinks, or untranslated report chrome in 12.1.1 or 12.2.2, the relevant settings surfaced by GET_IMAGES_SERVER, GET_HTML_SERVER, and GET_NLS_LANGUAGE are the first items to verify. The package should be treated as internal and subject to change across patches.