Search Results qrm_saved_analyses_row_u1

Overview

The QRM_SAVED_ANALYSES_ROW table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Risk Management (QRM) module. It functions as the persistent storage for the detailed row-level results of executed analyses managed within the QRM Analysis Manager. The table's primary role is to capture and retain the exact output structure of an analysis run, excluding Table-style analyses, to facilitate quick retrieval and display without requiring complex data transformation. Each saved analysis in the Analysis Manager maintains a single, corresponding dataset within this table, preserving the sequence and formatting of the original results.

Key Information Stored

The table stores the structured output of a risk analysis, with each row representing a line item from the results. Key columns define the analysis context, row properties, and financial data. The composite primary key (ANALYSIS_NAME, SEQ_NO) uniquely identifies each saved row. Critical columns include:

• ANALYSIS_NAME: Identifies the specific saved analysis to which the row belongs.
• SEQ_NO: Maintains the display order of rows in the results table, starting from 1.
• TYPE: A numeric flag critical for interpreting the row's content. Values indicate if the row holds measure data (-1) or aggregated totals at levels 1 through 16. This links directly to aggregation settings defined in related setup tables.
• HIDDEN: A flag ('Y' or 'N') controlling the row's visibility in the presentation layer.
• TOT_CURRENCY and TOT_CURRENCY_LABEL: Store the currency code and its descriptive label for rows containing total values, ensuring accurate summation labeling.

The table's design intentionally mirrors the results table format, with additional columns (A1, A2, etc., implied by the metadata context) holding the actual measure and total values.

Common Use Cases and Queries

This table is primarily accessed for audit, reporting, and data reconciliation purposes outside the standard QRM user interface. A common scenario involves extracting the full saved results for a specific analysis for archival or custom reporting. The following sample query retrieves all visible rows for an analysis named 'FX_Risk_2023', ordered as they would appear in the Analysis Manager:

SELECT ANALYSIS_NAME, SEQ_NO, TYPE, HIDDEN, TOT_CURRENCY, TOT_CURRENCY_LABEL, A1, A2 -- (example data columns)
FROM QRM.QRM_SAVED_ANALYSES_ROW
WHERE ANALYSIS_NAME = 'FX_Risk_2023'
  AND HIDDEN = 'N'
ORDER BY SEQ_NO;

Another frequent use case is identifying all analyses that have saved data for a particular currency, which can be useful for currency-specific exposure reporting:

SELECT DISTINCT ANALYSIS_NAME
FROM QRM.QRM_SAVED_ANALYSES_ROW
WHERE TOT_CURRENCY = 'USD';

Related Objects

The QRM_SAVED_ANALYSES_ROW table is central to the QRM analysis persistence subsystem. Its primary documented relationship is through its primary key constraint, QRM_SAVED_ANALYSES_ROW_PK. It has a fundamental dependency on the master list of analyses, which is stored in a related table such as QRM_SAVED_ANALYSES (or similarly named), where ANALYSIS_NAME would serve as a foreign key. Furthermore, the interpretation of the TYPE column is derived from the ORDER column in the QRM_ANALYSIS_SETTINGS table, which defines the aggregation hierarchy. The unique index QRM_SAVED_ANALYSES_ROW_U1 on (ANALYSIS_NAME, SEQ_NO) enforces data integrity for the primary key.