Search Results analysis_name




Overview
Explore in AI Chat

Overview

The QRM_SAVED_ANALYSES_COL table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the QRM (Risk Management) product module. Its primary function is to store the column header and legend metadata necessary for interpreting the detailed, row-level data held in its companion table, QRM_SAVED_ANALYSES_ROW. This structure allows for the dynamic definition and persistent storage of complex risk analysis outputs. When a user saves an analysis within QRM, the system stores the result's structure in this table, enabling the accurate reconstruction, display, and reporting of the saved analysis at a later time. It acts as a critical component for the saved analysis feature, ensuring data integrity and presentation consistency.

Key Information Stored

The table's structure is defined to uniquely identify and describe each column of a saved analysis. As per the provided metadata, the primary key is a composite of ANALYSIS_NAME and SEQ_NO. The ANALYSIS_NAME column serves as the unique identifier linking all metadata and data rows belonging to a specific saved analysis report. The SEQ_NO (Sequence Number) column defines the ordinal position of each column within the analysis output. While the specific descriptive columns (e.g., column header labels, data types, formatting rules) are not enumerated in the brief excerpt, the table's stated purpose implies it stores information such as column titles, display formats, and potentially data type indicators or legend keys that explain the values present in the corresponding QRM_SAVED_ANALYSES_ROW table.

Common Use Cases and Queries

The primary use case is the retrieval and rendering of a user's previously executed and saved risk analysis. When a user requests to view a saved analysis, the application queries this table to understand the report's schema before fetching the corresponding row data. A typical query pattern would involve filtering by ANALYSIS_NAME and ordering by SEQ_NO to reconstruct the correct column order. For example, a query to fetch the column layout for a specific analysis would be: SELECT * FROM QRM.QRM_SAVED_ANALYSES_COL WHERE ANALYSIS_NAME = '<analysis_name>' ORDER BY SEQ_NO;. Database administrators or support personnel might also query this table to diagnose issues with saved reports or to understand the metadata of analyses within the system, often joining to the related row table for a complete picture.

Related Objects

The QRM_SAVED_ANALYSES_COL table has a direct and integral relationship with the QRM_SAVED_ANALYSES_ROW table, as indicated in its description. The primary key (ANALYSIS_NAME, SEQ_NO) in the COL table defines the structure that the ROW table's data conforms to. The most significant documented relationship is its primary key constraint, QRM_SAVED_ANALYSES_COL_PK. While not explicitly listed, it is highly probable that the QRM_SAVED_ANALYSES_ROW table contains a foreign key constraint referencing this primary key, or at a minimum, uses the ANALYSIS_NAME as a foreign key to link row data to the correct column definition set. The table is central to the saved analysis functionality and is likely referenced by QRM application forms and reporting interfaces.