Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

XBRL & Reporting

Posted on March 3rd, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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) 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-arrow Oracle 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

Related Posts

Posted in XBRL | 4 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. Admin Says:

    Speaking of XBRL, there is a new site for discussions and professional networking on XBRL. Here is the site: http://xbrlnetwork.ning.com

  2. …XBRL Network Says:

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

  3. XBRL Reporting & Singapore Says:

    […] (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. Back to Basics: Notes from Financial Reporting & XBRL Says:

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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.