Search Results dbms_repcat_fla_utl




Overview
Explore in AI Chat

Overview

DBMS_REPCAT_FLA_UTL is an Oracle-supplied PL/SQL package owned by the SYS schema. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technical stack, this package forms part of the Advanced Replication infrastructure that underpins the multi-tier synchronization of data between the EBS application tier and deployed transaction-processing databases, most notably in the context of Oracle iStore, Oracle Mobile Supply Chain Applications, and other disconnected or distributed deployments. The "FLA" element of the name refers to the Flavored Replication Architecture, a variant of Oracle's symmetric replication mechanism in which subsets of objects are replicated according to defined flavors. The package functions as a utility layer that supports the higher-level replication administration packages by performing low-level schema, object, and version-hash operations required to establish and maintain flavor definitions.

Key Procedures and Functions

The ETRM documentation for DBMS_REPCAT_FLA_UTL records the package as VALID with an API classification of OTHER and documents zero public procedures or functions. In practice, the package is an internal utility whose members are intended for consumption by other replication packages rather than by application code. The dependency listing shows that the package body relies on a collection of SYS-level objects and dictionary views, including ATTRCOL$, COL$, COLTYPE$, OBJ$, REFCON$, SNAP$, TYPE$, and USER$, which together are used to interrogate object metadata, column attributes, referential constraints, and snapshot definitions. The package also depends on DBMS_REPCAT_COMMON_UTL, DBMS_REPCAT_DECL, and the helper function GET_OLDVERSION_HASHCODE2. Because no individual subprograms are documented, integrators should treat every member as internal and unsupported for direct invocation.

Tables Accessed

The package reads from a set of data dictionary base tables rather than from application tables. ATTRCOL$, COL$, COLTYPE$, and TYPE$ provide column and datatype metadata used to construct and validate flavor object definitions. OBJ$ supplies object identity and type information for the objects being replicated. REFCON$ provides referential constraint definitions necessary to maintain consistency across replicated object groups. SNAP$ supplies snapshot metadata. USER$ resolves schema ownership. The dependency (rather than synonym) relationship indicates these are referenced directly at the SYS level, confirming the package operates on replication catalog metadata rather than on EBS application data.

Usage Notes

DBMS_REPCAT_FLA_UTL is not invoked directly from EBS forms, concurrent programs, or typical custom code. The dependency listing shows that it is referenced by seven other SYS packages, namely DBMS_REPCAT_FLA, DBMS_REPCAT_FLA_MAS, DBMS_REPCAT_MIG_INTERNAL, DBMS_REPCAT_RPC, DBMS_REPCAT_RQ, DBMS_REPCAT_UNTRUSTED, and DBMS_REPCAT_UTL. These consumers drive flavor creation, replication group administration, migration, remote procedure calls, and internal job processing. In an EBS 12.1.1 or 12.2.2 environment, the package is exercised implicitly whenever a database administrator generates or refreshes a replication flavor through the Replication Manager or through DBMS_REPCAT calls. Because it is a SYS-owned internal package with no documented public interface, it should never be referenced by name in customizations; any direct dependency risks invalidation during patching or upgrade of the Oracle database or EBS technology stack.