Search Results get_pertotal_measure




Overview
Explore in AI Chat

Overview

APPS.BIX_PMV_DBI_UTL_PKG is a utility package used by the Oracle EBS Business Intelligence/BIX (Interaction Center Intelligence) product family. It provides shared helper routines that support page rendering, parameter processing, and SQL generation for the PMV (Performance Management Viewer) reporting framework that underpins the BIX dashboards. The package header reveals that it centralizes a large set of constants used to reference dimension names — for example the email account dimension (EMAIL ACCOUNT+EMAIL ACCOUNT), email classification, telephony call center, telephony call classification, DNIS, customer, and agent group dimensions built from ORGANIZATION+JTF_ORG_SUPPORT_GROUP. It also declares period-selection constants that map to Business Intelligence System (BIS) substitution variables such as the current and previous effective start dates, as-of dates, period end dates, and the previous-previous date.

These constants allow report modules to construct consistent, period-aware queries without hard-coding substitution variable syntax. The package is classified as OTHER in the ETRM/API classification schema, indicating it is an internal implementation package rather than a public, supported API. It is referenced by 44 other packages, confirming its role as a foundational utility layer for BIX reporting.

Key Procedures and Functions

The package exposes 17 documented procedures and functions. Their purposes, based on the ETRM metadata, are:

  • PROCESS_PARAMETERS — Accepts a page parameter table (bis_pmv_page_parameter_tbl) and processes incoming report/page parameters.
  • GET_BIND_VARS — Returns bind variable definitions used when executing generated report SQL.
  • GET_ORR_VIEWS — Provides the views required for the object-relational reporting layer.
  • STATUS_SQL_DAYLEVEL — Generates day-level status SQL, the routine directly associated with the searched term status_sql_daylevel. It builds the SQL predicate that resolves status values at a daily granularity, supporting the inlist bitmask constants (g_inlist_xed, g_inlist_xtd, g_inlist_ytd, g_inlist_rlx, g_inlist_bal) used for period in-list generation.
  • GET_DIVIDED_MEASURE — Computes a measure expressed as a ratio or division of underlying values.
  • GET_PERTOTAL_MEASURE — Computes period-to-total measures, typically percentages of a period relative to a total.
  • GET_DEVAVG_MEASURE — Produces deviation-average measures for trend comparison.
  • GET_SIMPLE_MEASURE — Returns straightforward aggregate measures.
  • TREND_SQL — Builds SQL for trend analysis across reporting periods.
  • GET_CONTINUED_MEASURES — Returns measures carried across pages or report segments.
  • GET_EMC_PAGE_PARAMS — Supplies page parameters for the Email Center (EMC) module.
  • PERIOD_START_DATE — Resolves the appropriate period start date.
  • GET_DEFAULT_PARAMS — Returns default page parameters.
  • GET_AI_PAGE_PARAMS — Provides page parameters for Agent Intelligence / Interaction (AI).
  • GET_AI_DEFAULT_PAGE_PARAMS — Returns default AI page parameters.
  • GET_AO_PAGE_PARAMS — Provides page parameters for the Agent/Operations (AO) area.
  • GET_AO_DEFAULT_PAGE_PARAMS — Returns default AO page parameters.

Tables Accessed

The package references three objects through APPS synonyms:

  • FII_TIME_DAY — The time dimension day-level table, used to resolve daily period boundaries and support day-level status SQL.
  • DUAL — Used for constant expressions such as date calculations (for example the least(...) expressions embedded in balance as-of date constants).
  • PLITBLM — A PL/SQL index-by table of bind variables, used to express and pass bind variable sets to the generated SQL.

Usage Notes

BIX_PMV_DBI_UTL_PKG is invoked indirectly by the 44 packages that reference it. It is not intended for direct invocation from Oracle Forms or from customer-written concurrent programs. Reports and dashboards in the BIX/Interaction Center Intelligence suite call these helpers at runtime to process page parameters, assemble bind variables, generate measure and trend SQL, and resolve period and as-of dates. The presence of constants keyed to BIS_CURRENT_EFFECTIVE_START_DATE, BIS_PREVIOUS_EFFECTIVE_START_DATE, BIS_CURRENT_ASOF_DATE, and related substitution variables indicates the package relies on the BIS reporting engine to populate those values before report execution. Customizations should avoid modifying this package, as changes would affect every dependent BIX report module.