Search Results dbms_report_lib




Overview
Explore in AI Chat

Overview

SYS.DBMS_AUTO_REPORT is a core Oracle Database PL/SQL package body that provides the infrastructure for the Automatic Workload Repository (AWR) automatic report capture and repository management facility. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package operates beneath the AWR reporting layer that EBS DBAs rely on for performance diagnostics, but it is not an EBS application object. It belongs to the SYS schema and is delivered as part of the standard database installation rather than the EBS product schema set. Its business function is to schedule, capture, store, and retrieve AWR-style reports automatically, persisting their metadata and content in the Workload Repository history views so that DBAs can review past performance snapshots without manually generating each report.

The package body is currently VALID in the documented environment. It references a defined set of supporting objects and, notably, is not referenced by any database object, meaning no other stored object depends upon it. This unidirectional dependency pattern is typical of a top-level utility package invoked directly by the database scheduler or by DBAs.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package body:

  • START_REPORT_CAPTURE — Initiates a report capture operation, establishing the context required to collect performance data into the repository.
  • START_REPORT_CAPTURE_HELPER — A helper routine that supports the start-of-capture workflow, factored out to isolate internal setup logic from the public entry point.
  • FINISH_REPORT_CAPTURE — Completes a report capture operation, finalizing and persisting the captured report data.
  • FINISH_REPORT_CAPTURE_HELPER — The supporting helper for the finish-capture workflow, encapsulating internal completion logic.
  • REPORT_REPOSITORY_LIST_XML — Returns a listing of the report repository in XML form, suitable for programmatic consumption.
  • REPORT_REPOSITORY_DETAIL_XML — Returns detailed information about a specific repository report in XML form.
  • REPORT_REPOSITORY_DETAIL — Returns detail for a repository report in non-XML form.

The paired START/FINISH procedures and their helpers indicate a two-phase capture model, while the three REPORT_REPOSITORY routines expose the stored reports for listing and inspection. The user search term "dbms_report_lib" corresponds to the DBMS_REPORT_LIB dependency, which this package relies upon for shared reporting primitives.

Tables Accessed

The package body reads and writes the following documented objects:

  • DBA_HIST_REPORTS — The primary Workload Repository table storing report metadata; the capture routines write entries here and the repository inquiry routines read from it.
  • DBA_HIST_REPORTS_DETAILS — Stores the detail content associated with each captured report.
  • WRP$_REPORTS_CONTROL — An internal control table governing report capture behavior.
  • DUAL — Used for scalar evaluations and single-row queries.

Usage Notes

DBMS_AUTO_REPORT is normally invoked by internal Oracle Database scheduling machinery, such as the automatic report capture job configured through database initialization parameters, rather than from EBS forms or concurrent programs. EBS DBAs interact with it primarily through database-level diagnostics rather than through the EBS application tier. Because the package is owned by SYS and is not referenced by any other object, custom code should not depend on it. Its dependencies on DBMS_LOCK, DBMS_REPORT, DBMS_REPORT_LIB, DBMS_SQLTUNE_UTIL2, DBMS_SYS_ERROR, PRVT_REPORT_TAGS, XMLTYPE, and XQSEQUENCE confirm it is tightly bound to Oracle's internal reporting and XML infrastructure. In EBS 12.1.1 and 12.2.2 environments, the package is present whenever the underlying database release supports AWR auto-report functionality, and any issues with it are addressed through database patching rather than EBS patching.