Search Results bix_sum_grp_cls_inq

Overview

BIX_SUM_GRP_CLS_INQ is an interaction-center summary table belonging to the BIX (Interaction Center Intelligence) product family. It aggregates detail rows from BIX_INTERACTIONS to the day level across five analytic dimensions: time, agent group, interaction center, campaign, and interaction classification. The table therefore functions as a pre-aggregated fact store used by Interaction Center Intelligence dashboards and historical reporting rather than as an OLTP transaction table.

The ETRM metadata marks this table as belonging to "BIX – Interaction Center Intelligence (Obsolete)" and records that it is not implemented in the reference database. Consequently, in Oracle EBS 12.1.1 and 12.2.2 environments it should be treated as a legacy or superseded object. Its columns may still exist in upgraded instances, but no runtime data population should be assumed. From a heuristic Data Vault modeling perspective, this object is classified as standalone; a reasonable modeling suggestion would be to treat it as a satellite-like summary table with no parent hub or link captured through foreign keys, since its only documented foreign key targets FND_SECURITY_GROUPS.

Key Information Stored

The table is documented with nine columns in the ETRM 12.1.1 physical schema. Its primary key, BIX_SUM_GRP_CLS_INQ_PK, is the surrogate key SUM_GRP_CLS_INQ_ID. A unique key, BIX_SUM_GRP_CLS_INQ_UK, spans the business grain: HOUR, RESOURCE_GROUP_ID, INTERACTION_CENTER_ID, CAMPAIGN_ID, and INTERACTION_CLASSIFICATION. The most significant columns are:

• SUM_GRP_CLS_INQ_ID – surrogate primary key, system-generated.
• HOUR – time dimension bucket; combined with the implied day grain, drives period reporting.
• INTERACTION_CENTER_ID – identifies the interaction center where activity occurred.
• RESOURCE_GROUP_ID – agent or resource group associated with the interaction.
• CAMPAIGN_ID – marketing or outbound campaign attribution.
• INTERACTION_CLASSIFICATION – classification code for the interaction type.
• INQUIRY_TYPE – categorization of the inquiry itself.
• NUMBER_OF_INTERACTIONS – the additive measure; count of interactions for the grain.
• SECURITY_GROUP_ID – foreign key to FND_SECURITY_GROUPS, enforcing Oracle EBS multi-org/security-group data access.

Common Use Cases and Queries

Where populated, the table supports trend analysis and dimensional drill-down for interaction volumes. Typical queries aggregate NUMBER_OF_INTERACTIONS by center, group, campaign, or classification. A representative pattern, filtered through the security group, is:

• SELECT INTERACTION_CENTER_ID, RESOURCE_GROUP_ID, SUM(NUMBER_OF_INTERACTIONS) FROM BIX_SUM_GRP_CLS_INQ WHERE SECURITY_GROUP_ID = :p_sec_grp GROUP BY INTERACTION_CENTER_ID, RESOURCE_GROUP_ID;
• Time-series reporting: filter on HOUR and group by day to plot interaction volume trends.
• Campaign effectiveness: aggregate by CAMPAIGN_ID to compare offered versus handled interactions.
• Agent-group performance: roll up RESOURCE_GROUP_ID to compare groups within a center.
• Classification mix: group by INTERACTION_CLASSIFICATION and INQUIRY_TYPE to profile call drivers.

Because the object is obsolete and unimplemented, these queries should be validated against BIX_INTERACTIONS or the current replacement summary objects before use in production reporting.

Related Objects

• FND_SECURITY_GROUPS – referenced via BIX_SUM_GRP_CLS_INQ.SECURITY_GROUP_ID; governs row-level security filtering.
• BIX_INTERACTIONS – source detail table from which this summary is derived.
• BIX_SUM_GRP_CLS_INQ_PK / BIX_SUM_GRP_CLS_INQ_UK – primary and unique constraints defining surrogate and business grain.
• Interaction center and campaign dimension tables (referenced by INTERACTION_CENTER_ID and CAMPAIGN_ID) – supply descriptive attributes for drill-down.
• Resource/agent group dimension – resolves RESOURCE_GROUP_ID into group names.
• BIX summary siblings – parallel BIX_SUM_* objects that aggregate BIX_INTERACTIONS along alternative dimension combinations.