1 Reply Latest reply on Feb 13, 2013 4:08 PM by mdrake-Oracle

    XBRL Extension - loading/deleting taxonomy ?

      Oracle 11gr2 on Windows XP
      Oracle Database 11g Enterprise Edition Release - Production
      PL/SQL Release - Production
      CORE     Production
      TNS for 32-bit Windows: Version - Production
      NLSRTL Version - Production


      I'm confused by behavior of the XBRL Extension regarding loading and deleting taxonomies into/from the xbrl repository. Please se check my steps:

      1. Using bulkLoad and parameters files linkbase.xml and schema.xml I successfully registered my taxonomy:
      EXEC xbrlsys.XB_XBRL_APP_PKG.bulkLoadXBRLFiles(1, 'XBRL_DIR', 'schema.xml', NULL);
      EXEC xbrlsys.XB_XBRL_APP_PKG.bulkLoadXBRLFiles(2, 'XBRL_DIR', 'linkbase.xml', NULL);
      2. Later I found problem and dropped the taxonomy:
      EXEC xbrlsys.XB_XBRL_APP_PKG.deleteFolder('http://test2');
      3. I fixed the taxonomy and repeated the step 1- bulkLoad. Schemas were loaded successfully however linkbase load ended with an error.
      ORA-20044: Error processing /DIMtest/d-Segment-definition.xml ORA-20020: Load of Linkbase Document Failed ORA-20017: Linkbase upload Failed
      ORA-06512: at "XBRLSYS.XB_XBRL_APP_PKG", line 117
      ORA-06512: at line 1 
      4. Finally I realised that the linkbase files still physically exist in folder of the XML DB repository. After "hard delete" it is possible to bulkLoad linkbases again.
      exec dbms_xdb.deleteresource('/xbrl/xbrlsys/DIMtest/d-Segment-definition.xml');
      The question: What I did wrong? Is it a bug?

      thanks for help.