Search Results bis_dimensions_s

Overview

APPS.BIS_DIMENSION_PVT is the private implementation package body for the Business Intelligence System (BIS) dimension framework within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package encapsulates the core business logic governing the creation, maintenance, validation, translation, and removal of dimension definitions used throughout the ETRM (Enterprise Territory and Resource Management) and BIS analytical schemas. Dimensions in this context represent the logical groupings—such as customer, product, time, and territory hierarchies—that underpin dimensional modeling, OLAP-style aggregation, and reporting structures.

The package is classified as a PVT (private) API, meaning its procedures are not intended to be called directly by external consumers. Instead, they are invoked by the corresponding public API, BIS_DIMENSION_PUB, which acts as the sanctioned entry point. This layering enforces validation, security, and consistent error handling through the FND_API and FND_MSG_PUB foundation utilities. The package body was reported VALID in the APPS schema and is referenced by five dependent objects, confirming its role as a shared internal service within the BIS module.

Key Procedures and Functions

• RETRIEVE_DIMENSIONS — Returns a collection of dimension records, typically for list-of-values or bulk processing scenarios.
• RETRIEVE_DIMENSION — Fetches a single dimension definition by its identifying key.
• CREATE_DIMENSION — Inserts a new dimension definition, including its translated (TL) and secure (_S) shadow records.
• UPDATE_DIMENSION — Modifies an existing dimension definition while preserving referential integrity.
• TRANSLATE_DIMENSION — Populates translated name and description columns for multilingual support.
• VALUE_ID_CONVERSION — Converts internal identifier values between representations, supporting data migration and cross-reference operations.
• VALIDATE_DIMENSION — Performs integrity and business-rule checks before persistence.
• DUPLICATEDIMENSION — Clones an existing dimension together with its level and group associations.
• REMOVEDUPLICATES — Eliminates redundant dimension entries detected by validation.
• DELETE_DIMENSION — Removes a dimension and its dependent rows (TL, _S, and hierarchy links).
• TRANSLATE_DIM_BY_GIVEN_LANG — Re-runs translation logic scoped to a specific language code.
• VALIDATE_PMF_UNIQUE_NAME — Ensures the dimension name is unique within the Process Manufacturing (PMF) namespace.

Twelve procedures are enumerated in the documented metadata, though the package is noted as exposing sixteen total subprograms, indicating additional unpublished helper routines.

Tables Accessed

The package reads and writes BIS_DIMENSIONS (base definitions), BIS_DIMENSIONS_TL (translated attributes), BIS_DIMENSIONS_S (sequence/secure shadow), and the views BIS_DIMENSIONS_VL and BISBV_DIMENSIONS. It consults BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_BY_GROUP to validate hierarchy levels, and FND_LANGUAGES plus FND_GLOBAL for language and session context. DUAL and PLITBLM (the PL/SQL index-by table type) are used for utility operations.

Usage Notes

BIS_DIMENSION_PVT is invoked indirectly through BIS_DIMENSION_PUB by BIS setup forms, concurrent programs that seed or migrate dimensions, and Territory Management configuration flows. It should never be called directly from custom code; developers should use the public API to preserve validation, message-stack handling, and forward compatibility across 12.1.1 and 12.2.2.