Search Results load_dimension_group

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:

• Retrieval: RETRIEVE_DIMENSIONS, RETRIEVE_DIMENSION, and RETRIEVE_REQUIRED_DIMENSION return dimension metadata, a single dimension definition, or only those dimensions that are mandatory for a given context.
• Persistence: CREATE_DIMENSION, UPDATE_DIMENSION, DELETE_DIMENSION, and UPDATE_DIMENSION_OBSOLETE_FLAG manage the lifecycle of a dimension record, including the marking of obsolete or retired dimensions.
• Loading: LOAD_DIMENSION, LOAD_DIMENSION_GROUP, and LOAD_DIMENSION_WRAPPER perform bulk load or refresh operations for individual dimensions and for dimension groups, with the wrapper providing a controlled outer interface.
• Translation: TRANSLATE_DIMENSION, TRANSLATE_DIM_BY_GIVEN_LANG, and TRANSLATE_DIMENSION_WRAPPER populate translated dimension descriptions, the latter two supporting a caller-supplied language and a wrapper entry point respectively.

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.