Search Results bix_util_pkg




Overview
Explore in AI Chat

Overview

APPS.BIX_UTIL_PKG is a utility package body in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing in the APPS schema with VALID status. Its principal business function is to support the BIX (Business Intelligence) and Interaction Center/Telephony reporting subsystem, particularly the "Agent Summary" and real-time dashboard features that aggregate contact center activity across agents, calls, and Universal Work Queue (UWQ) queues. The package supplies shared helper routines and footer-generation logic used throughout the BIX reporting stack, providing common lookups, session and profile resolution, date and period calculation, and refresh-metadata retrieval. Because it is a utility package rather than a standalone business API, its value lies in centralizing reuse across many dependent modules. The ETRM documentation classifies it under the API classification OTHER, and it is referenced by twelve other database objects, confirming its role as a shared internal dependency rather than an entry-point API.

Key Procedures and Functions

Tables Accessed

  • BIX_DM_AGENT_SUM — the agent-level Data Mart summary table, central to the searched term bix_dm_agent_sum and agent refresh-date logic.
  • BIX_DM_AGENT_CALL_SUM — aggregated agent-to-call metrics.
  • BIX_DM_CALL_SUM — call-level summary data.
  • BIX_DM_COLLECT_LOG — data collection log, used to determine collection/refresh status.
  • BIX_DM_UWQ_AGENT_SUM — UWQ agent summary data.
  • GL_PERIODS — provides period definitions for GET_CURR_PERIOD and GET_PREV_PERIOD.
  • DUAL — used for scalar lookups and profile/currency evaluation.

Usage Notes

BIX_UTIL_PKG is an internal utility package and is not referenced by any database object per the ETRM record, meaning it is invoked from the applications layer rather than by other stored objects. It is typically called by BIX and Interaction Center reporting forms, JSP/dashboard pages, and concurrent programs that render agent and call summaries or refresh metadata. Dependencies on FND_PROFILE, FND_LOOKUPS, FND_MESSAGE, ICX_SEC, GL_CURRENCY_API, JTFB_DCF, and GL_PERIODS confirm its integration with profile options, lookups, session security, currency conversion, and period logic. Custom code extending BIX dashboards may call its helper and footer functions directly, but modifications should account for the twelve dependent packages that rely on its stability.