Search Results qrm_filters




Overview
Explore in AI Chat

Overview

The QRM_FILTERS table is a core data object within the Oracle E-Business Suite (EBS) Risk Management (QRM) module. Functioning as the Filters Header table, it serves as the master repository for defining and storing named filter criteria sets. These filters are essential components used to segment and select specific data subsets for risk analysis, reporting, and simulation within the QRM application. The table's primary role is to provide a centralized definition that can be referenced and applied across various risk management processes, ensuring consistency and reusability of complex data selection logic.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the table's description and relationships indicate its critical data elements. The central column is FILTER_NAME, which serves as the unique identifier (Primary Key) for each filter definition. This name is user-defined and used to reference the filter throughout the QRM application. The table likely stores additional header-level attributes for each filter, which may include creation date, last update date, description, owner, and an indicator of the filter's type or scope. The detailed conditions that constitute the filter's logic are not stored in this header table but are defined in the related child table, QRM_FILTER_CONDITIONS.

Common Use Cases and Queries

This table is central to configuring and executing risk analyses. A primary use case is the setup of an Analysis Profile in QRM_ANALYSIS_SETTINGS, where a predefined filter from QRM_FILTERS is assigned to constrain the scope of a risk calculation, such as limiting a Value at Risk (VaR) simulation to a specific portfolio or instrument type. Administrators may query this table to audit or document existing filter definitions. Common SQL patterns include listing all available filters or identifying filters used in specific analyses.

  • Listing all filter definitions: SELECT filter_name FROM qrm.qrm_filters ORDER BY 1;
  • Finding analyses using a specific filter: SELECT a.analysis_name FROM qrm.qrm_analysis_settings a WHERE a.filter_name = '&FILTER_NAME';

Related Objects

The QRM_FILTERS table maintains defined relationships with two other key QRM tables, as documented by the foreign key constraints.

  • QRM_FILTER_CONDITIONS: This is a direct child table linked by FILTER_NAME. It stores the individual criteria (e.g., column, operator, value) that collectively define the logic of the filter header record in QRM_FILTERS.
  • QRM_ANALYSIS_SETTINGS: This table references QRM_FILTERS via the foreign key column QRM_ANALYSIS_SETTINGS.FILTER_NAME. It allows a named filter to be applied to a specific risk analysis configuration, determining the data subset for that analysis run.