Search Results bix_dm_default_group

Overview

BIX_CALLS_HANDLED_BIN_PKG is an Oracle EBS Applications (APPS) package body that supports the Oracle Telephony / Interaction Center Intelligence (BIX) reporting infrastructure. Its specific role is to populate a single dashboard "bin" — an aggregated result set keyed to the bin code BIX_CALLS_HANDLED_BIN — inside the staging table BIX_DM_BIN. This bin presents inbound and outbound call volumes handled by the agents of a selected agent group, and it is consumed by BIX dashboard regions and reports that render call-handling metrics for Contact Center managers and supervisors.

The package belongs to the OTHER API classification, meaning it is an internal, non-public utility rather than a supported public API. It is not designed to be called by external integrations; instead it is invoked by the BIX data mart refresh and by the dashboard rendering framework when the calls-handled bin must be materialized for the current user session.

Key Procedures and Functions

• POPULATE — The single documented procedure. It accepts an optional p_context parameter (declared with a default), which supplies the execution context for the refresh. Its responsibilities are: (1) resolve the current ICX session identifier via icx_sec.g_session_id; (2) delete any pre-existing BIX_DM_BIN rows for the current session and bin code, ensuring the bin is rebuilt cleanly; (3) determine the reporting agent group, first by reading the profile option BIX_DM_DEFAULT_GROUP, and if that is null, by selecting any one group to which the current user belongs through JTF_RS_GROUP_MEMBERS and JTF_RS_RESOURCE_EXTNS; (4) resolve the maximum period_start_date present in BIX_DM_AGENT_CALL_SUM so the bin always reflects the latest collected data; and (5) insert the aggregated result rows into BIX_DM_BIN with parallel hints.

Note that when the user is not associated with any resource group, the procedure returns without inserting data, so the bin displays no rows by design.

Tables Accessed

• BIX_DM_BIN — The destination staging table. Rows are first deleted for the current session/bin combination and then re-inserted with the session id, bin code, group identifier, source name, and summed inbound and outbound call counts.
• BIX_DM_AGENT_CALL_SUM — Supplies the per-agent call summary facts and the maximum reporting period date.
• BIX_DM_GROUP_CALL_SUM — Referenced for group-level call summary data within the BIX data mart.
• JTF_RS_GROUPS_DENORM — Denormalized resource group information used to resolve group attributes.
• JTF_RS_GROUP_MEMBERS and JTF_RS_RESOURCE_EXTNS — Used to locate the agent group and source name associated with the executing user.
• DUAL — Used for single-row lookups of the ICX session id and profile option value.

Usage Notes

This package is invoked indirectly by the BIX dashboard framework and the BIX data mart refresh, typically when a user opens or refreshes the Calls Handled dashboard region. It is not referenced by any other documented package, which confirms its role as a leaf-level bin populator. Implementers should not call POPULATE directly from custom code, since the insertion depends on an active ICX session and on the BIX_DM_DEFAULT_GROUP profile option being correctly configured. Where the profile is unset, the procedure falls back to any group the user belongs to, so groups must be maintained in JTF_RS_GROUP_MEMBERS for meaningful results.