Setup Checklist for eXtensible Business Reporting Language (XBRL) FSG reports

(Doc ID 277877.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle General Ledger - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
XBRLLDTX: Load XBRL Taxonomy program
XBRLRMTX: Remove XBRL Taxonomy program

RGXGDAXS: Row Set Form (115.51)
RGXGDREP: Define Report Form (115.11)
RGXGRRST: Run Report Form (115.29)


***Checked for relevance on 14-Aug-2015***


Goal

The goal of this article is to specify the setups needed to product XBRL financial reports (FSG) in Oracle General Ledger.
Please note the XBRL is not supported in R12 at this time - refer to (<Note:756318.1> R12 When uploading XBRL Taxonomies Get Error: ORA-01400: cannot insert NULL into RG.RG_XBRL_TAXONOMIES.TAXONOMY_URL)

This setup produces the following changes:

A) New Tables added for this feature:

  1. RG_XBRL_TAXONOMIES
  2. RG_XBRL_ELEMENTS
  3. RG_XBRL_MAP_ELEMENTS

B) Modified Tables for this feature:

  1. RG_REPORT_AXES
    New Column: ELEMENT_ID
  2. RG_REPORT_AXIS_SETS
    New Column: TAXONOMY_ID

C) New or Modified Concurrent programs: Two new concurrent programs are available to allow you to load and remove XBRL Taxonomies.

  1. The Load XBRL Taxonomy program is used to load XBRL Taxonomies - XBRLLDTX
  2. The Remove XBRL Taxonomy program is used to remove taxonomies - XBRLRMTX

D) Modified Forms:

  1. Form RGXGDAXS - Row Set (115.51)
    New field added: XBRL Taxonomy
  2. Form RGXGDREP - Define Report (115.11)
    New field added: XBRL Element
  3. Form RGXGRRST - Run Report (115.29)
    Modified Field: Output Option field has XBRL added to the List of Values

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms