Search Results prvt_report_tags




Overview
Explore in AI Chat

Overview

SYS.PRVT_REPORT_TAGS is a private (internal) Oracle database package body owned by the SYS schema, shipped as part of the Oracle Database and Oracle E-Business Suite technology stack rather than as a component of the EBS application schema itself. Its status is VALID across the reference releases EBS 12.1.1 and 12.2.2. The package encapsulates the metadata-tagging and diagnostic-reporting logic used by Oracle's SQL tuning and reporting infrastructure. In practice it acts as a supporting library for tools such as DBMS_REPORT, DBMS_SQLTUNE, and DBMS_XPLAN, which generate structured, XML-encoded output for execution plans, SQL Monitor reports, SQL Tuning Advisor findings, and related diagnostics. The package supplies the tag-management routines that label, organize, and format report sections so that the output conforms to Oracle's expected reporting conventions.

Key Procedures and Functions

The ETRM metadata for this object documents zero explicitly listed procedures or functions, and the package is classified as "OTHER" in the API classification scheme. This is expected for a private, internal package whose callable units are not published for customer or application use. Because no procedure signatures are recorded in the source metadata, the individual subprogram parameter lists are intentionally omitted here; they should not be assumed or reconstructed. Based on its documented dependencies, the package exposes internal logic that manipulates report tag structures (using the PLITBLM associative-array package for in-memory collections), aggregates XML fragments (via XMLAGG, SYS_IXMLAGG, and XMLTYPE), and interoperates with report-generation and tuning routines. It also depends on PRVT_EMX, which supplies XML parsing and manipulation utilities, confirming that tag handling is performed on XML-structured report content. The package body is recursive in the sense that it references itself (PRVT_REPORT_TAGS appears in its own dependency list), indicating internal re-use of its tagging routines.

Tables Accessed

The only table-level object documented in the dependency list is XMLAGG, referenced through an APPS synonym in the ETRM view. XMLAGG is the SQL/XML aggregate function that concatenates XML fragments into a single XMLTYPE result, and its appearance reflects the package's core role of assembling tagged XML report content rather than persisting data to application tables. In addition to DUAL (used for lightweight single-row evaluations) and the STANDARD package, the dependencies are overwhelmingly other SYS-supplied packages and types: DBMS_REPORT, DBMS_SQLTUNE, DBMS_SQLTUNE_UTIL0, DBMS_XPLAN, PLITBLM, PRVT_EMX, SYS_IXMLAGG, and XMLTYPE. The package does not appear to write to EBS application tables; it operates on in-memory and XML-structured diagnostic data.

Usage Notes

SYS.PRVT_REPORT_TAGS is not intended for direct invocation by EBS forms, concurrent programs, or custom code. It is an undocumented internal helper and forms no part of any supported public API. According to the ETRM metadata, it is not referenced by any database object, reinforcing its private status. Conversely, the documented metadata records that it is referenced by 22 other packages in the technology stack, which is consistent with its role as a shared utility consumed by Oracle's SQL tuning, SQL Monitor, and reporting framework. Its relevance to an EBS administrator or developer is therefore diagnostic rather than functional: it may appear during dependency analysis, invalidation studies, or troubleshooting of SQL performance reporting in the 12.1.1 and 12.2.2 environments, but it should never be modified, wrapped, or called directly. Any customization or recompilation of SYS-owned packages is unsupported and risks invalidating dependent Oracle components.