Search Results dbms_sync_refresh




Overview
Explore in AI Chat

Overview

SYS.DBMS_SYNC_REFRESH is a proprietary Oracle-supplied PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database kernel supporting Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its name and internal dependency structure indicate that its purpose is to coordinate synchronization and refresh operations across distributed or materialized data structures. Within the EBS technology stack, such utilities are used to keep replicated, cached, or staged metadata consistent with authoritative source objects, particularly in environments where multiple application tier nodes, database links, or materialized views participate in the same logical data set. The package is classified under the ETRM API classification of OTHER, reflecting that it is not an Applications-owned public API, but an internal database kernel component that EBS platforms may leverage indirectly.

Key Procedures and Functions

The ETRM documentation for release 12.2.2 records zero documented procedures or functions for this package. No callable entry points, parameter lists, or return signatures are published in the metadata. This is consistent with the object being an internal, undocumented kernel package rather than a supported application programming interface. The absence of documented subprograms means that the package is not intended for direct invocation by EBS developers or administrators. Its behavior is exposed only through the SQL statements and internal dependencies recorded in the data dictionary, and any usage should be treated as unsupported.

Tables Accessed

The documented metadata identifies no application tables referenced through APPS synonyms. The package body references only database-level dependencies, specifically the SYS-owned collection type CANSYNCREFARRAYTYPE, the DBMS_UTILITY package, and the STANDARD package. This dependency set confirms that DBMS_SYNC_REFRESH operates on array-based data structures and utility routines rather than on EBS application schema tables such as those in the AP, GL, or INV schemas. Any table interaction is therefore internal to the kernel and not exposed through the EBS data model.

Usage Notes

DBMS_SYNC_REFRESH is referenced by PUBLIC and by SYS, indicating that it is granted for general invocation but is nonetheless an internal component. It is not invoked by any documented EBS forms, concurrent programs, or other PL/SQL packages; the ETRM metadata records zero packages referencing it. In practice, administrators should not call this package directly. Its likely role is as a supporting utility during database-level refresh or synchronization operations, operating beneath the Applications layer. Custom code should avoid depending on it, because Oracle does not document its interface and may change it between releases. Where refresh or synchronization functionality is required in an EBS context, supported alternatives such as the AD Administration utilities, materialized view refresh mechanisms, or documented EBS APIs should be used in preference to this kernel package.