Search Results qrm_ana_atts_lookups_pk

Overview

The QRM_ANA_ATTS_LOOKUPS table is a core reference table within the Oracle E-Business Suite (EBS) Risk Management (QRM) module, present in both versions 12.1.1 and 12.2.2. It functions as a master repository for defining and controlling the behavior of deal attributes specifically within the context of Risk Analysis. This table stores the fundamental properties and metadata for attributes that can be assigned to financial deals, enabling administrators to configure how these attributes are presented, validated, and utilized during complex risk calculations, simulations, and reporting. Its role is pivotal in ensuring that risk analysis processes operate on a consistent and well-defined set of deal characteristics.

Key Information Stored

The primary data stored in this table centers on the configuration of individual deal attributes. The most critical column is ATTRIBUTE_NAME, which serves as the unique identifier (Primary Key) for each configurable attribute. While the full column list is not detailed in the provided metadata, based on its described purpose, the table typically stores properties such as the attribute's data type (e.g., VARCHAR2, NUMBER, DATE), display label, default value, and flags to control behavior—for instance, whether the attribute is mandatory for analysis, if it should be included in specific risk models, or if it has a predefined list of valid values. These properties directly instruct the QRM application on how to handle each attribute during deal setup and risk engine processing.

Common Use Cases and Queries

The primary use case for this table is the administrative setup and maintenance of the risk analysis framework. A system administrator would query this table to review or modify the list of available analysis attributes. Common SQL operations include auditing the current attribute configuration or joining with transactional data to understand attribute usage. For example, a basic query to list all configured analysis attributes would be: SELECT attribute_name FROM qrm.qrm_ana_atts_lookups ORDER BY 1;. In a reporting or diagnostic scenario, one might join this table to the QRM_ANALYSIS_ATTS table to see which attributes are assigned to specific deals: SELECT la.attribute_name, a.deal_id FROM qrm.qrm_ana_atts_lookups la, qrm.qrm_analysis_atts a WHERE la.attribute_name = a.attribute_name;.

Related Objects

The QRM_ANA_ATTS_LOOKUPS table has a direct and essential relationship with the transactional table that stores attribute values for individual deals. As documented in the provided metadata:

• Primary Key: QRM_ANA_ATTS_LOOKUPS_PK on column ATTRIBUTE_NAME.
• Foreign Key Relationship: The table QRM_ANALYSIS_ATTS references QRM_ANA_ATTS_LOOKUPS via its ATTRIBUTE_NAME column. This relationship enforces referential integrity, ensuring that every deal-specific attribute value stored in QRM_ANALYSIS_ATTS is defined in the master lookup table. The join condition is QRM_ANALYSIS_ATTS.ATTRIBUTE_NAME = QRM_ANA_ATTS_LOOKUPS.ATTRIBUTE_NAME.

This structure establishes QRM_ANA_ATTS_LOOKUPS as the authoritative source for attribute definitions, which are then instantiated per deal in the QRM_ANALYSIS_ATTS table.