Results for “cp_phonetype_msg_id”

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

Overview

The IEO_CP_PHONETYPE_MSG_XRS_ALL table is a cross-reference table that resides in the IEO schema and belongs to the Interaction Center Technology (IEO) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to map a telephone phone type to the voice message identifiers used by the Interaction Center telephony server. In practical terms, the table determines which prerecorded voice message is delivered when a specific phone type (for example, an answering machine, a front-hold condition, or a service-specific greeting) is encountered during an inbound or outbound call.

The table is multi-org aware, carrying an ORG_ID column, and it also participates in the EBS data security model through SECURITY_GROUP_ID. The heuristic Data Vault classification mined from the foreign key structure is a link table, meaning it is best modeled as a relationship between the IEO_CP_SERVICES_ALL and IEO_VOICE_MSGS_ALL entities rather than as a standalone hub or satellite. This classification should be treated as a modeling suggestion rather than a documented constraint.

Key Information Stored

The table contains 14 documented columns. The most significant are summarized below:

• CP_PHONETYPE_MSG_ID — The surrogate primary key (constraint IEO_CP_PHONETYPE_MSG_XRS_A_PK). It uniquely identifies each phone-type-to-message mapping row.
• LIST_SRV_NAME — Foreign key to IEO_CP_SERVICES_ALL. Identifies the Interaction Center service with which the mapping is associated, making it a primary business-key candidate alongside PHONE_TYPE.
• SREF_TYPE — The service reference type. Combined with LIST_SRV_NAME and PHONE_TYPE, it forms the second unique index (IEO_CP_PHONETYPE_MSG_XRS_A_UK), confirming the business-key role of this column.
• PHONE_TYPE — The phone-type code that triggers the message selection; this is the column most directly implied by the user search term "phone_type."
• MESSAGEID_ANS_MACHINE — Foreign key to IEO_VOICE_MSGS_ALL; the voice message played when an answering machine is detected.
• MESSAGEID_FRONT_HOLD — Foreign key to IEO_VOICE_MSGS_ALL; the voice message played during the front-hold condition.
• ORG_ID — Operating unit / organization identifier supporting multi-org access.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for data security and partitioning.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/BC4J framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns that audit row creation and modification.

Common Use Cases and Queries

Administrators and developers typically query this table to determine which voice messages will be played given a particular phone type and service. Reporting scenarios include auditing unused message mappings, verifying configuration completeness across operating units, and tracing message behavior during call-center troubleshooting.

A representative join to resolve the message text for a given phone type and service:

• SELECT m.PHONE_TYPE, m.LIST_SRV_NAME, v.MESSAGE_NAME
• FROM IEO_CP_PHONETYPE_MSG_XRS_ALL m, IEO_VOICE_MSGS_ALL v
• WHERE m.MESSAGEID_ANS_MACHINE = v.MESSAGE_ID
• AND m.PHONE_TYPE = :phone_type
• AND m.ORG_ID = :org_id;

A second query identifies all mappings for a specific service:

• SELECT CP_PHONETYPE_MSG_ID, PHONE_TYPE, SREF_TYPE, MESSAGEID_ANS_MACHINE, MESSAGEID_FRONT_HOLD
• FROM IEO_CP_PHONETYPE_MSG_XRS_ALL
• WHERE LIST_SRV_NAME = :service_name
• AND ORG_ID = :org_id;

Related Objects

The following objects have a documented relationship with this table and are the most significant for joins and dependency analysis:

• IEO_CP_SERVICES_ALL — Joined via LIST_SRV_NAME; defines the Interaction Center service to which each mapping belongs.
• IEO_VOICE_MSGS_ALL — Joined via MESSAGEID_ANS_MACHINE and MESSAGEID_FRONT_HOLD; provides the actual voice message definitions.
• FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; enforces data security partitioning.
• IEO_CP_PHONETYPE_MSG_XRS_A_PK — Primary key constraint on CP_PHONETYPE_MSG_ID.
• IEO_CP_PHONETYPE_MSG_XRS_A_UK — Unique constraint on LIST_SRV_NAME, SREF_TYPE, and PHONE_TYPE.

Together with its parent tables, this link table forms the configuration backbone that connects telephony services, phone types, and voice messages in the Oracle Interaction Center.