Search Results dbms_arch_provider_intl




Overview
Explore in AI Chat

Overview

SYS.DBMS_ARCH_PROVIDER_INTL is a server-side PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database kernel, not as an Oracle E-Business Suite product schema object. In the context of EBS 12.1.1 and 12.2.2, it appears in the ETRM dependency listings because EBS instances rest on the underlying database release, and this package is part of the Database File System (DBFS) hierarchical storage infrastructure. Specifically, it supports the archival provider framework used by DBMS_DBFS_HS, Oracle's interface for tiering and archiving database-resident file system content to secondary storage such as tape or external archive providers.

The "_INTL" suffix denotes the internationalization layer of the archival provider API. Its role is to provide the localized and NLS-aware entry points that the base archival provider calls when interacting with external storage media, allowing error messages, identifiers, and metadata handling to respect the database character set and language configuration. The ETRM metadata records the object as VALID with an API classification of OTHER, reflecting that it is an internal kernel package rather than a documented EBS application programming interface.

Key Procedures and Functions

The ETRM 12.2.2 documentation for this object records zero documented procedures or functions. This is consistent with its status as a private kernel-internal package: Oracle does not publish a supported callable specification for DBMS_ARCH_PROVIDER_INTL, and its subprograms are not intended to be invoked directly by application code. Because no procedure or function signatures are documented, none are reproduced here.

What the dependency metadata does establish is that DBMS_ARCH_PROVIDER_INTL depends on DBMS_DBFS_HS and STANDARD. The dependency on DBMS_DBFS_HS confirms that it is a subordinate component of the hierarchical storage framework, and the dependency on STANDARD confirms it is a conventional PL/SQL unit compiled in the SYS schema. The package body exists alongside the specification and is compiled as part of database installation, which is why the specification and body both appear in the metadata listing.

Tables Accessed

The ETRM excerpt lists no tables referenced through APPS synonyms, and none are documented for this package. This is expected: kernel packages of this type operate against internal fixed tables, DBFS store metadata, and the underlying storage-layer structures rather than against EBS application tables such as those in the AP, GL, or HR schemas. No EBS business data is read or written directly by this package, and there is no dependency path recorded to any Oracle Applications product schema.

Usage Notes

DBMS_ARCH_PROVIDER_INTL is referenced by one other package, DBMS_ARCH_PROVIDER_INTL itself, and it appears in the dependent-code listings of DBMS_DBFS_HS. It is never invoked from EBS forms, concurrent programs, or Oracle Application Framework pages, and it exposes no supported API for custom code. In EBS 12.2.2 deployments, where the online patching editioning model and database-level features such as DBFS may be exercised by archiving or content-storage configurations, the package is loaded by the database and used indirectly. Administrators encountering this name during dependency validation, patching analysis, or invalid-object resolution should treat it as an Oracle-supplied database component: it must remain VALID, and any recompilation should be performed only with Oracle-supplied scripts. Attempting to call or modify it is unsupported.