Search Results rg_xbrl_taxonomies




Overview
Explore in AI Chat

Overview

The RG_XBRL_TAXONOMIES table is a core data repository within the Oracle E-Business Suite (EBS) Application Report Generator (RG) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master reference for storing metadata about XBRL (eXtensible Business Reporting Language) taxonomies. An XBRL taxonomy is a formal, machine-readable dictionary of financial reporting concepts, defining the elements, labels, and relationships used in structured financial statements. The table's primary role is to provide a centralized registry of taxonomies that have been loaded into the system, enabling the configuration and generation of XBRL-compliant financial reports. It acts as a parent entity, with its primary key referenced by numerous child tables that store detailed taxonomy components and mapping rules.

Key Information Stored

While the provided metadata does not list specific columns, the structure and relationships indicate the table's critical data elements. The primary key column, TAXONOMY_ID, uniquely identifies each registered taxonomy record. Based on its function, the table likely stores descriptive attributes for each taxonomy, such as a taxonomy name, version identifier, the effective date or period it applies to, the regulatory body or jurisdiction it supports (e.g., US GAAP, IFRS), and status flags indicating whether it is active for reporting. It may also contain technical metadata like the namespace URI of the taxonomy and internal timestamps for creation and last update. This master data is essential for the system to correctly associate report definitions, mapping rules, and individual XBRL elements with their governing taxonomy framework.

Common Use Cases and Queries

The primary use case for this table is administrative: managing and auditing the XBRL taxonomies available within the EBS instance. A system administrator may query it to verify which taxonomies are loaded before configuring a new financial report or during an upgrade to a new taxonomy version. Common SQL operations include listing all active taxonomies or retrieving the identifier for a specific taxonomy to use in joins with related mapping tables. For example, a query to find all taxonomies for a specific reporting standard would filter on a descriptive column. Furthermore, this table is integral to the end-to-end process of generating an XBRL instance document, as the report generation engine references the TAXONOMY_ID to pull the correct set of elements, axis sets, and mappings defined for that taxonomy.

Related Objects

The RG_XBRL_TAXONOMIES table has defined foreign key relationships with several key child tables in the RG module, as documented in the metadata. These relationships are central to the XBRL reporting architecture:

  • RG_XBRL_ELEMENTS: References RG_XBRL_TAXONOMIES via TAXONOMY_ID. This table stores the individual financial concepts (elements) defined within a taxonomy.
  • RG_XBRL_MAP_ELEMENTS: References RG_XBRL_TAXONOMIES via TAXONOMY_ID. This table holds the mappings between application data (e.g., GL account balances) and the XBRL taxonomy elements.
  • RG_REPORT_AXIS_SETS: References RG_XBRL_TAXONOMIES via TAXONOMY_ID. This table defines dimensional contexts (axis sets) used for segment reporting within the taxonomy framework.
These relationships ensure data integrity, linking all taxonomy-specific configurations and mappings back to a single, validated master record.