1. Customer Hub (UCM) Master Data Management Reference
  2. Cross-Reference Tables

Cross-Reference Tables

Cross-referencing provides consistency by maintaining an external unique identifier for data from different systems to ensure universal uniqueness of records in the enterprise. Oracle Customer Hub (UCM) stores identification information about external systems that are registered to it.

Cross-reference tables have the following characteristics:

  • A single Oracle Customer Hub (UCM) record maps to one or many records in any registered application.

  • Oracle Customer Hub (UCM) supports cross-referencing for the following objects: Contact, Account, Household, and Financial Account, as well as account-address, account-financial accounts, contact-address, contact-financial accounts, contact-emails, contact-phones, and contact-names.

  • Cross-reference entries are created automatically for the supported objects in SOAP and batch processes.

  • External systems send requests to insert a record. If there is an existing cross-reference entry, then the entry is updated. If there is no existing cross-reference entry, then a new record is inserted. The system ID is the value assigned when the system was registered and system name is the associated name. There are multiple possible external IDs to account for situations where multiple records in an operational application map to a single record in Oracle Customer Hub (UCM). Only the first is stored in the ID tag in a message request, by default.