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:
- QRM_CURRENT_DEALS_V — supplies the current deal-level attributes (aliased V in the view text), including instrument type, counterparty, portfolio, currency amounts, dates, and pricing model.
- QRM_DEAL_CALCULATIONS (synonym) — provides the calculated results (aliased DC), such as FAIR_VALUE, FAIR_VALUE_USD, sensitivities, and revaluation rates.
- XTR_DEAL_TYPES and XTR_DEAL_SUBTYPES (synonyms) — provide the user-defined deal type and subtype descriptions (USER_DEAL_TYPE, USER_DEAL_SUBTYPE).
- FND_GLOBAL (package) — used to resolve session context such as the current SOB or responsibility.
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
- FAIR_VALUE, FAIR_VALUE_USD, FAIR_VALUE_SOB — the mark-to-market valuation of the deal expressed in deal currency, USD, and the reporting set of books currency respectively. FAIR_VALUE_USD is the primary target of the user's search term.
- BASE_CCY_AMOUNT_USD / _SOB, CONTRA_CCY_AMOUNT_USD / _SOB — currency-normalized notional amounts.
- BUY_AMOUNT, SELL_AMOUNT, FOREIGN_AMOUNT, DOMESTIC_AMOUNT — raw deal amounts, alongside USD and SOB equivalents.
- DELTA, GAMMA, VEGA, THETA, RHO, DURATION, MODIFIED_DURATION, CONVEXITY — risk sensitivities per unit or position.
- POS_DELTA, POS_GAMMA, POS_VEGA, POS_RHO, POS_BPV — position-level (aggregated) risk measures.
- FX_REVAL_RATE, MM_REVAL_RATE, FX_TRANS_RATE, MM_TRANS_RATE — revaluation and translation rates applied.
- DEAL_DATE, START_DATE, MATURITY_DATE, EXPIRATION_DATE, VALUE_DATE, GAP_DATE — lifecycle and gap timing fields.
- COMPANY_CODE, DEALER_CODE, CLIENT_CODE, CPARTY_CODE, PORTFOLIO_CODE — organizational and counterparty dimensions.
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.
-
View: QRM_ANALYSIS_DEALS_V 12.2.2
Deals calculated by Risk Analysis
APPS.QRM_ANALYSIS_DEALS_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEAL_CALCULATIONS·Explore QRM module →
-
Calculated deal attributes that do not change over time.
-
Calculated deal attributes that do not change over time.
-
View: QRM_DISC_ANALYSIS_TB_V 12.2.2
Deals information for Risk Management Analyses grouped into Time-bucket period, where user access to company information is enforced.
APPS.QRM_DISC_ANALYSIS_TB_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEALS_ANALYSES·Explore QRM module →
-
View: QRM_DISC_ANALYSIS_V 12.1.1
Deals information for Risk Management Analyses, where user access to company information is enforced.
APPS.QRM_DISC_ANALYSIS_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEALS_ANALYSES·Explore QRM module →
-
View: QRM_DISC_ANALYSIS_TB_V 12.1.1
Deals information for Risk Management Analyses grouped into Time-bucket period, where user access to company information is enforced.
APPS.QRM_DISC_ANALYSIS_TB_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEALS_ANALYSES·Explore QRM module →
-
View: QRM_ANALYSIS_DEALS_V 12.1.1
Deals calculated by Risk Analysis
APPS.QRM_ANALYSIS_DEALS_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEAL_CALCULATIONS·Explore QRM module →
-
View: QRM_ANALYSIS_DISC_V 12.1.1
Deals calculated by Risk Analysis, including date dependent attributes
APPS.QRM_ANALYSIS_DISC_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEAL_CALCULATIONS·Explore QRM module →
-
View: QRM_ANALYSIS_DISC_V 12.2.2
Deals calculated by Risk Analysis, including date dependent attributes
APPS.QRM_ANALYSIS_DISC_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEAL_CALCULATIONS·Explore QRM module →
-
View: QRM_DISC_ANALYSIS_V 12.2.2
Deals information for Risk Management Analyses, where user access to company information is enforced.
APPS.QRM_DISC_ANALYSIS_V·↳ FND_GLOBAL·↳ QRM_CURRENT_DEALS_V·↳ QRM_DEALS_ANALYSES·Explore QRM module →
-
eTRM - QRM Tables and Views 12.1.1
Time Intervals for Time Buckets
-
eTRM - QRM Tables and Views 12.2.2
Time Intervals for Time Buckets