Search Results dbms_rectifier_diff_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_RECTIFIER_DIFF_INTERNAL is an Oracle-supplied PL/SQL package that resides in the SYS schema and carries a VALID status within the E-Business Suite 12.1.1 and 12.2.2 environments. It is an internal helper package rather than an end-user API. Its purpose is to support the DBMS_RECTIFIER_DIFF family of utilities, which Oracle provides to detect and report differences between two tables or two sets of data. In the EBS context, such rectifier utilities are used to compare data that is expected to be identical, such as replicated tables, materialized view bases, or synchronized data sets across environments. The internal package encapsulates the low-level comparison logic that the public DBMS_RECTIFIER_DIFF interface delegates to, and is therefore not intended for direct invocation by developers or administrators.

Key Procedures and Functions

The documented ETRM metadata for this object lists no exposed procedures or functions. Because DBMS_RECTIFIER_DIFF_INTERNAL is an internal implementation package, its callable units are not published as a supported API surface. The absence of documented subprograms is expected: Oracle exposes DBMS_RECTIFIER_DIFF as the public package that developers invoke, while DBMS_RECTIFIER_DIFF_INTERNAL supplies the underlying comparison and reconciliation routines that the public package calls. Administrators should treat the internal package as a black box and interact only with the public wrapper where a data-comparison operation is required.

Tables Accessed

The ETRM metadata does not document any application tables accessed through APPS synonyms, and the dependency list shows no direct references to EBS application tables. The dependency information instead identifies the package as referencing standard SYS utilities: DBMS_DB_VERSION, DBMS_UTILITY, STANDARD, and SYS_STUB_FOR_PURITY_ANALYSIS. These dependencies indicate that the package uses database version detection, generic utility routines, and standard PL/SQL language constructs rather than reading or writing EBS data model tables. Any table comparison performed by the rectifier framework is driven dynamically through the public DBMS_RECTIFIER_DIFF package, which accepts table and column identifiers at runtime. Direct knowledge of which tables are inspected therefore resides with the calling code, not with this internal package.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is not invoked from forms, concurrent programs, or standard application flows. It is referenced only by SYS.DBMS_RECTIFIER_DIFF, which in turn is referenced by one other package according to the metadata. The public DBMS_RECTIFIER_DIFF package provides the documented procedures for building comparison tables and rectifying differences, and it is this public interface that DBAs and developers should use when validating data consistency. Direct calls to DBMS_RECTIFIER_DIFF_INTERNAL are not supported and should be avoided, since Oracle may change its internal structure, subprogram signatures, or behavior without notice during patching or upgrades. From a maintenance perspective, the package should be treated as an immutable Oracle component: it requires no configuration, holds no application data, and is preserved through standard database upgrades and EBS patching cycles. Its presence in the SYS schema confirms that it is part of the Oracle kernel rather than an EBS application object, and any troubleshooting involving it should be directed to the public rectifier utilities or to Oracle Support.