Search Results rg_xbrl_map_elements




Overview
Explore in AI Chat

Overview

The RG_XBRL_MAP_ELEMENTS table is a core data object within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a critical junction table that establishes and manages the mapping relationships between individual XBRL taxonomy elements and the specific taxonomies they belong to. This mapping is fundamental to the system's ability to generate financial and regulatory reports in the eXtensible Business Reporting Language (XBRL) format, ensuring that reported data points are correctly aligned with the standardized definitions and structures mandated by regulatory bodies.

Key Information Stored

The table's structure is designed to enforce and record the many-to-many relationship between taxonomies and elements. Its primary purpose is to define which elements are available for use within a given taxonomy. The key columns are its composite primary key, consisting of TAXONOMY_ID and ELEMENT_ID. The TAXONOMY_ID column stores a foreign key reference to a specific taxonomy definition in the RG_XBRL_TAXONOMIES table. The ELEMENT_ID column stores a foreign key reference to a defined XBRL element in the RG_XBRL_ELEMENTS table. Each row represents a single, valid association, indicating that a particular element is a constituent part of a specific taxonomy.

Common Use Cases and Queries

This table is primarily accessed during the configuration and generation of XBRL reports. Common operational scenarios include validating the available elements for a reporting context, troubleshooting mapping issues, and auditing taxonomy usage. A typical query would join this table to its related master tables to list all elements for a given taxonomy.

  • Listing Elements for a Taxonomy: SELECT e.element_name, e.element_label FROM rg_xbrl_map_elements m, rg_xbrl_elements e WHERE m.element_id = e.element_id AND m.taxonomy_id = :p_tax_id;
  • Verifying an Element-Taxonomy Mapping: SELECT COUNT(*) FROM rg_xbrl_map_elements WHERE taxonomy_id = :p_tax_id AND element_id = :p_ele_id;
  • Reporting on Taxonomy Composition: Queries against this table support internal audits to understand which regulatory taxonomies have been implemented and what financial concepts they encompass.

Related Objects

The RG_XBRL_MAP_ELEMENTS table sits at the intersection of two key master tables, as defined by its foreign key constraints.

  • RG_XBRL_TAXONOMIES: This table is referenced via the foreign key on the TAXONOMY_ID column. It contains the master definition of an XBRL taxonomy, such as its name, version, and regulatory purpose.
  • RG_XBRL_ELEMENTS: This table is referenced via the foreign key on the ELEMENT_ID column. It stores the detailed definition of individual XBRL reporting concepts, including names, data types, and labels.

These relationships ensure referential integrity, guaranteeing that every mapping points to a valid taxonomy and a valid element. The table's primary key constraint, RG_XBRL_MAP_ELEMENTS_PK, enforces uniqueness on the combination of TAXONOMY_ID and ELEMENT_ID, preventing duplicate mappings.