Results for “fair_value_sob”

28 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QRM_ANALYSIS_DEALS_V is a reporting view owned by the APPS schema in Oracle EBS Release 12.1.1 and 12.2.2, delivered as part of the QRM (Risk Management) product family within the ETRM (Enterprise Treasury and Risk Management) suite. As its description indicates, the view exposes deals that have been calculated by the Risk Analysis engine. It functions as a denormalized, analysis-ready projection that joins current deal attributes to their corresponding valuation and risk calculation results, allowing downstream reports, dashboards, and integration interfaces to consume both the static deal definition and its computed analytics in a single query.

The view plays a central role in treasury risk reporting because it consolidates market valuation fields (fair value, revaluation amounts) together with sensitivity and position analytics (delta, gamma, vega, duration, convexity, BP V) across multiple currency perspectives — deal currency, functional/SOB currency, and USD reporting currency. This makes it suitable for multi-currency risk aggregation without requiring consumers to reconstruct the calculation joins manually.

Underlying Base Objects

Per documented ETRM 12.2.2 metadata, the view is defined over the following referenced base objects:

The calculation result set is joined to the deal set through DC.DEAL_NO and transaction sequence, ensuring each analysis row reflects the latest computed valuation for the corresponding transaction.

Key Columns

Common Use Cases and Queries

Typical uses include fair value reporting, sensitivity exposure analysis, and multi-currency portfolio roll-ups. A common query retrieves fair value in USD for a portfolio:

  • SELECT DEAL_NO, PORTFOLIO_CODE, BASE_CCY_AMOUNT_USD, FAIR_VALUE_USD, POS_DELTA, GAP_DATE FROM APPS.QRM_ANALYSIS_DEALS_V WHERE COMPANY_CODE = :p_company AND GAP_DATE >= :p_from_date ORDER BY FAIR_VALUE_USD DESC;

Analysts frequently filter on FAIR_VALUE_USD IS NOT NULL to isolate deals with completed calculations, and join to XTR tables for deal-type breakdowns already exposed via USER_DEAL_TYPE / USER_DEAL_SUBTYPE. Because the view is read-only and column-rich, it is preferable to base custom reports directly on it rather than re-implementing the join logic over QRM_CURRENT_DEALS_V and QRM_DEAL_CALCULATIONS.