Index

A  B  C  D  G  I  L  M  O  P  R  S  T  U  V  X 

Numbers

3NF data model, 3.2.1

A

architecture
XBRL Extension for Oracle Database, 1.3

B

bulk-loading XBRL documents
parameter file, 2.1.3
bulkLoadXBRLFiles PL/SQL procedure, 3.1.1

C

concept_roots PL/SQL function, 3.2.3.2
concept_roots2 PL/SQL function, 3.2.3.2
concepts_in_tree PL/SQL function, 3.2.3.3
concepts_in_tree2 PL/SQL function, 3.2.3.3
concepts_network PL/SQL function, 3.2.3.1
concepts_network2 PL/SQL function, 3.2.3.1
createFactTable PL/SQL deprecated procedure, 3.2.4.1
createHyperCubeFactTable PL/SQL procedure, 3.2.4.2
createHyperCubeSuperFactTable PL/SQL procedure, 3.2.4.3
createStarSchemaFromFact PL/SQL procedure, 3.2.4.4
createSuperFactTable PL/SQL deprecated procedure, 3.2.4.6
createTupleDataTable PL/SQL procedure, 3.1.2
createViewForConceptRoots PL/SQL procedure, 3.2.4.7
createViewForConceptTree PL/SQL procedure, 3.2.4.8
createViewForInstanceNetwork PL/SQL procedure, 3.2.4.9

D

DBMS_ORAXBRL PL/SQL package, 3.1
DBMS_ORAXBRLI PL/SQL package, 3.2.2
DBMS_ORAXBRLT PL/SQL package, 3.2.3
DBMS_ORAXBRLV PL/SQL package, 3.2.4
deleteAuxDocument PL/SQL procedure, 3.1.3
deleteFolder PL/SQL procedure, 3.1.4
deleteInstance PL/SQL procedure, 3.1.5
deleteLinkbase PL/SQL procedure, 3.1.6
deleteTaxonomy PL/SQL procedure, 3.1.7
demo2.sql demo script, 5.3.2
Demo-BIFiles directory (installation), 5.3.3
demo.sql demo script, 5.3.2
deploying XBRL Extension for Oracle Database, 2.2
dropTupleDataTable PL/SQL procedure, 3.1.8
DTS_filelist PL/SQL function, 3.1.10
DTS_files PL/SQL procedure, 3.1.9

G

GAAP demo
installing, 5.2.8
getAuxDocForRepoPath PL/SQL function, 3.1.11
getDocument PL/SQL function, 3.1.12

I

installation
instructions, 5.2.2
requirements, 5.1
installing XBRL Extension for Oracle Database, 5
InstallXBRLDemo.sql installation script, 5.3.1
instance_network PL/SQL function, 3.2.2.1
instance_network2 PL/SQL function, 3.2.2.1
isDocPathValid PL/SQL function, 3.1.13

L

lifecycle, XBRL, 1.3.1
loadAuxDocument PL/SQL procedure, 3.1.14
loadInstance PL/SQL procedure, 3.1.15
loadLinkbase PL/SQL procedure, 3.1.16
loadSchema PL/SQL procedure, 3.1.17

M

mapPublishedLocation PL/SQL procedure, 3.1.18
multiple_instance_network PL/SQL function, 3.2.2.2
multiple_instance_network2 PL/SQL function, 3.2.2.2

O

OBIEE
See Oracle Business Intelligence Suite Enterprise Edition
obiee_home placeholder, Preface
obieedata_home placeholder, Preface
Oracle Business Intelligence Suite Enterprise Edition
integration with XBRL Extension for Oracle Database, 5.5
ORAXBRL_CALCULATION_LINKBASE relational view, 3.2.1
ORAXBRL_CONCEPT data type, 3.3.1
ORAXBRL_CONCEPTLIST data type, 3.3.1
ORAXBRL_DEFINITION_LINKBASE relational view, 3.2.1
ORAXBRL_DTSURL_T data type, 3.3.4
ORAXBRL_DTSURLLIST data type, 3.3.4
ORAXBRL_FOOTNOTES relational view, 3.2.1
ORAXBRL_INST_ARCROLEREFV relational view, 3.2.1
ORAXBRL_INST_CONTEXTV relational view, 3.2.1
ORAXBRL_INST_ITEMV relational view, 3.2.1
ORAXBRL_INST_LINKBASEREFV relational view, 3.2.1
ORAXBRL_INST_NSV relational view, 3.2.1
ORAXBRL_INST_ROLEREFV relational view, 3.2.1
ORAXBRL_INST_SCHEMAREFV relational view, 3.2.1
ORAXBRL_INST_UNITV relational view, 3.2.1
ORAXBRL_ITEM data type, 3.3.2
ORAXBRL_ITEMLIST data type, 3.3.2
ORAXBRL_LOCLIST data type, 3.3.3
ORAXBRL_PRES_LINKBASE relational view, 3.2.1
ORAXBRL_REFERENCE_LINKBASE relational view, 3.2.1
ORAXBRL_SCENARIO_EXPLICITV relational view, 3.2.1
ORAXBRL_SCENARIO_TYPEDV relational view, 3.2.1
ORAXBRL_SEGMENT_EXPLICITV relational view, 3.2.1
ORAXBRL_SEGMENT_TYPEDV relational view, 3.2.1
ORAXBRL_STARSCHEMA data type, 3.3.3
ORAXBRL_XS_ARCROLETYPEV relational view, 3.2.1
ORAXBRL_XS_COMPLEXTYPESC relational view, 3.2.1
ORAXBRL_XS_ELEMENT relational view, 3.2.1
ORAXBRL_XS_GROUPV relational view, 3.2.1
ORAXBRL_XS_IMPORTNSV relational view, 3.2.1
ORAXBRL_XS_LINKBASEREFV relational view, 3.2.1
ORAXBRL_XS_NSV relational view, 3.2.1
ORAXBRL_XS_ROLETYPEV relational view, 3.2.1
ORAXBRL_XS_TARGETNSV relational view, 3.2.1

