Search Results dbmszexp_syspkggrnt

Overview

SYS.DBMSZEXP_SYSPKGGRNT is an Oracle-supplied package that resides in the SYS schema and is delivered as part of the core database installation. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this object is not an Application Object Library (AOL) or Oracle Application-specific package; it belongs to the Oracle Database export/import utility infrastructure. The DBMSZEXP naming prefix identifies the package as a component of Oracle Data Pump and the legacy export facility, where it is used internally to support the export of system-level package grants and privilege metadata during full or schema-level exports.

The ETRM record for this object classifies it as OTHER under the API classification scheme, confirming that it is not exposed as a formal EBS business API. Its status is recorded as VALID, indicating that the package specification and body compile successfully and are present in the database dictionary. Because it is owned by SYS and referenced by PUBLIC through a public synonym, it is accessible to any session with the appropriate privileges, although the EBS application schema (APPS) does not directly depend on it.

Key Procedures and Functions

The documented ETRM metadata for SYS.DBMSZEXP_SYSPKGGRNT lists zero formally documented procedures or functions. This is consistent with the object being an internal, undocumented Oracle kernel package rather than a published PL/SQL API. The package is not documented in the Oracle E-Business Suite developer or user guides, and its routines are not intended for direct invocation by EBS developers or administrators.

Based on Oracle Database internal conventions for the DBMSZEXP family, the package provides helper logic associated with exporting grants on system packages during export operations. Because no parameter lists are published in the ETRM metadata, and because Oracle does not publish signatures for this internal object, no procedure names or arguments should be assumed or used in custom code.

Tables Accessed

No tables accessed via APPS synonyms are documented for this package. The ETRM metadata shows no references to EBS application tables, which is expected given that the package operates within the SYS schema and manipulates data dictionary views rather than application data. The package specification references SYS.STANDARD, the built-in PL/SQL package, which is a normal dependency for compiled PL/SQL units.

The dependency listing further shows that SYS.DBMSZEXP_SYSPKGGRNT is referenced by both PUBLIC (through the public synonym) and SYS itself. It is not referenced by any APPS-owned package, and the documented metadata records zero packages referencing it within the EBS application tier.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2 environments, SYS.DBMSZEXP_SYSPKGGRNT is invoked implicitly by Oracle Database Data Pump (expdp/impdp) and by the legacy exp/imp utilities during system schema exports. It is not called from EBS forms, concurrent programs, or the FNDLIBR or FNDLOAD facilities. Application developers should not reference this package in custom code, as its internal interfaces are unstable across database releases and are not part of the supported public API. Its presence in the ETRM dictionary merely reflects standard Oracle Database installation metadata captured during EBS environment documentation, and it carries no business configuration significance for the E-Business Suite application layer.

PACKAGE: SYS.DBMSZEXP_SYSPKGGRNT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
PACKAGE: SYS.DBMSZEXP_SYSPKGGRNT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
PACKAGE BODY: SYS.DBMSZEXP_SYSPKGGRNT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
SYNONYM: PUBLIC.DBMSZEXP_SYSPKGGRNT 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
SYNONYM: PUBLIC.DBMSZEXP_SYSPKGGRNT 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
PACKAGE BODY: SYS.DBMSZEXP_SYSPKGGRNT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSZEXP_SYSPKGGRNT, status:VALID,
PACKAGE: SYS.DBMSZEXP_SYSPKGGRNT 12.1.1
PACKAGE: SYS.DBMSZEXP_SYSPKGGRNT 12.2.2
PACKAGE BODY: SYS.DBMSZEXP_SYSPKGGRNT 12.1.1
PACKAGE: SYS.DBMS_ZHELP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ZHELP, status:VALID,
PACKAGE BODY: SYS.DBMSZEXP_SYSPKGGRNT 12.2.2
PACKAGE: SYS.DBMS_ZHELP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ZHELP, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMSZEXP_SYSPKGGRNT dependencies on DBMSZEXP_SYSPKGGRNT 12.1.1
SYS.DBMSZEXP_SYSPKGGRNT dependencies on DBMSZEXP_SYSPKGGRNT 12.2.2
PUBLIC.DBMSZEXP_SYSPKGGRNT dependencies on DBMSZEXP_SYSPKGGRNT 12.1.1
PUBLIC.DBMSZEXP_SYSPKGGRNT dependencies on DBMSZEXP_SYSPKGGRNT 12.2.2
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,