Search Results create_dataset

Overview

APPS.BSC_DATASETS_PUB is a public PL/SQL API package within the Oracle E-Business Suite Balanced Scorecard (BSC) application, part of the Oracle Enterprise Performance Management framework. It provides the programmatic interface through which datasets and their associated measures are created, maintained, and retrieved within the BSC data model. Datasets in Balanced Scorecard represent logical groupings of measures that share a common data source, and this package centralizes the DML and query operations required to manage that metadata safely through a controlled, API-based layer rather than direct table manipulation.

The package carries a status of VALID and is owned by the APPS schema, the standard repository for shared, cross-application APIs in EBS 12.1.1 and 12.2.2. Its API classification as a PUB (public) package indicates that it is intended for invocation by other application code, including forms, concurrent programs, and custom extensions, and that its signature should be treated as a stable contract. The user search term "bsc_bis_measure_pub" points to a closely related package, BSC_BIS_MEASURE_PUB, which is documented as referencing and being referenced by BSC_DATASETS_PUB; the two packages together form the core metadata management layer for BSC measures and datasets.

Key Procedures and Functions

The package exposes 21 documented procedures and functions organized around three functional families: measure operations, dataset operations, and dataset calculation operations. A distinct set of helper and translation routines rounds out the interface.

• Measure operations — CREATE_MEASURES, RETRIEVE_MEASURES, UPDATE_MEASURES, and DELETE_MEASURES manage the definition and lifecycle of measures within a dataset. Measures are the individual metrics that feed scorecards and KPIs.
• Dataset operations — CREATE_DATASET, RETRIEVE_DATASET, UPDATE_DATASET, and DELETE_DATASET manage the dataset header records, including their base and translated attributes.
• Dataset calculation operations — CREATE_DATASET_CALC, RETRIEVE_DATASET_CALC, UPDATE_DATASET_CALC, and DELETE_DATASET_CALC handle calculations associated with a dataset, supporting derived or aggregated measure values.
• Translation routines — TRANSLATE_MEASURE and TRANSLATE_MEASURE_BY_LANG populate and maintain multilingual (TL) text for measure names and descriptions.
• Query helpers — GET_DATASET_NAME, GET_DATASET_SOURCE, and GET_DATASET_FULL_NAME return dataset attributes without performing DML, allowing callers to resolve identifiers and display labels efficiently.

The remaining documented entries complete the internal implementation surface of the package. No parameter lists are reproduced here, as they are defined in the package specification rather than the ETRM metadata.

Tables Accessed

The package operates against the BSC system metadata tables and their translated counterparts, accessed through APPS synonyms:

• BSC_SYS_DATASETS_B — the base table holding dataset definitions; the target of CREATE_DATASET, UPDATE_DATASET, and DELETE_DATASET.
• BSC_SYS_DATASETS_TL — the translated table storing language-specific dataset names and descriptions.
• BSC_SYS_MEASURES — the measure definition table used by the measure-level procedures.
• BSC_DB_MEASURE_GROUPS_TL — translated measure group labels referenced when resolving measure hierarchy.
• BSC_DB_MEASURE_COLS_TL — translated measure column labels used to resolve measure column metadata.

Additional referenced objects include BIS_INDICATORS and FND_NEW_MESSAGES, along with the BIS_MEASURE_PUB and FND_API packages. BIS_MEASURE_PUB provides low-level measure operations, and FND_API supplies the standard EBS API error-handling and message conventions that govern return status and message stacking.

Usage Notes

BSC_DATASETS_PUB is invoked indirectly by the Balanced Scorecard user interface and by higher-level BSC APIs. The dependency chain shows that BSC_BIS_KPI_CRUD_PUB, BSC_BIS_MEASURE_PUB, BSC_CALCULATIONS_PUB, BSC_PMF_UI_API_PUB, BSC_PMF_UI_WRAPPER, BSC_UPGRADES, and the private packages BSC_DATASETS_PVT and BSC_DATASETS_PUB itself all reference it. This confirms its role as a shared building block for KPI configuration, dataset administration, upgrade scripts, and calculation setup.

Because the procedures follow FND_API conventions, callers should check the returned status and inspect the FND message stack after each invocation. The package is well suited for use in concurrent programs that bulk-load dataset and measure metadata, in upgrade routines that migrate BSC configurations, and in custom PL/SQL extensions that provision scorecard content. Direct DML against BSC_SYS_DATASETS_B or BSC_SYS_MEASURES should be avoided, since doing so bypasses the validation, translation handling, and error propagation implemented within this API.