Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Monday, February 25, 2013

XBRL & Reporting



If you are still in R11i , you might be heard something like "XBRL", which is technically known as eXtensible Business ReportingLanguage (XBRL).
eXtensible Business Reporting Language (XBRL) 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.
double-arrowXBRL and XML
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.
  • Business Reporting
  • Including important financial information
double-arrowXBRL Financial Reporting Benefits
  • Achieve greater transparency and auditability of your company's financial information for better auditability.
  • Directly integrated with FSG – enabling XBRL Financial Reporting at the source:
    • Reuse existing FSG reports and components
    • Link your unique chart of accounts to the standardized elements of an XBRL taxonomy
    • Submit your XBRL Financial Reports in all of the FSG output options
double-arrowHow 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.
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:
  • Taxonomy Name: Enter a unique name for the taxonomy.
  • Taxonomy xsd File Name: Enter the file name, with or without the .xsd extension.
  • Taxonomy Description: Enter a description for the taxonomy.
2. If a taxonomy has imports (links to other taxonomies), you must load the imports first then load the parent taxonomy.
double-arrowOracle GL 11.5.10.2 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.
patch
double-arrowReference Notes

No comments:

Post a Comment