Search Results bis_common_utils




Overview
Explore in AI Chat

Overview

APPS.BIS_COMMON_UTILS is a PL/SQL package body residing in the APPS schema within Oracle E-Business Suite. Its classification under the ETRM repository is "OTHER," indicating that it functions as a general-purpose utility library rather than a business-facing API tied to a single application module. The BIS prefix associates the package with the Business Intelligence System / Oracle Daily Business Intelligence (DBI) family of components introduced in the EBS 11i and 12.x releases. In that architecture, DBI and related intelligence dashboards rely on a shared set of helper routines for manipulating runtime parameters, resolving configuration values, and normalizing input supplied by concurrent programs, forms, and internal callers.

BIS_COMMON_UTILS serves that supporting role. It exposes reusable logic for parameter handling so that numerous BI-related packages do not each implement their own parsing and substitution mechanisms. In EBS 12.1.1 and 12.2.2 the package remains valid and compiled, and its status of VALID confirms it is a deployed, operational part of the APPS codebase rather than an obsolete stub.

Key Procedures and Functions

The documented metadata for BIS_COMMON_UTILS identifies two public program units:

  • REPLACEPARAMETERVALUE — A procedure whose purpose is to substitute or overwrite a named parameter's current value within a parameter set (typically represented as a delimited string or a name/value collection). It centralizes the logic used to update a single parameter without rebuilding the entire parameter string, which is common when BI programs cascade or override runtime inputs.
  • GETPARAMETERVALUE — A function or procedure that retrieves the value associated with a given parameter name from a parameter set. Callers use it to resolve the effective value of an input, applying the same parsing rules used by REPLACEPARAMETERVALUE so that reads and writes remain consistent.

Together these two units form a minimal but complete read/write interface for parameter management. The documented metadata does not publish parameter lists, and no signature details should be assumed beyond the names and stated purpose of each unit.

Tables Accessed

The ETRM documentation for this object lists no table references through APPS synonyms. Its dependency section is limited to itself (the package specification BIS_COMMON_UTILS) and the SYS.STANDARD package. This confirms that BIS_COMMON_UTILS is a pure utility layer: it performs string and parameter manipulation in PL/SQL memory and does not query or persist data in application tables. Any table access required by its callers occurs in the calling packages, not here.

Usage Notes

The dependency metadata states that BIS_COMMON_UTILS is not referenced by any database object, while a companion note indicates it is referenced by 18 other packages. The most practical reading is that it is invoked from within the body of dependent PL/SQL units rather than being bound to database objects such as views or triggers. Its typical invocation points are therefore:

  • Oracle Forms and OAF pages that need to read or update a runtime parameter value before submitting a BI request.
  • Concurrent program wrappers and internal BI packages that normalize parameter strings before execution.
  • Custom code in the APPS schema that requires a consistent, supported mechanism for parameter get/set behavior instead of ad hoc string parsing.

Because the package is not referenced by database objects, changes to it do not invalidate views or triggers, but they can invalidate the 18 dependent packages; recompilation of dependents should be expected after any modification. The absence of documented table access also means the package is safe to call in read-only or reporting contexts without transactional side effects.