Search Results get_formula_base_columns

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.