Search Results bsc_bis_dim_group_pub

Overview

BSC_BIS_DIM_GROUP_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Balanced Scorecard (BSC) product family, which relies on the BIS (Business Intelligence System) schema objects to support performance management, scorecarding, and analytical reporting. The "PUB" suffix denotes that the package is an API classified as public, meaning its procedures are intended to be called from outside the package by forms, concurrent programs, or custom code rather than being restricted to internal package logic.

The package is documented as VALID under ETRM for both 12.1.1 and 12.2.2 releases. Its principal role is to manage the association between scorecard dimensions and the dimension groups or hierarchies to which they belong, thereby governing how dimension members are organized within the Balanced Scorecard data model. It relies on the FND_API standard error-handling and messaging framework, consistent with Oracle's recommended API design pattern.

Key Procedures and Functions

ETRM documents a single public procedure for this package:

• UPDATE_DIMENSION — The only documented entry point. Its purpose is to update the definition or grouping attributes of a dimension within the BIS dimension metadata. As a public API routine, it would typically accept a dimension identifier together with the revised attributes and return standard API status and message outputs through the FND_API convention. The procedure encapsulates the validation and persistence logic required to keep the BIS_DIMENSIONS record synchronized with the requested change.

No other procedures or functions are documented in the available metadata. The parameter list is not published in the ETRM excerpt and should be verified against the actual package specification in the target environment before use.

Tables Accessed

The package accesses the following tables through APPS synonyms:

• BIS_DIMENSIONS — The primary metadata table holding dimension definitions used by the BIS and Balanced Scorecard layers. UPDATE_DIMENSION reads and writes this table to persist changes to dimension records.
• PLITBLM — A PL/SQL index-by table type defined in the Oracle Applications standards, used internally for bulk processing and array handling rather than as a physical application table. It supports the package's procedural logic when manipulating sets of dimension rows.

These references indicate that the package operates primarily on dimension metadata rather than transactional or fact data.

Usage Notes

BSC_BIS_DIM_GROUP_PUB is invoked when dimension groupings within the Balanced Scorecard framework require modification. Typical callers include the Oracle Balanced Scorecard administrative setup forms, concurrent programs performing dimension maintenance, and custom PL/SQL routines developed by implementers extending scorecard functionality. Because it is a PUB-classified API and depends on FND_API, callers should expect standard status and message handling and should check the returned API status before committing.

The metadata records that the package is referenced by no other documented packages, meaning it is a leaf-level API in the dependency graph and is not called internally by other EBS packages. Developers modifying or extending scorecard dimension behavior should therefore treat it as a controlled integration point and preserve its public signature. All modifications should be validated in a non-production environment, as BIS_DIMENSIONS underpins scorecard configuration and reporting integrity.