Search Results check_rsid

Overview

BIS_RSG_PMV_REPORT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Business Intelligence System (BIS) product family, which underpins the EBS reporting and performance management framework, commonly associated with the "Page Manager" (PMV) and Request Set / Request Group (RSG) functionality. The package status is VALID in both 12.1.1 and 12.2.2.

The package serves as the backend engine for a family of concurrent reporting programs. These reports capture and present performance and diagnostic information about concurrent request processing, including request set execution performance, individual request duration, tablespace utilization, and staging activity. In addition to generating report content, the package provides reusable utility routines for time formatting and timezone handling, and for resolving reference meanings from the underlying page metadata tables. The package is therefore both a reporting hub and a shared utility library within the BIS schema.

Key Procedures and Functions

The ETRM registry documents sixteen public procedures and functions. The reporting entry points, typically invoked as concurrent program executables, are:

• REQUEST_SET_PERF_REPORT — produces summary performance reporting for a request set, drawing on run history to show elapsed behavior across executions.
• REQUEST_SET_PERF_DET_REP — the detailed companion to the summary, exposing per-request timing and stage information within a set.
• REQUEST_SET_SUB_REQ_REP — reports on subordinate requests spawned by a parent request set.
• REQUEST_SET_SPACE_REP — reports on space or storage consumption associated with a request set.
• TABLESPACE_DETAIL_REPORT — provides tablespace-level detail, used for capacity and diagnostics.
• REQUEST_DETAILS_REPORT — emits granular details for individual concurrent requests.

Supporting utilities include:

• DURATION_STR, DURATION_HHMM, and DURATION — formatting helpers that convert raw elapsed-time values into human-readable strings or HH:MM notation.
• GET_MEANING — resolves the display meaning of a coded value from the page/query metadata tables.
• GTITLE — returns or sets the report title used in output headers.
• GET_MAX_STG and GET_LATEST_RUN — retrieve the maximum staging value and the most recent run record, respectively, for reporting context.
• CHECK_RSID — validates a request set identifier.
• RETURNLOGURL — constructs the URL used to link back to the log file for a run.
• DATE_TO_CHARDTTZ — converts a date value to a character representation while applying the organization's timezone setting.

Tables Accessed

The documented underlying tables include BIS_OBJ_REFRESH_HISTORY, BIS_RS_PROG_RUN_HISTORY, and BIS_RS_RUN_HISTORY, which together hold refresh, program-run, and request-set-run history respectively. These provide the historical source data for the performance and detail reports. DUAL supports scalar expressions, and PLITBLM is the standard PL/SQL table load buffer used to build output lines. The package additionally references BIS_PMV_PAGE_PARAMETER_TBL and BIS_QUERY_ATTRIBUTES_TBL, which drive parameter and query-attribute resolution for the PMV reporting layer.

Usage Notes

BIS_RSG_PMV_REPORT_PKG is normally executed indirectly. It is registered as the execution logic of BIS concurrent programs, and it is invoked by BIS_SUBMIT_REQUESTSET and referenced by other BIS packages. Administrators interact with it through the Submit Requests form, selecting the associated report, while developers call the utility functions (duration and date formatting, meaning lookup, log URL construction) from custom BIS code. Because it reads history tables rather than base transactional tables, it is safe to run non-destructively; the only writes are to PLITBLM output buffers. Customizations should avoid modifying the APPS-owned source and instead call the public routines or create wrapper packages.