Search Results bis_bia_dim_map_util

Overview

BIS_BIA_DIM_MAP_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite. The package resides in the Business Intelligence System (BIS) product family, which underpins the Oracle Daily Business Intelligence and related analytical reporting infrastructure. Its designation as an API classification of "UTIL" indicates that it provides low-level helper routines rather than a complete business transaction API. The specific responsibility of this package is to maintain the association between geographic areas and countries within the territory hierarchy used by the dimensional model that supports Business Intelligence reporting. In practical terms, the package allows callers to register or remove the mapping that links an area code to a country code so that territory-based dimensions can be resolved consistently across BI dashboards and analytical views.

Key Procedures and Functions

The documented package specification exposes two procedures. No additional functions are declared in the published interface; the earlier GET_COUNTRIES_BY_AREA function was commented out of the specification and is explicitly noted as unused by both the user interface and backend, and its SQL was flagged in the SQL Performance Repository. As such it should not be treated as part of the supported interface.

• ADD_AREA_COUNTRY_ASSOCIATION — Accepts an area code and a country code and establishes the association between them within the BI dimension mapping. It is the routine used to insert or register a new area-to-country relationship.
• DEL_AREA_COUNTRY_ASSO — Accepts an area code and removes the existing area-to-country association for that area. It is the counterpart routine used to clean up or retire a mapping.

Both procedures are declared without documented parameter lists beyond the two VARCHAR2 arguments implied by their names; parameter details should be confirmed against the deployed source before custom integration. The procedures encapsulate the insert and delete logic against the territory hierarchy, keeping direct DML out of calling code.

Tables Accessed

The package operates against BIS_TERRITORY_HIERARCHIES, accessed through an APPS synonym. This table stores the hierarchy definitions that describe how territories, areas, and countries relate to one another for BI dimensional purposes. The add and delete procedures respectively create and remove rows representing the area-to-country linkage in that hierarchy. Because the table is central to territory dimension resolution, any change made through this package directly affects how geographic dimensions are rolled up in BI reports.

Usage Notes

BIS_BIA_DIM_MAP_UTIL is a supporting utility rather than a top-level user-facing API. It is typically invoked from setup or configuration code that manages BI territory dimensions, and it may be called by concurrent programs or forms that administer area and country mappings. The ETRM metadata records that no other packages reference it, which suggests it is called directly by application logic or custom extensions rather than being nested inside another documented API. Because changes to the territory hierarchy affect reporting dimensions, invocations should be performed during controlled setup windows. Custom code should call the documented procedures rather than issuing direct DML against BIS_TERRITORY_HIERARCHIES, and the deprecated GET_COUNTRIES_BY_AREA function should not be relied upon in new development. Version 12.1.1 and 12.2.2 share the same package specification, so integration code remains portable across both releases.