Search Results pos_denom_percent_str




Overview
Explore in AI Chat

Overview

APPS.ISC_DBI_SUTIL_PKG is a shared PL/SQL utility package within the Oracle E-Business Suite, belonging to the Supply Chain Intelligence (ISC) Daily Business Intelligence (DBI) and Process Manufacturing (PMV) subsystem. Its source header identifies it as iscdbisutils.pls, version 120.0, indicating it is an unshipped ("noship") internal package. The package provides reusable helper routines that construct SQL fragments, derive view-by column names, and compute percentage and rate expressions for DBI reporting pages. Rather than duplicating complex CASE logic throughout the codebase, DBI reports call these centralised functions to standardise comparison, aggregation, and windowing behaviour across supply chain dashboards. It is classified as an OTHER API, meaning it is not intended for direct customer invocation but serves as an internal building block for the DBI reporting framework.

Key Procedures and Functions

The package exposes eleven documented routines:

  • PROCESS_PARAMETERS — A generic process-parameter routine that parses a DBI page parameter table and returns derived values such as view-by, comparison type, currency suffix, where clause, materialized view name, and join tables used by the reporting engine.
  • GET_VIEW_BY_COL_NAME — Returns the name of the view-by column for a given dimension name, principally used to assemble the status_sql. This is the specific function associated with the user's search term.
  • GET_VIEW_BY_SELECT_CLAUSE — Returns the SELECT clause fragment for the VIEWBY and VIEWBYID columns.
  • GET_FACT_SELECT_COLUMNS — Builds the fact view-by column string using a join table, for queries that employ windowing.
  • RATE_STR — Generates the SQL string for percentage or ratio change between two specified expressions.
  • POS_DENOM_PERCENT_STR — Produces the percentage-change string when the denominator is positive and greater than zero.
  • CHANGE_STR and CHANGE_RATE_STR — Return change and change-rate expressions for measured values.
  • GET_GLOBAL_WEIGHT_UOM, GET_GLOBAL_VOLUME_UOM, and GET_GLOBAL_DISTANCE_UOM — Retrieve the globally configured unit of measure for weight, volume, and distance respectively, keeping DBI currency or unit displays consistent across reports.

Tables Accessed

The package reads from two documented sources. WSH_GLOBAL_PARAMETERS supplies the global unit-of-measure settings returned by the three UOM functions, ensuring DBI pages present weights, volumes, and distances in the enterprise-standard units. PLITBLM is accessed as a utility lookup, commonly used for generic value retrieval within the DBI utilities layer. No materialized views are modified directly by this package; the join-table and MV structures referenced in the parameter records are handled by the calling reporting code.

Usage Notes

Since ISC_DBI_SUTIL_PKG is an unshipped internal API referenced by fifteen other packages, it is typically invoked indirectly. DBI dashboard pages, which are built on Oracle's BI/PMV reporting framework, call PROCESS_PARAMETERS to resolve page parameters and then use functions such as GET_VIEW_BY_COL_NAME, GET_VIEW_BY_SELECT_CLause, and RATE_STR to assemble dynamic SQL fragments. Customers should not call these routines directly in custom code, because the API is unsupported and subject to change between releases. Custom implementations requiring view-by resolution or rate expressions should replicate the logic in their own supported packages rather than depending on this internal utility.