Search Results bsc_simulation_view_pub

Overview

APPS.BSC_SIMULATION_VIEW_PUB is a public PL/SQL package in the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Oracle Performance Management and Daily Business Intelligence stack. In EBS 12.1.1 and 12.2.2 it provides the application programming interface for creating, modifying, duplicating, and deleting simulation views used within the Balanced Scorecard authoring environment. A simulation view allows scorecard designers to model KPIs, measures, and scorecard tree nodes in a sandbox before promoting the configuration to a live scorecard. The package is classified as a PUB interface, meaning it forms the supported entry point for external callers, and it is documented with fifteen procedures and functions covering the full lifecycle of simulation-view metadata.

Key Procedures and Functions

The package exposes the following documented subprograms:

ADD_OR_UPDATE_SIM_TREE_BG — creates or updates simulation tree nodes in the background, allowing bulk tree maintenance without blocking the UI.
ADD_OR_UPDATE_SIM_NODE_PROPS — maintains the property set attached to an individual simulation tree node.
ADD_OR_UPDATE_MEASURE — inserts or modifies a measure definition within the simulation context.
ADD_OR_UPDATE_YTD — manages year-to-date measure configuration for a simulation KPI.
GET_OBJECTIVE_DETAILS — returns descriptive information for a scorecard objective.
SET_DEFAULT_NODE — designates the default node used when a simulation view is opened.
SET_SIM_KEY_VALUES — populates the key values that identify a simulation node.
REMOVE_SIMULATION_VIEW_ITEMS — deletes items from an existing simulation view.
DUPLICATE_KPI_METADATA — copies KPI metadata so a simulation can reuse an existing KPI definition.
COPY_SIM_METADATA — replicates an entire simulation metadata set, typically for versioning or template creation.
SAVE_COLOR_RANGES — persists color-range thresholds used for conditional KPI formatting.
VALIDATE_NAME_IN_TAB — checks name uniqueness and validity against the target table.
GET_KPI_MEASURE_ID, GET_KPI_MEASURECOL, and GET_FORMULA_BASE_COLUMNS — lookup functions returning a KPI's measure identifier, its measure column mapping, and the base columns available for formula construction.

Tables Accessed

The package reads and writes through APPS synonyms. Core KPI tables include BSC_KPIS_B and BSC_KPIS_TL for the base and translated KPI records, BSC_KPI_PROPERTIES, BSC_KPI_TREE_NODES_B, BSC_KPI_ANALYSIS_MEASURES_B, and BSC_SYS_MEASURES for measure definitions. Simulation-specific structures include BSC_SYS_DATASETS_B, BSC_COLOR_RANGES, and BSC_COLOR_TYPE_PROPS, which govern datasets and conditional color formatting. Region and presentation metadata is drawn from AK_REGIONS, AK_REGION_ITEMS_VL, and BIS_AK_REGION_EXTENSION. Image and indicator references are resolved through BSC_SYS_IMAGES, BSC_SYS_IMAGES_MAP_TL, BSC_SYS_IMAGE_ID_S, and BIS_INDICATORS.

Usage Notes

BSC_SIMULATION_VIEW_PUB is invoked primarily from the Balanced Scorecard administration and authoring forms, and from its own private counterpart BSC_SIMULATION_VIEW_PVT. It is referenced by BSC_COLOR_CALC_UTIL, BSC_KPI_PUB, BSC_KPI_PVT, BSC_UPDATE_UTIL, and BSC_SIMULATION_VIEW_PVT, indicating that it sits in the middle of the BSC metadata layer. Custom integrations should call the PUB procedures rather than manipulating the underlying tables directly, ensuring that validation, background tree processing, and dependent color and measure logic remain consistent in both EBS 12.1.1 and 12.2.2.

