Search Results qrm_analysis_atts




Overview
Explore in AI Chat

Overview

The QRM_ANALYSIS_ATTS table is a core data object within the Oracle E-Business Suite (EBS) Risk Management (QRM) module. It functions as a configuration and metadata repository that defines the specific attributes associated with different risk analyses. This table establishes a critical link between a defined analysis type and the individual data points or metrics that are evaluated within that analysis. Its role is to govern what data is collected, processed, and reported for each analytical scenario, forming a foundational layer for the QRM module's risk assessment and modeling capabilities in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique combination for each analysis attribute. The key columns are ATTRIBUTE_NAME, ANALYSIS_NAME, and HISTORY_FLAG. The ATTRIBUTE_NAME identifies the specific data point or metric being tracked. The ANALYSIS_NAME specifies the type of risk analysis to which the attribute belongs. The HISTORY_FLAG is a critical column that determines whether historical data tracking is enabled for the given attribute within its specific analysis context. This flag allows the system to manage time-series data efficiently for attributes where trend analysis is required.

Common Use Cases and Queries

A primary use case is the administrative setup and auditing of risk analysis configurations. System administrators or functional implementers query this table to verify which attributes are active for a given analysis or to identify all analyses that utilize a particular attribute. Common reporting queries include listing all configurable attributes for a specific analysis or checking the historical tracking status of attributes. Sample SQL patterns are:

  • To retrieve all attributes for the 'Market_Risk_Value_at_Risk' analysis: SELECT attribute_name, history_flag FROM qrm.qrm_analysis_atts WHERE analysis_name = 'MARKET_RISK_VALUE_AT_RISK';
  • To find all analyses where a specific 'Interest_Rate_Shock' attribute is used: SELECT analysis_name, history_flag FROM qrm.qrm_analysis_atts WHERE attribute_name = 'INTEREST_RATE_SHOCK';

These queries are essential for troubleshooting, impact analysis during upgrades, and ensuring configuration consistency.

Related Objects

The QRM_ANALYSIS_ATTS table maintains defined referential integrity through foreign key relationships, as documented in the ETRM. It references two key master tables:

  • QRM_ANA_ATTS_LOOKUPS: The ATTRIBUTE_NAME column in QRM_ANALYSIS_ATTS is a foreign key to this lookup table. This relationship ensures that only pre-defined, valid attribute names can be assigned to an analysis.
  • QRM_ANALYSIS_SETTINGS: The ANALYSIS_NAME column in QRM_ANALYSIS_ATTS is a foreign key to this table. This enforces that attributes can only be assigned to analyses that have been properly configured and exist within the QRM_ANALYSIS_SETTINGS master table.

These relationships position QRM_ANALYSIS_ATTS as a central junction table, connecting analysis definitions with their permissible attributes and governing the overall data model for risk analysis configurations.