P

parameter file for bulk-loading XBRL documents, 2.1.3
placeholders for installation instructions, Preface
PL/SQL functions and procedures
bulkLoadXBRLFiles, 3.1.1
concept_roots, 3.2.3.2
concept_roots2, 3.2.3.2
concepts_in_tree, 3.2.3.3
concepts_in_tree2, 3.2.3.3
concepts_network, 3.2.3.1
concepts_network2, 3.2.3.1
createFactTable (deprecated), 3.2.4.1
createHyperCubeFactTable, 3.2.4.2
createHyperCubeSuperFactTable, 3.2.4.3
createStarSchemaFromFact, 3.2.4.4
createSuperFactTable (deprecated), 3.2.4.6
createTupleDataTable, 3.1.2
createViewForConceptRoots, 3.2.4.7
createViewForConceptTree, 3.2.4.8
createViewForInstanceNetwork, 3.2.4.9
deleteAuxDocument, 3.1.3
deleteFolder, 3.1.4
deleteInstance, 3.1.5
deleteLinkbase, 3.1.6
deleteTaxonomy, 3.1.7
dropTupleDataTable, 3.1.8
DTS_filelist, 3.1.10
DTS_files, 3.1.9
getAuxDocForRepoPath, 3.1.11
getDocument, 3.1.12
instance_network, 3.2.2.1
instance_network2, 3.2.2.1
isDocPathValid, 3.1.13
loadAuxDocument, 3.1.14
loadInstance, 3.1.15
loadLinkbase, 3.1.16
loadSchema, 3.1.17
mapPublishedLocation, 3.1.18
multiple_instance_network, 3.2.2.2
multiple_instance_network2, 3.2.2.2
registerTaxonomySchema, 3.1.19
updateDocValidity, 3.1.20
validateDTSIntegrity, 3.1.21
validateDTSIntegrity2, 3.1.21
PL/SQL packages
DBMS_ORAXBRL, 3.1
DBMS_ORAXBRLI, 3.2.2
DBMS_ORAXBRLT, 3.2.3
DBMS_ORAXBRLV, 3.2.4
pretty-printing
in book examples, Preface

R

registerTaxonomySchema PL/SQL procedure, 3.1.19
relational representation (views) of XBRL, 3.2.1
requirements for installation, 5.1

S

sample XBRL application
building and using, 2.1.4
sample XBRL repository
installing, 5.2.8
scripts
demo2.sql, 5.3.2
demo.sql, 5.3.2
InstallXBRLDemo.sql, 5.3.1
xbrlcrt.sql, 5.2.5
xbrldrop.sql, 5.2.6
xbrlerrmsg.sql, 5.3.1
xbrlinstall.sql, 5.2.2
xbrlpurgefile.sql, 5.3.1
xbrlregschema.sql, 5.3.1
xbrludpurge.sql, 5.2.7
xbrluninstall.sql, 5.2.4
super fact table
definition, 3.2.4.3
sys_pass placeholder, Preface

T

third normal form data model, 3.2.1

U

uninstalling XBRL Extensio for Oracle Database, 5.2.4
updateDocValidity PL/SQL procedure, 3.1.20
USGAAP2008 directory (installation), 5.3.2

V

validateDTSIntegrity PL/SQL procedure, 3.1.21
validateDTSIntegrity2 PL/SQL procedure, 3.1.21

X

xb_protocols placeholder, Preface
xb_rep placeholder, Preface, Preface, Preface, Preface, Preface, 2.1.2, 2.1.4.2
xb_rep_pass placeholder, Preface
xb_rep_tmp_ts placeholder, Preface
xb_rep_ts placeholder, Preface, 4.2, 4.3.2
xb_sys_pass placeholder, Preface
xb_sys_tmp_ts placeholder, Preface
xb_sys_ts placeholder, Preface
XBRL Extension for Oracle Database
deploying, 2.2
installing, 5
uninstalling, 5.2.4
XBRL Extension for Oracle Database architecture, 1.3
XBRL processing engine
installing, 5.4
XBRL relational representation (views), 3.2.1
XBRL repository
creating, 5.2.5
dropping, 5.2.6
purging, 5.2.7
sample
installing, 5.2.8
xbrlcrt.sql script to create an XBRL repository, 5.2.5, 5.3.1
XBRLDemoScripts directory, 5.3.2
xbrldrop.sql script to drop an XBRL repository, 5.2.6, 5.3.1
xbrlerrmsg.sql installation script, 5.3.1
xbrlinstall.sql installation script, 5.2.2, 5.3.1
xbrlpurgefile.sql script to delete resources, 5.3.1
xbrlregschema.sql script to register standard XBRL schemas, 5.3.1
xbrl.rpd sample XBRL application based on USGAAP 2008, 5.3.3
XBRLScripts directory (installation), 5.3.1
XBRLSYS database user, 5.2.2
xbrludpurge.sql script to purge an XBRL repository, 5.2.7, 5.3.1
xbrluninstall.sql script, 5.2.4, 5.3.1
xbrl.zip sample XBRL application based on USGAAP 2008, 5.3.3
XML Schema
definition, Preface