PACKAGE: APPS.BSC_SIMULATION_VIEW_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_SIMULATION_VIEW_PUB, status:VALID,
SYNONYM: APPS.BSC_SYS_DATASETS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_SYS_DATASETS_B, status:VALID,
PACKAGE BODY: APPS.BSC_SIMULATION_VIEW_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SIMULATION_VIEW_PUB, status:VALID,
PACKAGE: APPS.BSC_TAB_VIEW_LABELS_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_TAB_VIEW_LABELS_PKG, status:VALID,
PACKAGE: APPS.BSC_SYS_IMAGES_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_SYS_IMAGES_PKG, status:VALID,
SYNONYM: APPS.BSC_SYS_MEASURES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_SYS_MEASURES, status:VALID,
PACKAGE: APPS.BSC_KPI_TREE_NODES_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_KPI_TREE_NODES_PKG, status:VALID,
SYNONYM: APPS.BSC_COLOR_RANGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_COLOR_RANGES, status:VALID,
SYNONYM: APPS.BSC_COLOR_TYPE_PROPS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_COLOR_TYPE_PROPS, status:VALID,
PACKAGE: APPS.BSC_SIMULATION_VIEW_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_SIMULATION_VIEW_PVT, status:VALID,
SYNONYM: APPS.BSC_SYS_IMAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_SYS_IMAGES, status:VALID,
PACKAGE: APPS.BSC_KPI_COLOR_PROPERTIES_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_KPI_COLOR_PROPERTIES_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_COLOR_CALC_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_COLOR_CALC_UTIL, status:VALID,
PACKAGE: APPS.BSC_COLOR_RANGES_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_COLOR_RANGES_PUB, status:VALID,
SYNONYM: APPS.BSC_KPIS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_KPIS_B, status:VALID,
SYNONYM: APPS.AK_REGIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AK_REGIONS, status:VALID,
SYNONYM: APPS.BIS_AK_REGION_EXTENSION 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BIS_AK_REGION_EXTENSION, status:VALID,
PACKAGE: APPS.BSC_SYS_IMAGES_MAP_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_SYS_IMAGES_MAP_PKG, status:VALID,
SYNONYM: APPS.BSC_SYS_IMAGE_ID_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_SYS_IMAGE_ID_S, status:VALID,
SYNONYM: APPS.BSC_KPI_TREE_NODES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_KPI_TREE_NODES_B, status:VALID,
SYNONYM: APPS.BSC_TAB_INDICATORS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_TAB_INDICATORS, status:VALID,
SYNONYM: APPS.BSC_SYS_IMAGES_MAP_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_SYS_IMAGES_MAP_TL, status:VALID,
PACKAGE: APPS.BSC_CUSTOM_VIEW_UI_WRAPPER 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_CUSTOM_VIEW_UI_WRAPPER, status:VALID,
PACKAGE: APPS.BSC_BIS_LOCKS_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_BIS_LOCKS_PUB, status:VALID,
SYNONYM: APPS.BSC_KPIS_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_KPIS_TL, status:VALID,
PACKAGE BODY: APPS.BSC_SIMULATION_VIEW_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SIMULATION_VIEW_PVT, status:VALID,
PACKAGE: APPS.BSC_BIS_KPI_CRUD_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_BIS_KPI_CRUD_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_KPI_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_KPI_PUB, status:VALID,
PACKAGE: APPS.BSC_DESIGNER_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_DESIGNER_PVT, status:VALID,
PACKAGE: APPS.BSC_ANALYSIS_OPTION_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_ANALYSIS_OPTION_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_UTIL, status:VALID,
SYNONYM: APPS.BSC_KPI_PROPERTIES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_KPI_PROPERTIES, status:VALID,
12.1.1 DBA Data 12.1.1
VIEW: APPS.BSC_KPI_TREE_NODES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BSC.BSC_KPI_TREE_NODES_VL, object_name:BSC_KPI_TREE_NODES_VL, status:VALID,
VIEW: APPS.BSC_SYS_IMAGES_MAP_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BSC.BSC_SYS_IMAGES_MAP_VL, object_name:BSC_SYS_IMAGES_MAP_VL, status:VALID,
SYNONYM: APPS.BSC_KPI_ANALYSIS_MEASURES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_KPI_ANALYSIS_MEASURES_B, status:VALID,
PACKAGE BODY: APPS.BSC_KPI_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_KPI_PVT, status:VALID,
SYNONYM: APPS.BIS_INDICATORS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BIS_INDICATORS, status:VALID,
VIEW: APPS.BSC_TAB_VIEW_LABELS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BSC.BSC_TAB_VIEW_LABELS_VL FND.BSC_TAB_VIEW_LABELS_VL, object_name:BSC_TAB_VIEW_LABELS_VL, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.BSC_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_UTILITY, status:VALID,
VIEW: APPS.AK_REGION_ITEMS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AK.AK_REGION_ITEMS_VL, object_name:AK_REGION_ITEMS_VL, status:VALID,
PACKAGE: APPS.BSC_SIMULATION_VIEW_PUB 12.1.1
VIEW: APPS.BSC_KPIS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BSC.BSC_KPIS_VL, object_name:BSC_KPIS_VL, status:VALID,
APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1
APPS.BSC_KPI_PUB dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1
APPS.BSC_UPDATE_UTIL dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1
APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1
APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1
APPS.BSC_KPI_PVT dependencies on BSC_SIMULATION_VIEW_PUB 12.1.1