Search Results dbms_swrf_report_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_SWRF_REPORT_INTERNAL is an Oracle-supplied PL/SQL package that forms part of the internal reporting infrastructure underpinning the Automatic Workload Repository (AWR) and related performance diagnostics facilities in the Oracle database. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not an EBS application object and does not reside in the APPS schema. It is owned by SYS and is shipped as part of the core database technology stack on which EBS depends. Its role is to provide the internal machinery used to render AWR-style workload reports, including formatting, layout generation, and report body assembly consumed by higher-level reporting entry points.

The object is recorded as VALID, with the package specification and package body both present. Within the ETRM 12.2.2 metadata it carries an API classification of OTHER, indicating that it is not an exposed, supported application programming interface but rather an internal implementation artifact.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. This is consistent with its designation as an internal package: its callable units are not published for customer or integrator use, and Oracle does not expose their signatures as a supported interface.

Because no procedures or functions are documented, no parameter lists are stated here. The package is nevertheless functionally active, as evidenced by the dependency graph in which it is both a consumer and a provider of compiled units. The presence of both a specification and a body confirms that the package exposes some callable surface to its internal callers, but that surface is deliberately undocumented in the ETRM record.

Tables Accessed

The ETRM metadata does not list any tables referenced via APPS synonyms for this package. This is expected: DBMS_SWRF_REPORT_INTERNAL resides in SYS and operates against database-level performance and workload repository structures rather than against EBS application tables. Consequently, there are no EBS transactional or setup tables associated with it.

The relevant data dependencies are instead expressed as PL/SQL type and package references. The package references SYS.AWRRPT_INSTANCE_LIST_TYPE, a collection type used to represent lists of AWR report instances, along with the STANDARD package. It is in turn referenced by four other packages: DBMS_AWR_REPORT_LAYOUT, DBMS_FEATURE_USAGE_REPORT, DBMS_WORKLOAD_CAPTURE, and DBMS_WORKLOAD_REPOSITORY, and is self-referencing as well.

Usage Notes

DBMS_SWRF_REPORT_INTERNAL is invoked indirectly. Customers and EBS administrators do not call it directly; instead it is exercised through the AWR report generation path, most notably via the DBMS_WORKLOAD_REPOSITORY package and its AWR report procedures, which handle the AWR report and AWR SQL report families. The dependency on AWRRPT_INSTANCE_LIST_TYPE reflects the use of instance-list collections when reports span one or more database instances.

Within an EBS 12.1.1 or 12.2.2 environment, this package is reached when database performance reports are generated for the underlying database tier, whether from SQL*Plus, from database-side scheduling, or as part of diagnostic routines that call DBMS_WORKLOAD_REPOSITORY. Custom code should not reference DBMS_SWRF_REPORT_INTERNAL, as its interface is internal, unsupported, and subject to change across database releases and patch levels. Its inclusion in ETRM is intended for dependency and impact analysis rather than for direct invocation.