- OracleApps Epicenter - http://www.oracleappshub.com -

XBRL & Reporting

If you are still in R11i , you might be heard something like "XBRL", which is technically known as eXtensible Business Reporting Language (XBRL).

eXtensible Business Reporting Language (XBRL) [1] is an open specification for software that uses Extensible Markup Language (XML) data tags, together with a taxonomy, to describe business reporting, including financial information.


An XBRL taxonomy is a standard description and classification system for the contents of accounting reports, and both kind of reporting can be easily performed.

XBRL Financial Reporting Benefits

How to Set Up XBRL Financial Reporting in EBS

We can generate XBRL output with the FSG(Financial Statement Generator), you must load one or more taxonomies into your Oracle instance. Once loaded, you select the taxonomy to use for a row set then assign XBRL elements to FSG row definitions.

Take a note , you will get taxonomies available from a number of sources,one of such is at www.xbrl.org [2].

Download a Taxonomy to your Oracle Instance (Adopted from Documentation)

  1. Create a new directory on the same server where the database is to be used for storing taxonomy files. The directory can be an existing directory but it is recommended you create a new one. Using SQL*PLUS run create directory xmldir as <directory name>.
  2. Make the directory public for read access. Using SQL*PLUS run grant read on directory xmldir to public with grant option.
  3. Place the taxonomy files (usually there are six) in the directory. You can transfer them using FTP, copy, or download from a url.
  4. Determine if the codeset of the taxonomy files are in the same codeset as that used in the database. If they are not the same, you must convert the taxonomy files so that they use the same codeset as the database instance.

Loading XBRL Taxonomies

1. Launch the XBRL – Load Taxonomy program from the Submit Request window. The program has three parameters:

2. If a taxonomy has imports (links to other taxonomies), you must load the imports first then load the parent taxonomy.

Oracle GL and XBRL

XBRL Publisher is a module in XML Publisher which parses the XBRL taxonomies, extracts XML schema from Oracle Reports RDFs and XML Publisher data templates, defines mapping between taxonomy elements and elements in XML-output reports and at last generate XBRL report concurrents to create XBRL instances.

Reference Notes

4 Comments (Open | Close)

4 Comments To "XBRL & Reporting"

#1 Comment By Admin On March 4, 2008 @ 10:45 am

Speaking of XBRL, there is a new site for discussions and professional networking on XBRL. Here is the site: [5]

#2 Pingback By …XBRL Network On March 4, 2008 @ 9:18 pm

[…] NetworkXBRL & ReportingR12 : Management Reporting SecurityUnderstanding “Profit and Loss (P&L)” from […]

#3 Pingback By XBRL Reporting & Singapore On March 28, 2008 @ 9:24 am

[…] (Periodic Accrual)TGIGF: Thank God it’s Good Friday!100,000th Visitor…XBRL NetworkXBRL & ReportingR12 : Management Reporting SecurityUnderstanding “Profit and Loss (P&L)” from […]

#4 Pingback By Back to Basics: Notes from Financial Reporting & XBRL On August 29, 2008 @ 10:11 am

[…] Financial Reporting is supported in General Ledger (GL) through its Financial Statement Generator […]