Search Results import_pmf_dim_level

Overview

APPS.BSC_PMF_UI_API_PUB is a public PL/SQL API package within the Oracle E-Business Suite Balanced Scorecard (BSC) and Performance Management Framework (PMF) product family. Its principal role is to provide a programmatic interface for creating, updating, and managing balanced scorecard analytical objects that are normally surfaced through the BSC user interface. These objects include KPI measures, dimensions, dimension levels, dimension sets, datasets, and analysis options. In releases 12.1.1 and 12.2.2, the package serves as the backend logic layer supporting the Performance Management Framework configuration screens, allowing both standard application forms and custom integrations to persist BSC metadata into the underlying repository tables.

Because the API is classified as PUB, it is intended for supported external invocation. The header timestamp (120.0, 2005/06/01) reflects its long-standing stability, and the presence of language-aware record types (Language, Source_Language) indicates that it honors the multilingual architecture of the EBS database.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. The core coordination routine is BSC_PMF_UI_API, which accepts a UI record and a dimension table along with a dimension count, and returns status, message count, message data, and a bad-level indicator. The record and table types (Bsc_Pmf_Ui_Rec_Type, Bsc_Pmf_Dim_Rec_Type, and their table counterparts) define the payload structure for KPI, measure, dimension, and dimension-level definitions.

• CREATE_BSC_DIMENSION_SET — the routine matched by the user's search; it creates a dimension set entity that groups dimension levels for use in KPI analysis and dataset definitions.
• CREATE_BSC_DIMENSION — creates an individual dimension definition, including short/long name and level display attributes.
• CREATE_BSC_DATASET and UPDATE_BSC_DATASET — manage system dataset records used to describe analytical data sources.
• CREATE_BSC_ANALYSIS_OPTION — registers a selectable analysis option for KPI measures.
• GET_MEASURE_LONG_NAME, GET_DIMENSION_LONG_NAME, and GET_DIMENSION_LEVEL_NAME — retrieval functions that resolve user-facing names, typically with language handling.
• GET_DIM_LEVEL_VIEW_NAME and GET_DIMLEVEL_VIEWBY — return the view name and the "view by" applicability attributes for a dimension level.
• IMPORT_PMF_DIM_LEVEL — imports dimension-level metadata into the BSC repository.
• POPULATE_BSC_PMF_DIM_REC — constructs or populates a dimension record structure for downstream processing.
• MODIFY_PASSED_PARAMETERS — normalizes or adjusts incoming parameters before persistence.

Tables Accessed

The package reads and writes several BSC repository tables via APPS synonyms. KPI and measure definitions are stored in BIS_INDICATORS and BIS_INDICATORS_TL, with analysis measures and options in BSC_KPI_ANALYSIS_MEASURES_B and BSC_KPI_ANALYSIS_OPTIONS_B. Dimension set translations reside in BSC_KPI_DIM_SETS_TL. System-level metadata is held in BSC_SYS_DATASETS_B, BSC_SYS_DIM_LEVELS_B, and BSC_SYS_MEASURES. Multilingual support relies on FND_LANGUAGES, while AK_REGIONS and AK_REGION_ITEMS provide Oracle Forms/Web UI region metadata. PLITBLM and USER_OBJECTS are used for PL/SQL table buffering and object existence checks respectively.

Usage Notes

BSC_PMF_UI_API_PUB is typically invoked from the Balanced Scorecard setup forms within the EBS application, from concurrent programs that bulk-load BSC metadata, and from custom PL/SQL integrations that automate dimension set or dataset creation. It is referenced by five other packages, indicating it is a dependency in the BSC configuration chain. Callers should pass a valid UI record structure, honor FND_API return status conventions, and check x_return_status and x_msg_data after execution. Direct DML against the underlying tables should be avoided in favor of this API to preserve translation and referential integrity.