Search Results hz_imp_contacts_int_u1

Overview

AR.HZ_IMP_CONTACTS_INT is a TCA (Trading Community Architecture) interface table owned by the AR schema and registered under the product code HZ (Contacts). It serves as a staging area for bulk contact and relationship data before that data is validated and migrated into the production TCA tables HZ_RELATIONSHIPS, HZ_ORG_CONTACTS, and HZ_PARTIES. The object is classified as a business entity (HZ_CONTACT) with public scope and an active lifecycle, and its Display Name is "Contact." Physically it resides in the APPS_TS_INTERFACE tablespace with PCT_FREE set to 10, characteristic of an interface table subject to frequent purge cycles.

From a heuristic Data Vault modeling perspective, the table behaves as a satellite-leaning structure. It records descriptive and attribute-level details about contacts and relationship subjects, anchored to a batch via BATCH_ID, which acts as the hub reference. This aligns with the foreign key from HZ_IMP_CONTACTS_INT.BATCH_ID to HZ_IMP_BATCH_SUMMARY.

Key Information Stored

The table contains 57 documented columns. The most significant are:

• BATCH_ID (NUMBER, 15) — unique identifier for an import batch; the hub reference and first component of both unique and non-unique indexes.
• CONTACT_ORIG_SYSTEM and CONTACT_ORIG_SYSTEM_REFERENCE — the originating system ID and reference for the contact, forming part of the unique business key.
• SUB_ORIG_SYSTEM / SUB_ORIG_SYSTEM_REFERENCE and OBJ_ORIG_SYSTEM / OBJ_ORIG_SYSTEM_REFERENCE — identify the subject and object parties of a relationship.
• INSERT_UPDATE_FLAG — indicates whether a row should be explicitly inserted or updated.
• CONTACT_NUMBER — user-defined contact identification number.
• DEPARTMENT_CODE, DEPARTMENT, TITLE, JOB_TITLE, JOB_TITLE_CODE — organizational and job attributes.
• DECISION_MAKER_FLAG and REFERENCE_USE_FLAG — boolean role indicators for the contact.
• RELATIONSHIP_TYPE / RELATIONSHIP_CODE — define the relationship semantics populated into HZ_RELATIONSHIPS.
• INTERFACE_STATUS and ERROR_ID — control the import state and error diagnostics.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield storage.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — concurrent program audit context.

The surrogate identifier is BATCH_ID; the unique business key is defined by the index HZ_IMP_CONTACTS_INT_U1 on (BATCH_ID, CONTACT_ORIG_SYSTEM, CONTACT_ORIG_SYSTEM_REFERENCE). A secondary index, HZ_IMP_CONTACTS_INT_N1, covers (BATCH_ID, SUB_ORIG_SYSTEM, INTERFACE_STATUS, SUB_ORIG_SYSTEM_REFERENCE) to support status-driven processing.

Common Use Cases and Queries

This table is central to bulk contact import via the Contact Import concurrent program. Typical operations include staging, validation, and error remediation. Representative queries:

• Report rows pending import: SELECT * FROM AR.HZ_IMP_CONTACTS_INT WHERE BATCH_ID = :p AND INTERFACE_STATUS = 'PENDING';
• Extract error batch detail: SELECT CONTACT_ORIG_SYSTEM_REFERENCE, ERROR_ID FROM AR.HZ_IMP_CONTACTS_INT WHERE INTERFACE_STATUS = 'ERROR';
• Map relationships by subject: join on SUB_ORIG_SYSTEM_REFERENCE to verify party resolution prior to promotion.
• Reconciliation reporting by REQUEST_ID to confirm what each concurrent run consumed.

Related Objects

• HZ_IMP_BATCH_SUMMARY — parent batch metadata referenced via BATCH_ID.
• HZ_PARTIES — target of contact party creation.
• HZ_ORG_CONTACTS — target for organizational contact role data.
• HZ_RELATIONSHIPS — target for relationship rows derived from SUB_/OBJ_ columns.
• HZ_IMP_CONTACTS_INT_T1 or staging purge programs — typically consume rows using INTERFACE_STATUS.
• The Contact Import program in the HZ module, which reads this interface table and populates the production tables listed above.