Results for “acd_que_num”

8 results




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

Overview

IEO_ACD_QUEUE_INFO is a configuration table in the Oracle E-Business Suite Interaction Center Technology (IEO) product module. It stores Automatic Call Distributor (ACD) queue setup data that defines how inbound telephony interactions are routed and handled within the Interaction Center. Each row represents a single ACD queue definition, capturing the queue name, the Private Branch Exchange (PBX) with which it is associated, the switch reference type, queue numbering attributes, and various enabler and restart parameters used by the telephony integration layer.

In EBS 12.1.1 and 12.2.2, this table is owned by the IEO schema and holds 23 documented columns. It is referenced during agent login, call routing, and queue monitoring operations performed by the Interaction Center telephony server. Because the table is primarily descriptive of queue configuration and is joined to the parent PBX definition rather than acting as a shared intersection of multiple business entities, the mined Data Vault classification is satellite-leaning. In a Data Vault model, this would suggest treating IEO_ACD_QUEUE_INFO as a satellite attached to a PBX hub, with the ACD queue business key serving as the descriptive context.

Key Information Stored

The table's surrogate primary key is ACD_PK, which maps to the ACD_QUEUE_INFO_ID column. A second unique constraint, ACD_UK, is defined over the business-key combination of ACD_QUEUE_NAME, PBX_NAME, and SREF_TYPE, making these the natural identifiers for an ACD queue. The most significant columns include:

  • ACD_QUEUE_INFO_ID — Surrogate primary key generated for each queue definition row.
  • ACD_QUEUE_NAME — Business name of the ACD queue as known to the telephony system.
  • PBX_NAME — Name of the PBX switch that hosts the queue; part of the unique business key.
  • SREF_TYPE — Switch reference type identifying the PBX configuration variant; also part of the business key and a foreign key to IEO_PBX_INFO.
  • ACD_QUE_NUM — Numeric identifier of the queue on the switch.
  • ACD_QUE_QUALIFIER — Qualifier value used with the queue number for switch-level routing.
  • ACD_QUE_FLAG — Flag indicating queue behavior characteristics.
  • ACD_TYPE — Classification of the ACD queue type.
  • ACTIVE_Y_N — Indicates whether the queue is currently active and available for routing.
  • CDN_SPECIFIER — Controlled Directory Number specifier used in switch routing.
  • ENABLER_INFO_1 through ENABLER_INFO_4 — Reserved enabler parameters passed to the telephony integration layer.
  • RESTART_TIME — Time at which the queue or associated process is restarted.
  • ACTUAL_PBX_NAME — Resolved PBX name actually in use for the queue.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS supporting multi-tenant data partitioning.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the AOL framework.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit tracking.

Common Use Cases and Queries

Typical uses include reconciling EBS queue configuration against the actual PBX switch, reporting on active queue inventory, and troubleshooting agent routing failures.

  • Listing all active queues for a given PBX: SELECT acd_queue_name, acd_que_num, acd_type FROM ieo.ieo_acd_queue_info WHERE pbx_name = :pbx AND active_y_n = 'Y';
  • Joining to the PBX parent to retrieve switch configuration: SELECT q.acd_queue_name, p.* FROM ieo.ieo_acd_queue_info q, ieo.ieo_pbx_info p WHERE q.pbx_name = p.pbx_name AND q.sref_type = p.sref_type;
  • Auditing queue changes over time using LAST_UPDATE_DATE.
  • Filtering by SECURITY_GROUP_ID for multi-org or multi-tenant reporting.

Related Objects

The most significant related objects derive from the documented foreign keys and the parent PBX definition:

  • IEO_PBX_INFO — Parent PBX configuration table, joined on PBX_NAME and SREF_TYPE.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for data partitioning.
  • Other IEO telephony tables that consume queue identifiers for routing and agent state management depend on this configuration.