Results for “qrm_analysis_atts_u1”

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

Overview

QRM.QRM_ANALYSIS_ATTS is a transactional configuration table within the Oracle E-Business Suite Risk Management (QRM) module. It stores the setup data for analyses performed by the ETRM (Enterprise Trading and Risk Management) engine, where each row corresponds to a single deal attribute participating in a given analysis. The table maintains two logical generations of data simultaneously: the saved analysis configuration and the current working configuration. Risk analysis displays results based on the saved definition but performs its calculations against the current definition, allowing users to modify analytical parameters without disturbing the persisted baseline. Each row has a corresponding row in QRM_ANALYSIS_SETTINGS, indexed by ANALYSIS_NAME, which governs the analysis-level settings.

The object resides in the QRM schema with FND Design Data registered as QRM.QRM_ANALYSIS_ATTS, and its status is VALID on both 12.1.1 and 12.2.2. Storage is assigned to the APPS_TS_TX_DATA tablespace with PCT Free 10. From a Data Vault modeling perspective, the mined foreign-key structure suggests this entity behaves as a link table: it connects the attribute lookup domain (QRM_ANA_ATTS_LOOKUPS) to the analysis settings domain (QRM_ANALYSIS_SETTINGS) while carrying descriptive and control attributes of its own.

Key Information Stored

The table contains fourteen documented columns. Its primary key is QRM_ANALYSIS_ATTS_PK, composed of ATTRIBUTE_NAME, ANALYSIS_NAME, and HISTORY_FLAG. A separate unique index, QRM_ANALYSIS_ATTS_U1, is defined on ATTRIBUTE_NAME, ANALYSIS_NAME, HISTORY_FLAG, and ZD_EDITION_NAME; this index is the business-key candidate because it incorporates the editioning column, whereas the primary key does not.

• ATTRIBUTE_NAME (VARCHAR2(20)) — the deal attribute being analyzed; part of both the primary key and the unique index, and a foreign key to QRM_ANA_ATTS_LOOKUPS.
• ANALYSIS_NAME (VARCHAR2(20)) — the parent analysis; part of both keys and a foreign key to QRM_ANALYSIS_SETTINGS.
• HISTORY_FLAG (VARCHAR2) — distinguishes current (C) from saved (S) attribute definitions; the third PK column.
• TYPE (VARCHAR2) — classifies the attribute as Measure (M), List (L), Aggregate (A), Column (C), or Row (R).
• ATT_ORDER (NUMBER) — display or aggregation sequence selected during analysis setup.
• TOTAL_AVERAGE (VARCHAR2) — indicates whether the attribute is averaged (A) or summed (T).
• TOTAL_IND (VARCHAR2) — controls whether totals are shown for aggregable attributes.
• PERCENTAGE (VARCHAR2) — controls whether percentage values are shown for aggregable attributes.
• ZD_EDITION_NAME (VARCHAR2(30)) — the editioning column supporting Online Patching in 12.2.x.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

The principal use case is reconstructing or auditing the analytical layout of risk analyses. Because current and saved rows coexist, a common pattern is to compare the two generations side by side:

• Retrieve the current layout for one analysis:
  SELECT attribute_name, type, att_order FROM qrm.qrm_analysis_atts WHERE analysis_name = :name AND history_flag = 'C' AND zd_edition_name = 'ORA$BASE' ORDER BY att_order;
• Identify attributes that differ between saved and current definitions by joining the table to itself on ATTRIBUTE_NAME and ANALYSIS_NAME where HISTORY_FLAG differs.
• List aggregable attributes configured for totals or percentages: filter on TYPE IN ('M','A') and TOTAL_IND or PERCENTAGE set to 'Y'.
• Order-of-display reporting for a dashboard mirroring the setup screen, ordered by ATT_ORDER.
• Impact analysis before changing an attribute lookup row, using the FK to QRM_ANA_ATTS_LOOKUPS.

Related Objects

• QRM.QRM_ANALYSIS_SETTINGS — joined via ANALYSIS_NAME; holds analysis-level settings for each row in this table.
• QRM.QRM_ANA_ATTS_LOOKUPS — joined via ATTRIBUTE_NAME; provides the valid attribute definitions.
• QRM_ANALYSIS_ATTS_PK — primary key constraint on (ATTRIBUTE_NAME, ANALYSIS_NAME, HISTORY_FLAG).
• QRM_ANALYSIS_ATTS_U1 — unique index on (ATTRIBUTE_NAME, ANALYSIS_NAME, HISTORY_FLAG, ZD_EDITION_NAME), defining the edition-aware business key.
• FND Design Data QRM.QRM_ANALYSIS_ATTS — the registered metadata definition used by the Application Object Library.