Results for “element_identifier”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RG_XBRL_ELEMENTS is a table in the RG (Application Report Generator) schema of Oracle E-Business Suite, holding the definitions of eXtensible Business Reporting Language (XBRL) elements used in financial and regulatory reporting. XBRL elements are the fundamental building blocks of an XBRL taxonomy, each representing a discrete reporting concept such as a line item, a monetary amount, or a textual disclosure that can be tagged within a financial statement or filing.

Within Oracle EBS, this table forms part of the infrastructure that supports the generation of XBRL-tagged instance documents from Oracle General Ledger and related financial data. It acts as a catalog of the elements available within a given taxonomy, allowing the report generator to map Oracle account balances and report structures to the standardized element identifiers required by XBRL specifications.

From a Data Vault modeling perspective, the documented foreign key structure suggests a hub-leaning classification. The table's central identity — ELEMENT_ID — is referenced by dependent child tables, and it holds a foreign key to RG_XBRL_TAXONOMIES, placing it as a core descriptive entity rather than a pure transactional link or a satellite.

Key Information Stored

The table contains 18 documented columns. The most significant are the following:

• ELEMENT_ID — the surrogate primary key, defined by the unique index RG_XBRL_ELEMENTS_PK. This is the technical identifier used internally by Oracle EBS to reference an element.
• TAXONOMY_ID — foreign key to RG_XBRL_TAXONOMIES, identifying the taxonomy to which the element belongs. Together with ELEMENT_IDENTIFIER, it forms the business-key candidate defined by the unique index RG_XBRL_ELEMENTS_U1 and U2.
• ELEMENT_IDENTIFIER — the business name of the element as defined in the taxonomy (for example, the tag name used in the XBRL instance document).
• ELEMENT_NAME — the human-readable name of the element.
• ELEMENT_DESCR and ELEMENT_LABEL — descriptive text and the label associated with the element for presentation purposes.
• ELEMENT_TYPE and ELEMENT_GROUP — the classification of the element, used to group and categorize reporting concepts.
• PARENT_ID and PARENT_IDENTIFIER — references to the parent element, supporting the hierarchical structure of the taxonomy.
• HAS_CHILD_FLAG, HAS_PARENT_FLAG, and HIERARCHY_LEVEL — flags and level indicators that describe the element's position within the taxonomy hierarchy.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking record creation and modification.

Common Use Cases and Queries

The primary use case is to enumerate the elements available within a taxonomy for mapping to report axes and to Oracle report definitions. Reporting and diagnostic queries typically join this table to RG_XBRL_TAXONOMIES to resolve the taxonomy name, and to RG_REPORT_AXES and RG_XBRL_MAP_ELEMENTS to understand how elements are consumed downstream.

• Listing all elements for a taxonomy: SELECT ELEMENT_IDENTIFIER, ELEMENT_NAME, ELEMENT_TYPE FROM RG_XBRL_ELEMENTS WHERE TAXONOMY_ID = :taxonomy_id;
• Resolving element labels for a mapping report: join RG_XBRL_ELEMENTS to RG_XBRL_MAP_ELEMENTS on ELEMENT_ID.
• Identifying hierarchy structure: query PARENT_ID, HAS_CHILD_FLAG, HAS_PARENT_FLAG, and HIERARCHY_LEVEL to reconstruct the element tree.
• Verifying uniqueness: ELEMENT_IDENTIFIER is unique within a taxonomy, which is enforced by RG_XBRL_ELEMENTS_U2.

Related Objects

• RG_XBRL_TAXONOMIES — referenced by RG_XBRL_ELEMENTS.TAXONOMY_ID; the parent taxonomy definition.
• RG_REPORT_AXES — references RG_XBRL_ELEMENTS.ELEMENT_ID; defines report axes that use the element.
• RG_XBRL_MAP_ELEMENTS — references RG_XBRL_ELEMENTS.ELEMENT_ID; captures element mapping definitions.
• RG_XBRL_ELEMENTS_PK — primary key unique index on ELEMENT_ID.
• RG_XBRL_ELEMENTS_U1 and RG_XBRL_ELEMENTS_U2 — unique indexes supporting the business keys.