Search Results ams_lead




Overview
Explore in AI Chat

Overview

OSM.AS_IMP_CNT_ROL_INTERFACE is a public interface (staging) table in the Oracle E-Business Suite Oracle Marketing (AMS) product, registered under FND Design Data AS.AS_IMP_CNT_ROL_INTERFACE. It is the designated staging surface for contact roles information associated with lead imports, and its documented display name is Lead Import Contact Roles Interface. Because its category is BUSINESS_ENTITY AMS_LEAD, the table participates directly in the AMS lead import pipeline rather than in a standalone marketing activity. The table is described as valid and its lifecycle is active, and the object resides in the APPS_TS_INTERFACE tablespace, the standard repository for interface data in an EBS 12.1.1 or 12.2.2 environment. It is intended to be used in conjunction with AS_IMPORT_INTERFACE, the parent lead import staging table; contact role rows are keyed to a lead import batch through the IMPORT_INTERFACE_ID column. A Data Vault classification heuristic based on the foreign key structure suggests the table is satellite-leaning: it is a dependent descriptive table anchored to parent import and contact-role entities, storing descriptive attributes and acting as an inbound interface rather than an independent business hub. The only documented primary key is IMP_CNT_ROL_INTERFACE_PK on IMP_CNT_ROL_INTERFACE_ID.

Key Information Stored

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

Common Use Cases and Queries

Typical use is pre-import validation and post-import reconciliation of contact role data before it is moved into the production marketing and TCA contact structures. A common query correlates interface rows with their parent import record:

  • Locate roles for a given import batch: SELECT c.imp_cnt_rol_interface_id, c.role_type, c.primary_flag FROM as_imp_cnt_rol_interface c WHERE c.import_interface_id = :batch_id.
  • Trace a TCA contact role back to its interface source: join ORG_CONTACT_ROLE_ID to HZ_ORG_CONTACT_ROLES to compare existing and incoming role definitions.
  • Audit batch execution: filter on REQUEST_ID or PROGRAM_ID to find rows created or updated by a specific concurrent program run.
  • Subscriber scoping: restrict results by SECURITY_GROUP_ID when operating in a CRM Online multi-tenant deployment.

Reporting is typically centered on import success rates, duplicate primary contact detection, and role distribution by type and level.

Related Objects

  • AS_IMPORT_INTERFACE — parent lead import table; joined on IMPORT_INTERFACE_ID.
  • HZ_ORG_CONTACT_ROLES — TCA target table for contact roles; joined on ORG_CONTACT_ROLE_ID (and ORG_CONTACT_ID).
  • FND_SECURITY_GROUPS — join on SECURITY_GROUP_ID for multi-tenant isolation.
  • The AMS lead import concurrent programs and APIs that populate and consume this interface table.