Search Results deal_calc_id




Overview
Explore in AI Chat

Overview

The QRM_DEALS_ANALYSES table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the QRM (Risk Management) product module. Its primary function is to establish and maintain the mapping relationships between a defined risk analysis and the individual financial deal calculations that are included within it. This table acts as a junction or association table, enabling a single analysis to aggregate and evaluate multiple deal calculations for comprehensive risk assessment. Its existence is critical for the analytical workflows in QRM, where users model portfolios, perform simulations, and generate risk reports based on curated sets of financial instruments.

Key Information Stored

The table's structure is designed to manage the fundamental link between an analysis and its constituent deals. The metadata confirms two columns as the composite primary key (QRM_DEALS_ANALYSES_PK), which uniquely identifies each mapping record. The ANALYSIS_NAME column identifies the specific risk analysis. The DEAL_CALC_ID column holds the unique identifier for a deal calculation, serving as a foreign key to the QRM_DEAL_CALCULATIONS table. Additional metadata indicates the presence of a COMPANY_CODE column, which is a foreign key to the XTR_PARTY_INFO table, linking the analysis mapping to a specific legal entity or company within the system for proper data partitioning and security.

Common Use Cases and Queries

This table is central to operations involving the setup, execution, and auditing of QRM analyses. A primary use case is retrieving all deal calculations associated with a particular analysis for processing or reporting. For instance, to audit the composition of an analysis named 'Q4_2023_Interest_Rate_Shock', a query would join to the QRM_DEAL_CALCULATIONS table for deal details:

  • SELECT da.analysis_name, dc.* FROM qrm_deals_analyses da, qrm_deal_calculations dc WHERE da.deal_calc_id = dc.deal_calc_id AND da.analysis_name = 'Q4_2023_Interest_Rate_Shock';

Conversely, to find all analyses that include a specific deal calculation, one would query based on the DEAL_CALC_ID. This table is also pivotal during the analysis submission process, where the system reads the mapped DEAL_CALC_ID values to queue the corresponding calculations for simulation engines.

Related Objects

The QRM_DEALS_ANALYSES table has defined dependencies within the QRM and broader EBS schema. As per the provided metadata, its two key foreign key relationships are fundamental:

  • QRM_DEAL_CALCULATIONS: This is the primary related table. The DEAL_CALC_ID column references QRM_DEAL_CALCULATIONS, which stores the detailed parameters and results of individual deal valuation calculations.
  • XTR_PARTY_INFO: The COMPANY_CODE column references this table from the XTR (Treasury) module, ensuring the analysis is scoped to a valid business entity and enabling integration with treasury and accounting data.

The table itself is referenced by QRM's analytical engines and reporting interfaces that execute processes based on the analysis-to-deal mappings it contains.