Search Results dbms_repcat_fla_mas




Overview
Explore in AI Chat

Overview

DBMS_REPCAT_FLA_MAS is a SYS-owned PL/SQL package shipped with the Oracle database server, not an Oracle E-Business Suite application object. In Oracle EBS 12.1.1 and 12.2.2, it is nevertheless present in every environment because the database release bundled with EBS includes the full Oracle Advanced Replication / symmetric replication infrastructure. The package name reflects its role: a "FLA" (flavor) "MAS" (master) helper within the DBMS_REPCAT family, the replication management subsystem that controls master groups, master sites, snapshots, and conflict resolution.

Its business function is administrative rather than transactional. When an EBS deployment or a related integration uses Oracle Advanced Replication to propagate data between master sites — historically seen in multi-site distribution of selected reference or configuration data — the DBMS_REPCAT package invokes DBMS_REPCAT_FLA_MAS to mediate flavor and master-group operations. Flavor definitions determine which columns of a replicated object participate in replication at a given master site, and this package supplies the internal handlers that apply and validate those definitions. It contains no EBS business rules and is never called by EBS forms or concurrent programs directly.

Key Procedures and Functions

The ETRM 12.2.2 documentation records zero documented procedures or functions for DBMS_REPCAT_FLA_MAS at the specification level exposed to applications. The package specification and package body are shown as present and the object is VALID, so callable units exist, but they are Oracle-internal and undocumented for customer use. The dependency list confirms that the package references DBMS_REPCAT and STANDARD, and is itself referenced by DBMS_REPCAT_DEFINER and by DBMS_REPCAT_FLA_MAS (recursive references within its own body).

The package should therefore be treated as a private implementation layer of the replication management APIs. It is not a supported entry point for customer or EBS extension code. Because no procedures are inventoried in the ETRM metadata, no purpose statements can be attributed to individual program units without inventing them, and that is deliberately avoided here.

Tables Accessed

The ETRM metadata lists no tables accessed through APPS synonyms for this package. That is expected: DBMS_REPCAT_FLA_MAS is a SYS-owned dictionary-layer package and operates against Oracle's internal replication catalog views and tables, such as the replication objects, flavor definitions, and master-group metadata maintained by the Advanced Replication feature. Access is made under SYS privileges against dictionary structures rather than through EBS application schemas. No EBS application tables, views, or synonyms are documented as dependencies.

Usage Notes

  • Do not invoke DBMS_REPCAT_FLA_MAS from custom EBS code. It is an internal Oracle package; direct calls are unsupported and may produce unpredictable catalog state.
  • It is reached only indirectly, through supported Advanced Replication management routines in DBMS_REPCAT and its definer variant, during flavor and master-group configuration on a master site.
  • No EBS form, concurrent program, or standard EBS workflow invokes it. Presence in the EBS database schema is incidental to the underlying Oracle database release.
  • If DBMS_REPCAT_FLA_MAS becomes INVALID, the typical remedy is recompilation of the SYS replication packages (for example, utlrp.sql in SYS), since invalidation usually follows database upgrades or changes to DBMS_REPCAT.
  • Migration to Oracle GoldenGate or other modern replication removes any operational relevance of this package, and it can be ignored for EBS 12.1.1 and 12.2.2 sizing, patching, and performance tuning decisions.
  • Because ETRM documents no procedures, no parameters, and no tables, it should be catalogued as an internal technical object only — not as an integration or customization point.