Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Placeholders in Oracle Database XBRL Extension Developer's Guide
• Conventions
• Code Examples

Changes in This Release for XBRL Extension to Oracle XML DB

• XBRL Extension to Oracle XML DB 11g Release 3 (11.2.0.2.2) New Features
• XBRL Extension to Oracle XML DB 11g Release 2 (11.2.0.2.1) New Features
• XBRL Extension to Oracle XML DB 11g Release 2 (11.2.0.2.1) Deprecated Constructs

1 Overview of XBRL Extension to Oracle XML DB

• XBRL and XBRL Extension to Oracle XML DB
• Overview of XBRL Extension to Oracle XML DB Features
• Architecture
  • XBRL Content Lifecycle
  • Architecture of XBRL Extension to Oracle XML DB
  • Components of XBRL Extension to Oracle XML DB
    • XBRL Extension to Oracle XML DB: Storage
    • XBRL Extension to Oracle XML DB: Querying
    • XBRL Extension to Oracle XML DB: Services
    • XBRL Processing
    • Oracle Business Intelligence Suite Enterprise Edition

2 Using XBRL Extension to Oracle XML DB

• XBRL Application Design
  • Overview of XBRL Application Architecture
  • Using a Shared Database Schema for Enterprise User Security
  • Creating a Parameter File for Bulk-Loading a Set of XBRL Documents
  • Building and Using a Sample XBRL Application: USGAAP 2008
    • Step 1: Set Up USGAAP
    • Step 2: Load USGAAP
    • Step 3: Query USGAAP Taxonomy
    • Step 4: Validate and Load New Report Submissions
    • Step 5: Query the Instance or Generate Derived Views
    • Step 6: Integrate with Oracle Business Intelligence Suite Enterprise Edition
    • Step 7: Drop Individual Filings
    • Step 8: Drop USGAAP
  • Building and Using a Sample XBRL Application: Tuples
    • Step 1: Create XBRL Standard Schema Files for the Tuple Application
    • Step 2: Register XBRL Standard Schemas for the Tuple Application
    • Step 3. Register the Sample XBRL Taxonomy for the Tuple Application
    • Step 4: Create Tuple Elements and Corresponding Data Tables
    • Step 5: Load an XBRL Instance with Tuple Data
• Deployment of XBRL Extension to Oracle XML DB

3 APIs – XBRL Extension to Oracle XML DB

• XBRL Repository Storage API: DBMS_ORAXBRL
  • bulkLoadXBRLFiles
  • createTupleDataTable
  • deleteAuxDocument
  • deleteFolder
  • deleteInstance
  • deleteLinkbase
  • deleteTaxonomy
  • dropTupleDataTable
  • DTS_files
  • DTS_filelist
  • getAuxDocForRepoPath
  • getDocument
  • isDocPathValid
  • loadAuxDocument
  • loadInstance
  • loadLinkbase
  • loadSchema
  • mapPublishedLocation
  • registerTaxonomySchema
  • updateDocValidity
  • validateDTSIntegrity, validateDTSIntegrity2
• XBRL Repository Query
  • XBRL Relational Representation
  • Instance Network Functions: DBMS_ORAXBRLI
    • instance_network, instance_network2
    • multiple_instance_network, multiple_instance_network2
  • Concept Network Functions: DBMS_ORAXBRLT
    • concepts_network, concepts_network2
    • concept_roots, concept_roots2
    • concepts_in_tree, concepts_in_tree2
  • Transforming Procedures: DBMS_ORAXBRLV
    • createFactTable (Deprecated)
    • createHyperCubeFactTable
    • createHyperCubeSuperFactTable
    • createStarSchemaFromFact
    • createStarSchemaFromHC
    • createSuperFactTable (Deprecated)
    • createViewForConceptRoots
    • createViewForConceptTree
    • createViewForInstanceNetwork
    • dropStarSchema
• XBRL Extension to Oracle XML DB Data Types
  • ORAXBRL_CONCEPT, ORAXBRL_CONCEPTLIST
  • ORAXBRL_ITEM, ORAXBRL_ITEMLIST
  • ORAXBRL_LOCLIST, ORAXBRL_STARSCHEMA
  • ORAXBRL_DTSURLLIST, ORAXBRL_DTSURL_T

4 Administering XBRL Extension to Oracle XML DB

• Overview of XBRL Repository Tables and Indexes
• Creating a Tablespace for the XBRL Repository Indexes
• Partitioning XBRL Repositories
  • Partioning the XBRL Repository Instance Table
  • Defining Tablespaces for Partitioned XBRL Data
• Obtaining Information about Your XBRL Repository

5 Installing XBRL Extension to Oracle XML DB

• Hardware and Software Requirements
  • Hardware Requirements
  • Software Requirements
• Installing and Uninstalling XBRL Extension to Oracle XML DB
  • Preparing to Install XBRL Extension to Oracle XML DB
  • Installing XBRL Extension to Oracle XML DB
  • Determining the Installed Version of XBRL Extension to Oracle XML DB
  • UnInstalling XBRL Extension to Oracle XML DB
  • Creating an XBRL Repository
  • Dropping an XBRL Repository
  • Purging an Accidentally Dropped XBRL Repository
  • Installing the Sample XBRL Repository and GAAP Demo
• Directory xbrl_xdb
  • XBRLScripts
  • XBRLDemoScripts
  • Demo-BIFiles
• Installing a Third-Party XBRL Processing Engine
• Integration with Oracle Business Intelligence Suite

Index