Search Results drop_filter_by_tab




Overview
Explore in AI Chat

Overview

APPS.BSC_DIM_FILTERS_PUB is the public PL/SQL package body responsible for managing dimension-level filters within Oracle E-Business Suite's Balanced Scorecard module. Its stated module purpose is to "handle Common Dimension Level for Scorecards," and the header commentary confirms a migration effort (E#5678943, December 2006) that moved common dimensions and dimension filters into the Scorecard Designer. In practice, the package maintains the relationship between scorecard tabs, Key Performance Indicators (KPIs), and the dimension filter views that constrain the data displayed to end users. It provides the application programming interface through which the Scorecard Designer and related scorecard maintenance forms detect filters that no longer apply, drop obsolete filters, and synchronize filters with KPI dimension assignments. The package is owned by APPS and classified as a PUB API, indicating it is intended for supported invocation from other EBS modules, forms, and custom extensions rather than being an internal-only implementation unit.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

  • CHECK_FILTERS_NOT_APPLY — Evaluates filters that no longer apply to a given tab. The source excerpt documents its core behavior: when a dimension level identifier is null and a tab identifier is provided, it checks all dimension objects associated with that specific tab. It returns a status, an error message count, and message data.
  • CHECK_FILTERS_NOT_APPLY_BY_KPI — Performs the equivalent orphaned-filter validation scoped to a specific KPI rather than a tab.
  • DROP_FILTER — Removes a dimension filter definition from the scorecard metadata.
  • SYNCH_FITERS_AND_KPI_DIM — Synchronizes filter records against KPI dimension level assignments, reconciling filters when KPI dimension configuration changes.
  • DROP_FILTER_BY_DIM_OBJ — Drops filters associated with a specific dimension object.
  • DROP_FILTER_BY_TAB — Drops all filters associated with a specified tab; this is the procedure users most commonly reference when searching for "drop_filter_by_tab," and it is typically invoked when a tab is removed or reconfigured in Scorecard Designer.
  • GET_FILTER_VIEW_NAME — Returns the view name for a filter, added under Bug #3426566 (April 2004).

Tables Accessed

The package operates against several BSC base and intersection tables via APPS synonyms:

  • BSC_SYS_FILTERS_VIEWS — Stores filter-to-view definitions, including Source_Code and Source_Type. The CHECK_FILTERS_NOT_APPLY cursor reads this table, filtering on Source_Type equal to SOURCE_TYPE_TAB, to enumerate tabs possessing filter views.
  • BSC_SYS_DIM_LEVELS_B — Base dimension level definitions used to validate dimension levels participating in filters.
  • BSC_KPI_DIM_LEVELS_B — Maps KPI dimension levels, essential to the synchronization and KPI-scoped check routines.
  • BSC_KPIS_B — Base KPI definitions referenced when validating KPI filter applicability.
  • BSC_TAB_INDICATORS — Associates tabs with indicators, supporting the tab-scoped checks and drops.

Usage Notes

BSC_DIM_FILTERS_PUB is invoked primarily from the Scorecard Designer and scorecard administration forms, and from concurrent or batch maintenance routines that clean up orphaned filters following tab, KPI, or dimension configuration changes. The package uses a SAVEPOINT (CheckFiltersNotApply) for transactional control and returns standard EBS API outputs — x_return_status, x_msg_count, and x_msg_data — allowing callers to detect and handle errors consistently. Because it is designated a PUB API and is referenced by several other packages, custom code should call the documented procedures rather than manipulating the underlying BSC tables directly, ensuring that filter views, KPI dimension mappings, and tab indicators remain synchronized. The GET_FILTER_VIEW_NAME function is the supported mechanism for resolving a filter to its underlying database view name.