Search Results bis_measure_pub




Overview
Explore in AI Chat

Overview

APPS.BIS_DIMENSION_PUB is a public PL/SQL API package belonging to the Oracle EBS Business Intelligence System (BIS) schema, the foundation of the Enterprise Performance Foundation / ETRM (Enterprise Territory and Resource Management) dimensional model. The package exposes the supported, external-facing interface for creating, maintaining, loading, translating, and retrieving dimension definitions used throughout the analytical and business intelligence framework.

Dimensions represent the business perspectives against which measures are aggregated, such as product, customer, geography, account, or organization. In Oracle EBS 12.1.1 and 12.2.2, BIS_DIMENSION_PUB serves as the controlled entry point so that internal private packages and external callers do not write directly to the underlying repository tables. Its API classification as PUB confirms it is intended for supported invocation, while its companion package BIS_DIMENSION_PVT encapsulates the private implementation. The package is documented with a total of thirteen procedures and functions.

Key Procedures and Functions

The documented routines fall into four functional groups:

Tables Accessed

The package reads and writes the following documented objects via APPS synonyms:

  • BIS_DIMENSIONS — the base table holding dimension definitions, the primary target of create, update, delete, and load operations.
  • BIS_DIMENSIONS_TL — the translation table storing language-specific dimension names and descriptions, populated by the TRANSLATE routines.
  • BSC_SYS_DIM_LEVELS_B — the system dimension level base table, consulted when validating or resolving dimension level relationships during load and retrieval.
  • PLITBLM — the standard PL/SQL index-by table used for bulk binding and set-based processing, particularly for group loads.

Usage Notes

BIS_DIMENSION_PUB is not typically invoked directly by end users. It is called by forms, concurrent programs, and migration utilities within the BIS/BSC framework. The dependency metadata confirms that BIS_MEASURE_PUB, BIS_MEASURE_PVT, BIS_DIMENSION_LEVEL_PUB, BIS_DIMENSION_LEVEL_PVT, BIS_DIMENSION_VALIDATE_PVT, BIS_COMPUTED_ACTUAL_PVT, BSC_BIS_DIMENSION_PUB, BSC_BIS_DIM_GROUP_PUB, BSC_MIGRATION, and BSC_UPGRADES all reference it. The link to BIS_MEASURE_PUB is significant: measure definitions are always associated with a dimension, so any measure creation or update path invokes the dimension API first to validate that the target dimension exists and is not obsolete.

The package itself depends on BSC_DIMENSION_GROUPS_PUB, BIS_UTILITIES_PUB, and FND_API, the latter providing the standard Oracle Application Object Library error-handling and message conventions. The presence of wrapper procedures indicates that group loads and translations are performed in a controlled sequence to preserve transactional consistency. Because BSC_MIGRATION and BSC_UPGRADES reference this package, it is also exercised during patching and release upgrades, making it a critical dependency when diagnosing dimension-related errors after an upgrade to 12.2.2. Custom code should call only the PUB procedures, never the PVT implementation, to remain upgrade-safe.