Re: XBRL Application using ADF and Oracle XML DB

[John Flack]

Since no-one else has taken a shot at this - I'll throw in two cents.
XBRL is an XML interchange format defined with an XML Schema and other explanatory documentation.  JDeveloper and ADF handle XML fairly well, especially if you have an XML Schema.  To get you started, read the chapter of the Fusion Developer's Guide for ADF entitled, "Reading and Writing XML" - in the version for 11.1.2.0.0, it is section 42.7.  You'll probably want to get familiar with XSLT for transforming between XML formats in more generic documentation you will find on the web and in bookstores.

You may get better advice, if you give use cases - are you receiving data in XBRL format, sending it, or both?  Do you want to use it in a web service?  And yes, you could use XML DB to handle the XBRL input and output, and then use an ADF application to use the data while it is in your database.  But the best choice will depend on exactly what you need to do.

On Monday, November 12, 2012 11:16:15 AM UTC-5, Erdenebayar wrote:

Dear All,

Currently i am trying to start Tax system using XBRL standard. How ADF is compatible with XBRL and Oracle XML DB? 

I haven't any idea with how to do it? How to fill out form using XBRL and ADF, it means dynamic form based on XBRL. Because we have lot of financial and taxation reports, therefor application forms should be drawn dynamically.

Please suggest and advice me, which is the best way to do it.

Best regards,

Erdenebayar

[Chris Muir]

As extension to John's comments.

While XBRL is just plain old XML validated by XSD, a key part of the
XBRL solution is the taxonomies that define the different XBRL payloads.
While XBRL as a standard is a variable payload format, each XBRL
instance is based on a defined taxonomy which makes an instance of an
XBRL document predictable. The definition of the taxonomies is a very
important part of using XBRL.

As such treating XBRL as plain old XML is not enough, you need to work
with the taxonomies to make this work.

From ADF's perspective while it works with XML documents, it has no
intelligence built in to interact with XBRL documents and create
valid/consume documents based on the taxonomy. Traditionally you would
make use of an XBRL SDK to fill this gap (and specifically for a Java
platform, a Java XBRL SDK), of which I believe there is a free solution
available (quality unknown), but also vendor based solutions too (which
if I remember, stupendously expensive).

John is also correct (and I've used this technique in the past to avoid
an expensive purchase of an XBRL SDK library) to say you can use XSLT to
convert one XML document into an XBRL document & vice versa. However
you cannot validate the result without an XBRL SDK, as XSLT and the
relating XSDs have no ability to validate the XBRL instance against the
taxonomy - which may not be a problem if you're comfortable you are
producing valid XBRL documents.

With this in mind I happen to know (as you do) the Oracle database
integrated an XBRL solution more recently with XMLDB. It's unclear to
me what services are available here (such as an SDK) as I gladly left
the world of XBRL behind, but to say from ADF's perspective again we
have no direct support beyond XML. Of course we do have support for the
database so you presumably can make calls via JDBC down to the database
XBRL services (whatever they are).

If I was to give advice, forget ADF for the time being and focus on the
XBRL services via XMLDB. This will give you a munch better
understanding of what you need to do with XBRL first. Then focus on
attaching an UI such as ADF over the db solution set.

Hope this helps.

Regards,

CM.

> --
> You received this message because you are subscribed to the ADF
> Enterprise Methodology Group
> (http://groups.google.com/group/adf-methodology). To unsubscribe send
> email to adf-methodolo...@googlegroups.com
>
> All content to the ADF EMG lies under the Creative Commons Attribution
> 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any
> content sourced must be attributed back to the ADF EMG with a link to
> the Google Group (http://groups.google.com/group/adf-methodology).

[Erdenebayar Erdenebileg]

Thank you John and Chris,

Our case is: We need to fill out and report financial data using ADF technology. Currently we are trying to start with two way.

1. Use ADF UI over the database solution set, As Chris mentioned.

2. Just develop or use other vendor software. Just like: http://www.sqlpower.ca/xbrlpower/images/xbrlpower-components.jpg.

Based on your advice, I think, First way is fast to start our development. After we can implement/plug some converter for XBRL based report exchange.

Best regards,

Erdenebayar

email to adf-methodology+unsubscribe@googlegroups.com

All content to the ADF EMG lies under the Creative Commons Attribution
3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any
content sourced must be attributed back to the ADF EMG with a link to
the Google Group (http://groups.google.com/group/adf-methodology).

--
You received this message because you are subscribed to the ADF Enterprise Methodology Group (http://groups.google.com/group/adf-methodology). To unsubscribe send email to adf-methodology+unsubscribe@googlegroups.com

[Erdenebayar Erdenebileg]

Hello,

Are there any solution for run-time ADF Form builder or author (like: http://www.orbeon.com/orbeon/fr/orbeon/builder/new)? 

It means, End user can draw any type of forms. And form save as XML data. Currently we have 200 type of forms.

BR,

Erdenebayar