Search Results dbms_zhelp




Overview
Explore in AI Chat

Overview

SYS.DBMS_ZHELP is a server-side PL/SQL package owned by the SYS schema and shipped as part of the core Oracle Database kernel. In Oracle E-Business Suite 12.1.1 and 12.2.2 it is not an application-facing API but an internal infrastructure utility. Its name and dependency footprint place it within the family of packages that support export, import and Data Pump operations. The "ZHELP" designation indicates that the package provides helper routines consumed by the export and import subsystem rather than being invoked directly by end users, forms, or concurrent programs. The package is documented as VALID, meaning it is compiled and available in the database dictionary; an invalid state would indicate a failed upgrade or an incomplete database patch application.

Key Procedures and Functions

The ETRM metadata records zero documented public procedures or functions for this package. This is consistent with its classification as an internal helper: its callable units are consumed by other kernel packages and are not exposed as a supported public API in EBS. No parameter lists are published, and none should be assumed. The absence of documented entry points means DBAs and developers have no supported interface to call directly; any attempt to reference the package by name in custom code would rely on undocumented internals that Oracle may change between patch sets or database releases.

Tables Accessed

The documented metadata does not list any tables accessed via APPS synonyms. This is expected, because DBMS_ZHELP operates within the SYS-owned kernel layer and works against dictionary and export-related structures rather than the EBS application schema. Any internal dictionary references it makes are outside the scope of application data model documentation.

Usage Notes

The documented dependency graph is the most informative element of the metadata. DBMS_ZHELP references only SYS.STANDARD, the implicit base package present in every PL/SQL compilation. It is in turn referenced by eleven other objects, which is the definitive signature of a shared helper. The referencing package DBMSZEXP_SYSPKGGRNT grants privileges on export system packages. Several others — DBMS_AQ_SYS_EXP_INTERNAL, DBMS_AW_EXP, DBMS_FILE_GROUP_EXP, DBMS_RMGR_GROUP_EXPORT, DBMS_RMGR_PLAN_EXPORT, DBMS_RULE_EXP_EC_INTERNAL, DBMS_RULE_EXP_RL_INTERNAL and DBMS_RULE_EXP_RS_INTERNAL — are the export-side implementations for Advanced Queuing, Analytic Workspaces, file groups, Resource Manager and Rules Manager. DBMS_SCHED_MAIN_EXPORT covers the Scheduler. A self-reference by DBMS_ZHELP indicates recursive internal use, and LBACSYS.LBAC_UTL shows the package is also used by Oracle Label Security. In EBS terms this means the package participates whenever a full or schema-level export, Data Pump job, or certain patch and cloning operations are executed against the database; a missing or invalid DBMS_ZHELP will typically manifest as ORA errors from the referencing export packages during those activities. It is public-synonymed to PUBLIC, so it is resolvable from any schema, but it should be treated as Oracle-internal and never invoked, altered, or recompiled by application code.