Search Results sum_grp_cls_inq_id

Overview

The BIX.BIX_SUM_GRP_CLS_INQ table is a summary data repository within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed for the Oracle Interaction Center (IC) and CRM analytics. It serves as a performance summary table, aggregating interaction data at an hourly granularity for reporting and analytical purposes. Its primary role is to store pre-aggregated metrics related to customer inquiries handled by agent groups, classified by interaction type and campaign, thereby enabling efficient historical reporting without querying transactional tables directly. The table's status is VALID, and it resides in the APPS_TS_SUMMARY tablespace, indicating its function within the summary layer of the application architecture.

Key Information Stored

The table stores aggregated interaction metrics along with their defining dimensions. The primary key is SUM_GRP_CLS_INQ_ID, a unique system-generated identifier. Key dimensional columns include INTERACTION_CENTER_ID (sourced from CCT_CALL_CENTER), RESOURCE_GROUP_ID (identifying the agent's group), INQUIRY_TYPE, CAMPAIGN_ID, and INTERACTION_CLASSIFICATION (the routing module's classification). The temporal dimension is captured in the HOUR column, which stores the date and hour of the summary. The core metric is the NUMBER_OF_INTERACTIONS column, which holds the count of interactions that make up the sums for the specified dimensional combination. Additional columns like SECURITY_GROUP_ID support multi-org or hosting configurations.

Common Use Cases and Queries

This table is central to generating performance reports for contact center management. Common use cases include analyzing hourly inquiry volumes by agent group, measuring campaign effectiveness by tracking generated interactions, and understanding inquiry type distribution. A typical analytical query would aggregate the NUMBER_OF_INTERACTIONS across various dimensions. For example, to report total interactions per resource group for a specific date range, one might use:

• SELECT RESOURCE_GROUP_ID, SUM(NUMBER_OF_INTERACTIONS) AS TOTAL_INTERACTIONS FROM BIX.BIX_SUM_GRP_CLS_INQ WHERE HOUR BETWEEN TRUNC(SYSDATE-7) AND TRUNC(SYSDATE) GROUP BY RESOURCE_GROUP_ID ORDER BY TOTAL_INTERACTIONS DESC;

Another common pattern is to join this summary data with lookup tables (e.g., for campaign names) to produce enriched managerial reports on interaction throughput and classification trends.

Related Objects

Based on the provided metadata, the table has a defined primary key constraint named BIX_SUM_GRP_CLS_INQ_PK on the SUM_GRP_CLS_INQ_ID column. The table is referenced by an APPS synonym named BIX_SUM_GRP_CLS_INQ, which is the standard access point for EBS application code. The column INTERACTION_CENTER_ID is documented as originating from the CCT_CALL_CENTER table, indicating a logical foreign key relationship for validating call center identifiers. There are no other explicitly documented foreign key constraints or dependencies in the provided excerpt.