Thursday, November 7, 2013

RDF to XML auto conversion process.

Pre-Requisites

Java Environment Settings:

Set Path to execute the java executables…….
You can set the path by two ways
  1. By command prompt: ->  write on command prompt
       set path=”C:\DevSuiteHome_1\jdk\bin”


This is a location of javac.exe, java.exe, jawaw.exe etc.

  1. And by Environment Settings :->


Click on Advance Tab Click on  Environment Variable


Click on New and give variable name = path and
variable value = C:\DevSuiteHome_1\jdk\bin
Click on ok button and exit from there.











Set CLASSPATH for Run a java program smoothly.

It would be same as path setting only difference is
On command prompt

Set classpath=”C:\DevSuiteHome_1\jdk\lib”

On by system variable

Variable name = classpath
And variable value = C:\DevSuiteHome_1\jdk\lib


 

 

 

 

Update CLASSPATH with Needed JAR Files

To run the conversion utilities you need the following jar files in your classpath:
·         Collections.zip -
·         xmlparserv2-904.jar -
·         xdocore.jar
·         aolj.jar
For customers using Oracle Enterprise Business Suite (EBS), these libraries are available under JAVA_TOP. If these libraries are not there, the corresponding classes will be there under the JAVA_TOP.
For customer using Oracle BI Publisher Enterprise (sometimes referred to as "standalone"), all these libraries are available under WEB-INF\lib. Example:
C:\Oracle\bi\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF\lib

Steps to converting .rdf to xml files
            Convert 6i Report to 9i/10g Report first:=
           

            By Report Builder




Conversion of 9i/10g Report to rdf/xml files







By Report Builder










To Generate Data Definition

java.exe  -classpath
C:\DevSuiteHome_1\jdk\lib\xdocore.jar;C:\DevSuiteHome_1\jdk\lib\collections.zip;C:\DevSuiteHome_1\jdk\lib\aolj.jar;C:\DevSuiteHome_1\jdk\lib\xmlparserv2-904.jar oracle.apps.xdo.rdfparser.DataTemplateGenerator d:\test_report2.xml D:\hk\



java.exe  -classpath  C:\DevSuiteHome_1\jdk\lib\xdocore.jar;C:\DevSuiteHome_1\jdk\lib\collections.zip;C:\DevSuiteHome_1\jdk\lib\aolj.jar;C:\DevSuiteHome_1\jdk\lib\xmlparserv2-904.jar oracle.apps.xdo.rdfparser.DataTemplateGenerator D:\rdf_xml_conversion\Emp_Test1_xml.xml D:\rdf_xml_conversion\



To generate template


java.exe  -classpath
C:\DevSuiteHome_1\jdk\lib\xdocore.jar;C:\DevSuiteHome_1\jdk\lib\collections.zip;C:\DevSuiteHome_1\jdk\lib\aolj.jar;C:\DevSuiteHome_1\jdk\lib\xmlparserv2-904.jar oracle.apps.xdo.rdfparser.RTFTemplateGenerator d:\test_report2.xml


java.exe  -classpath  C:\DevSuiteHome_1\jdk\lib\xdocore.jar;C:\DevSuiteHome_1\jdk\lib\collections.zip;C:\DevSuiteHome_1\jdk\lib\aolj.jar;C:\DevSuiteHome_1\jdk\lib\xmlparserv2-904.jar oracle.apps.xdo.rdfparser.RTFTemplateGenerator D:\rdf_xml_conversion\Emp_Test1_xml.xml











java.exe  -classpath C:\DevSuiteHome_1\jdk\lib\xdocore.jar;C:\DevSuiteHome_1\jdk\lib\collections.zip;C:\DevSuiteHome_1\jdk\lib\aolj.jar;C:\DevSuiteHome_1\jdk\lib\xmlparserv2-904.jar oracle.apps.xdo.rdfparser.RTFTemplateGenerator d:\test_report2.xml

 -----------------------------------------------
We faced following issues when we converted  the rdf to xml.

1.       If we use alias columns as reference by bind (: )  in formula columns in RDF. In Data Template it will not support.

2.       In RDF we refer query column to formula column by bind ( : ). It will points to the actual source address. When we auto convert  RDF to XML  it will auto generate  .PLS  it will remove bind and passes as input parameter. If  same column exist in formula column select statement. It will give a error of (COLUMN AMBIGUOUSLY DEFINED).

3.       When we auto convert RDF TO XML it will generate .PLS files. Sometimes input parameters and select statements in functions will duplicate’s.

4.       If we use report field properties like page number, sysdate. It will not support in data template.

5.       Format triggers and Anchor will not support in template we need to include code manually in rtf.

6.       When we convert RDF to xml. Sometimes data template will generate special characters. That we need to remove manually. In few cases when auto converting RDFXML to data template sometimes data template will generate with syntactical errors we need to correct it manually.
7.       When we generate rtf(If complex layout, we need to rebuild the rtf manually)  from rdfxml. We need to do some formatting by comparing actual RDF output.

8.       Date format is not proper in rtf. When we auto generate rtf from xml.

9.       When we use column level sub queries in RDF. When we auto generate data template, the sub query FROM clause again included in main from clause we need to review the RDF and DATA TEMPLATE manually and correct the data template.

10.    SRW Package will not support in data template. Where ever we used srw.message etc - we need to manually add fnd.file.put_line(find_file.log)

11.       User Exits will not support in data template, XDOTEXTE Java executable will do the same work.


I also attached steps we need to perform while converting rdf to xml.



No comments:

Post a Comment