3 Replies Latest reply on Jul 20, 2010 6:21 AM by 786111

    Convert Oracle Reports to BI Publisher

    738846
      I'm new to BI Publisher. I have Installed Oracle reports 10g and BI Publisher. I 'm trying to convert Oracle Reports to BI Publisher.
      I created a .rdf report and created a xml file using rwconverter.exe but not able to upload this XML file into BI publisher because it only uploads .zip or .xdo files.
      How can I convert *.rdf to BI Publisher report*?

      Thanks in advance.
        • 1. Re: Convert Oracle Reports to BI Publisher
          BIPuser
          Hello,

          Check these out if you haven't already done so:

          http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e10416/convertrpts.htm

          http://oraclebizint.wordpress.com/2007/08/22/oracle-reports-to-bi-publisher-conversion-utility/

          http://ora-apps.blogspot.com/2008/03/conerting-rdf-reports-to-xm-publisher.html

          Good luck!
          • 2. Re: Convert Oracle Reports to BI Publisher
            760099
            Even we have done the same type of requirement, but over here we have created newly.

            Created data template from the Oracle reports query,created parameters and then .RTF template.

            let me know what sort of requirement is yours...
            • 3. Re: Convert Oracle Reports to BI Publisher
              786111
              Hi,

              I am in process of converting the RDF files to BI Publisher report files. Here is the process I followed.

              1) Pre-requisites: I have Oracle Developer Suite (10.1.2.0.2) (i.e. Report Builder 10.1.2.0.2) and Oracle BI Publisher 10.1.3.4

              2) Converted RDF report to XML report using "rwconverter".

              3) Creating Data template from Oracle Report using DataTemplateGenerator. This creates the XML query template and DB package files.

              4) Creating RTF template from Oracle Report using RTFTemplateGenerator. This creates the RTF file.

              5) Update the DB package and XML file to make sure the SQL query and other related are working as expected or not.

              6) Loaded the Query Template (modified xml file), Format Template (modified RTF template) and then link them to OTM (Oracle Transport Management) report.

              7) When running the report from OTM UI, I received the below error. I tried lot of options, but no luck. Basically the lexical parameters are containing the null value in the DB package. If I don't pass any variables then report works fine.

              Any help is greatly appreciated.

              ======================
              At 2010-07-20 01:49:14.214

              BI Publisher Error during Content Generation

              [072010_014914212][][STATEMENT] Logger.init(): *** DEBUG MODE IS OFF. ***
              [072010_014914212][][STATEMENT] Template parsing started...
              [072010_014914212][][STATEMENT] Data Template ......
              [072010_014914212][][STATEMENT] oracle.xml.parser.v2.XMLDocument@61eef6cf
              [072010_014914212][][STATEMENT] Inside properties Parser...
              [072010_014914212][][STATEMENT] xml_tag_case=upper
              [072010_014914212][][STATEMENT] Inside parameterParser...
              [072010_014914212][][STATEMENT] Parameter:P_L_START_DATE Default value: 1=1
              [072010_014914212][][STATEMENT] Inside dataQueryParser...
              [072010_014914212][][STATEMENT] Template parsing completed...
              [072010_014914212][][STATEMENT] Setting Data Template
              [072010_014914212][][STATEMENT] Setting JDBC Connection
              [072010_014914213][][STATEMENT] Start process Data
              [072010_014914213][][STATEMENT] Process Data ...
              [072010_014914213][][STATEMENT] Executing data triggers...
              [072010_014914213][][STATEMENT] BEGIN
              SSCC_TENDER_RECAP_MANUAL_V4.P_L_START_DATE := :P_L_START_DATE ;

              :XDO_OUT_PARAMETER := 1;
              END;

              [072010_014914213][][STATEMENT] 1:SAME AS~'2010-07-19' :
              [072010_014914213][][STATEMENT] Executing data triggers...
              [072010_014914213][][STATEMENT] Declare
              l_flag Boolean;
              BEGIN
              l_flag := sscc_tender_recap_manual_v4.afterpform ;
              if (l_flag) then
              :XDO_OUT_PARAMETER := 1;
              end if;
              end;

              [072010_014914214][][EXCEPTION] SQLException encounter while executing data trigger....

              =========================
              Thanks,
              Lakshmi Padileti

              Thanks,