Results for “hz_dqm_sync”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HZ_DQM_SYNC is a public PL/SQL package in the Oracle E-Business Suite (EBS) applications schema (APPS) that supports the Data Quality Management (DQM) synchronization framework underlying the Trading Community Architecture (TCA) and Oracle Customers Online. Its central purpose is to keep the TCA "shadow" or denormalized entities in step with their master records inside the HZ_PARTIES model. The package provides procedures that propagate inserts and updates performed on core TCA entities—parties, organizations, persons, party sites, contacts, contact points, locations, relationships, and customer accounts—into the corresponding synchronization and staging interface tables.
In addition to incremental single-record synchronization, HZ_DQM_SYNC supports bulk staging for party merges and party site merges, index optimization, work-unit-driven concurrent processing, and real-time synchronization. The package is authored with AUTHID CURRENT_USER. The embedded header ($Header: ARHDQSNS.pls 120.7 2006/01/19) places the source in the AR/Receivables module family, consistent with TCA's historical roots in Oracle Receivables.
Key Procedures and Functions
The documented interface includes the following procedures, each described by purpose only (parameter lists are not reproduced):
- SYNC_ORG — synchronizes an organization party record.
- SYNC_PERSON — synchronizes a person party record.
- SYNC_PARTY_SITE — synchronizes a party site record.
- SYNC_CONTACT — synchronizes an organization contact.
- SYNC_CONTACT_POINT — synchronizes a contact point.
- SYNC_LOCATION — synchronizes a location record.
- SYNC_RELATIONSHIP — synchronizes a party relationship.
- SYNC_CUST_ACCOUNT — synchronizes a customer account.
- SYNC_PARTIES — bulk synchronization of parties (present but commented out in the source).
- OPTIMIZE_INDEXES — maintains/reorganizes indexes used by the DQM synchronization process.
- STAGE_PARTY_MERGE and STAGE_PARTY_SITE_MERGE — stage party and party site merge operations into the sync interface.
- STAGE_CONTACT_MERGE and STAGE_CONTACT_POINT_MERGE — stage contact and contact point merge operations.
- REALTIME_SYNC — performs inline synchronization for a DQM event.
- SYNC_WORK_UNIT and SYNC_WORK_UNIT_IMP — process synchronization units, including an implementation variant.
- SYNC_INDEX_CONC — concurrent-program entry point for index synchronization.
- SET_TO_BATCH_SYNC — toggles processing to batch rather than real-time mode.
- INSERT_SH_INTERFACE_REC — inserts a shadow interface record.
- IS_SHADOW_STAGING_COMPLETE — tests whether shadow staging has finished.
Tables Accessed
Documented table references resolve through APPS synonyms. Core TCA tables read include HZ_PARTIES, HZ_PARTY_SITES, HZ_CONTACT_POINTS, HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, and HZ_CUST_ACCOUNTS. The synchronization and working storage tables written include HZ_DQM_SYNC_INTERFACE, HZ_DQM_SYNC_INTERFACE_S, HZ_DQM_SH_SYNC_INTERFACE, HZ_DQM_SH_SYNC_INTERFACE_S, HZ_DQM_STAGE_LOG, and the global temporary structure HZ_DQM_SYNC_GT. Supporting references include FND_CONCURRENT_REQUESTS (concurrent program context), WF_EVENT_T (Workflow business events), and AD_CTX_DDL (AD context/index DDL operations).
Usage Notes
HZ_DQM_SYNC is invoked indirectly rather than by end users. TCA forms (Customers, Suppliers, Parties) and the TCA APIs trigger the single-record SYNC_* procedures after commit. Merge operations call the STAGE_*_MERGE procedures. Concurrent programs drive SYNC_WORK_UNIT, SYNC_WORK_UNIT_IMP, SYNC_INDEX_CONC, and the batch-mode paths, with progress and errors recorded in HZ_DQM_STAGE_LOG. Workflow events surfaced through WF_EVENT_T support real-time propagation. The package is referenced by 16 other packages, so customizations should call it only through documented entry points and should not modify it in place; patching or cloning it risks breaking the DQM chain across Oracle Customers Online, TCA, and downstream Receivables integrations.
-
PACKAGE: APPS.HZ_DQM_SYNC 12.2.2
-
PACKAGE: APPS.HZ_DQM_SYNC 12.1.1
-
SYNONYM: APPS.HZ_DQM_SYNC_GT 12.1.1
-
SYNONYM: APPS.HZ_DQM_SYNC_GT 12.2.2