Results for “as_imp_cnt_rol_interface”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AS_IMP_CNT_ROL_INTERFACE table is a staging object in the Oracle E-Business Suite Sales Foundation (AS) module, owned by the OSM schema. It serves as the interface table that holds contact role information pending import into the Oracle EBS contact and customer data model. In EBS releases 12.1.1 and 12.2.2, tables of this type act as the landing zone for batched, externally sourced data that is subsequently validated and promoted into the transactional contact role structures maintained by the Trading Community Architecture (TCA) layer.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as satellite-leaning. This means the table primarily stores descriptive attribute context attached to a parent hub or link (in this case the import batch and the underlying contact role), rather than acting as an independent business hub. Practitioners designing downstream integration or replication models should treat it as a dependent attribute store tied to its import interface parent.

Key Information Stored

The table contains 19 documented columns. The most operationally significant are:

• IMP_CNT_ROL_INTERFACE_ID — the surrogate primary key, backed by the IMP_CNT_ROL_INTERFACE_PK constraint. This is the value most often referenced in lookups such as imp_cnt_rol_interface_id.
• IMPORT_INTERFACE_ID — the foreign key linking each row to its parent batch in AS_IMPORT_INTERFACE, establishing the import run context.
• ORG_CONTACT_ROLE_ID — the foreign key to HZ_ORG_CONTACT_ROLES, identifying the destination contact role record after import.
• ORG_CONTACT_ID — identifies the organization contact whose role is being staged.
• ORIG_SYSTEM_REFERENCE — the source system's business identifier, a common natural-key candidate for reconciliation.
• ROLE_TYPE and ROLE_LEVEL — define the nature and hierarchy level of the contact role being imported.
• PRIMARY_FLAG and PRIMARY_CONTACT_PER_ROLE_TYPE — flags governing whether the contact is the primary holder for the given role type.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, enforcing multi-org/multi-tenant data isolation.
• REQUEST_ID — the concurrent request that processed or created the row.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and PROGRAM_UPDATE_DATE capture the standard WHO audit trail.

Common Use Cases and Queries

Typical scenarios include troubleshooting failed contact role imports, auditing staging volumes per import batch, and reconciling staged rows against their promoted TCA records.

• Look up a specific staged record by its surrogate key:

SELECT * FROM OSM.AS_IMP_CNT_ROL_INTERFACE WHERE IMP_CNT_ROL_INTERFACE_ID = :id;

• Count staged rows grouped by import batch:

SELECT IMPORT_INTERFACE_ID, COUNT(*) FROM OSM.AS_IMP_CNT_ROL_INTERFACE GROUP BY IMPORT_INTERFACE_ID;

• Trace rows processed by a concurrent program request:

SELECT * FROM OSM.AS_IMP_CNT_ROL_INTERFACE WHERE REQUEST_ID = :request_id;

The surrogate key drive these queries efficiently; ORIG_SYSTEM_REFERENCE is useful where source-system reconciliation is required.

Related Objects

• AS_IMPORT_INTERFACE — joined via IMPORT_INTERFACE_ID; the parent import batch definition.
• HZ_ORG_CONTACT_ROLES — joined via ORG_CONTACT_ROLE_ID; the TCA destination table for promoted contact roles.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; enforces data security and multi-org partitioning.
• HZ_ORG_CONTACTS — the parent contact entity referenced indirectly through ORG_CONTACT_ID.
• Import concurrent programs under the AS/Sales Foundation product that read this staging table and write to TCA contact role tables.

These relationships reflect the standard interface-to-base-table pattern used throughout EBS for bulk data import.