Search Results dbms_refresh_exp_sites

Overview

SYS.DBMS_REFRESH_EXP_SITES is an Oracle-supplied PL/SQL package that forms part of the core replication and snapshot (materialized view) refresh infrastructure shipped with the Oracle database. It is owned by the SYS schema and is present, in valid status, in both Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Although it resides inside EBS, the package is not an EBS application object; it belongs to the Oracle RDBMS replication component and is delivered with the database rather than with the EBS technology stack.

Functionally, DBMS_REFRESH_EXP_SITES supports the management of refresh groups in distributed and advanced-replication configurations. Refresh groups allow a set of materialized views to be refreshed at a single, consistent point in time, which is essential when interdependent snapshots must remain transactionally consistent. The "_EXP_SITES" suffix indicates that the package handles the export and propagation of refresh group definitions across participating master sites in a multi-master replication topology, ensuring that refresh group metadata is distributed to the correct remote sites.

Key Procedures and Functions

The ETRM documentation records this package as an OTHER-classified API with zero documented procedures or functions. Consequently, no individual subprogram signatures are catalogued in the EBS reference material, and parameter lists are not published for this object.

Based on its role within the replication framework, the package is understood to encapsulate internal logic for exporting refresh group definitions and site information to remote master sites, for importing that metadata at the destination sites, and for maintaining the integrity of refresh group membership across the replication environment. These routines are intended strictly for internal use by the database replication engine. Database administrators and EBS technical consultants should treat the package as a private infrastructure component and should not call its subprograms directly.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms, which is consistent with the package's status as a SYS-owned database component rather than an EBS application object. At runtime, DBMS_REFRESH_EXP_SITES operates against the underlying replication dictionary views and base tables maintained by the database, including the refresh group and refresh group template definitions and the associated site/target metadata used by the replication facility to identify participating master sites.

Because no EBS application tables are documented as being referenced, the package has no direct read or write dependency on EBS transactional or setup tables. Its data footprint is confined to the Oracle replication catalog.

Usage Notes

The package is invoked implicitly by the Oracle replication subsystem. It is not exposed through any EBS form, concurrent program, or standard application workflow, and the ETRM metadata confirms that it is not referenced by any other package. Custom code should never depend on it.

For EBS administrators, the practical significance of DBMS_REFRESH_EXP_SITES is limited to troubleshooting and patch validation. If the replication feature set is not installed or is unused, the package may remain in a dormant, valid state indefinitely. Where advanced replication is configured, the package participates in the propagation of refresh group definitions and should be left untouched. Any decision to recompile or alter it should be avoided; such objects are managed exclusively by Oracle database patching and upgrade tooling, and modifying them risks corrupting the replication catalog.

PACKAGE: SYS.DBMS_REFRESH_EXP_SITES 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REFRESH_EXP_SITES, status:VALID,
PACKAGE: SYS.DBMS_REFRESH_EXP_SITES 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REFRESH_EXP_SITES, status:VALID,
PACKAGE BODY: SYS.DBMS_REFRESH_EXP_SITES 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REFRESH_EXP_SITES, status:VALID,
PACKAGE BODY: SYS.DBMS_REFRESH_EXP_SITES 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REFRESH_EXP_SITES, status:VALID,
PACKAGE: SYS.DBMS_IREFRESH 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_IREFRESH, status:VALID,
PACKAGE: SYS.DBMS_REFRESH_EXP_SITES 12.2.2
PACKAGE: SYS.DBMS_REFRESH_EXP_SITES 12.1.1
TABLE: SYS.SNAP_SITE$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_SITE$, status:VALID,
PACKAGE BODY: SYS.DBMS_REFRESH_EXP_SITES 12.1.1
PACKAGE: SYS.DBMS_IREFRESH 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_IREFRESH, status:VALID,
PACKAGE BODY: SYS.DBMS_REFRESH_EXP_SITES 12.2.2
TABLE: SYS.SNAP_SITE$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_SITE$, status:VALID,
TABLE: SYS.RGROUP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
TABLE: SYS.RGROUP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.DBMS_SYS_ERROR 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
PACKAGE: SYS.DBMS_SYS_ERROR 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
SYS.DBMS_REFRESH_EXP_SITES dependencies on DBMS_REFRESH_EXP_SITES 12.1.1
SYS.DBMS_REFRESH_EXP_SITES dependencies on DBMS_REFRESH_EXP_SITES 12.2.2
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,