Search Results rg_xbrl_elements




Overview
Explore in AI Chat

Overview

The RG_XBRL_ELEMENTS table is a core repository within Oracle E-Business Suite's Application Report Generator (RG) module. It serves as the master definition table for all eXtensible Business Reporting Language (XBRL) elements that are imported and available for use within the system. An XBRL element represents a specific financial concept or data point (such as "Assets," "Revenue," or "Net Income") defined within an XBRL taxonomy. This table's primary role is to store the metadata for these standardized elements, enabling their mapping to EBS financial data and their subsequent assembly into compliant XBRL instance documents for regulatory filings like SEC 10-K or 10-Q reports.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure and relationships indicate the table holds critical attributes for each XBRL element. The primary key, ELEMENT_ID, uniquely identifies each element record. A crucial foreign key, TAXONOMY_ID, links each element to its source taxonomy in the RG_XBRL_TAXONOMIES table, defining the standard (e.g., US GAAP) and version. Other columns typically found in such a table would include the element's official name, label, data type (monetary, string, decimal), period type (instant or duration), and balance attribute (debit or credit), which are essential for accurate financial reporting.

Common Use Cases and Queries

The primary use case is the configuration and generation of XBRL-tagged financial reports. Administrators and implementers query this table to understand available elements, troubleshoot mapping issues, and validate taxonomy imports. Common SQL patterns include listing all elements for a specific taxonomy or finding elements by name for mapping purposes.

  • To retrieve all elements for a specific taxonomy version: SELECT * FROM rg.rg_xbrl_elements WHERE taxonomy_id = (SELECT taxonomy_id FROM rg.rg_xbrl_taxonomies WHERE taxonomy_name = 'US-GAAP-2022');
  • To find elements related to assets for mapping review: SELECT element_id, name, label FROM rg.rg_xbrl_elements WHERE UPPER(label) LIKE '%ASSET%' ORDER BY name;

Related Objects

The RG_XBRL_ELEMENTS table is central to the XBRL reporting architecture, with defined relationships to several key objects.

  • RG_XBRL_TAXONOMIES: This table is referenced via the foreign key RG_XBRL_ELEMENTS.TAXONOMY_ID. Every element must belong to a defined taxonomy.
  • RG_REPORT_AXES: This table references RG_XBRL_ELEMENTS via RG_REPORT_AXES.ELEMENT_ID. It uses the element definitions to construct the dimensional axes of a report.
  • RG_XBRL_MAP_ELEMENTS: This table references RG_XBRL_ELEMENTS via RG_XBRL_MAP_ELEMENTS.ELEMENT_ID. This is a critical relationship where EBS GL account values or other financial data are mapped to the standardized XBRL elements stored here.