I am not familiar yet with 12i. I guess you can read the Oracle XML Publisher User’s Guide. Good luck. ]]>
i am suposed to develop a AP Cheque report into BI publisher in 12i. I am pretty comforatble with RDF->RTF->XML report..
But with Data template i feel easy but trouble some.. And on top I am not able to find the place where we upload the Data template. Pls help…
I went to XML Publisher resp-> Data Template-> I cud see only the general Section.. I cant find the files Section. Pls help
-Lava
]]>It seems that you are missing some of the java classes in your classpath. Not sure exactly how the pieces fit together, but I did manage to get it working.
I finally solved the problem. It turns out the DataTemplateGenerator and RFTTemplateGenerator classes are not provided with BI Publisher download, but is a part of the XML Publisher 5.6.3 download. I downloaded the XMLP 5.6.3 and pulled out the file j5472959_xdo.zip. I included j5472959_xdo.zip in my class pathstring and everything worked as it should have.
I put the following in files in my classpath:
Collections.zip, xmlparserv2-904 – available from the JAVA_TOP directories, aolj.jar, xdocore.jar, xmlparserv2-904.jar and collections.jar. In an APPS environment you can also add a pointer to the Apps JAVA_TOP – under here are the necessary XML Publisher libraries.
The command I ultimately used was:
java.exe -verbose -cp xdoparser.jar;collections.jar;j5472959_xdo.zip;versioninfo.jar;xmlparserv2-904.jar oracle.apps.xdo.rdfparser.RTFTemplateGenerator C:\ReportTest\[REPORTNAME].xml
There’s a lot of references on OTN forums by the way.
As for the the BIPBatchConversion utility: I beleive this isn’t a jar file or an executable as part of some BIP installation but a simple script oracle developed internally and uses as part of their own Migration offerering.
www.oracle.com/technology/products/xml-publisher/docs/BIPBurstingImplementationService.ppt
It looks something like this:
#!/bin/sh
# This script will generate a report for each template presnet in the current directory
# Create a variable to hold the classpath
classpath=”DIR/collections.zip:DIR/xmlparserv2-904.zip:JAVA_TOP directory”
if [ $# -eq 0 ]
then
for file in *.rdf
do
echo “Processing … $file”
if test -f $file
then
# Convert the rdf to xml
echo yes | $ORACLE_HOME/bin/rwconverter.sh batch=yes source=$file dest=$file dtype=xmlfile overwrite=yes; \
# Create a variable to hold the new xml file name, this is just a simple replace
# statement
xfile=”${file//rdf/xml}”;
# Generate the data template plus plsql
echo yes | /local/java/jdk1.5.0_06/bin/java -classpath $classpath oracle.apps.xdo.rdfparser.DataTemplateGenerator $xfile;
# Generate the RTF template
echo yes | /local/java/jdk1.5.0_06/bin/java –classpath $classpath oracle.apps.xdo.rdfparser.RTFTemplateGenerator $xfile;
fi
done
else
echo usage: $0
echo this script will generate a data template and supporting plsql and an RTF template in the current directory
fi
regards, ]]>
I have read every Oralce document, blog and technical forum I can find on creating an RFT template from an RDF. The process is always described as simple and the instuctions seem straight forward and yet I cannot get this to work. The most frequent error is “Exception in thread main java.Lang.NoCLassDefFoundError: oracle/apps/xdo/rdfparser/RTFTemplateGenerator”. Evidently, the classes are not being defined properly, but I have made every attempt to define these and nothing works. I have the classes installed. I am new to using java so I assume I have missed something elemental.
This should be as simple as installing the software and running it, but it isn’t. Any help would be appreciated. I don’t look forward to rewriting hundreds of custom reports using MS-Word and BI Publisher, but right now, that is our only option. We have converted 10 reports so far manually.
Thanks,
PS There are references to an executable called “BIBatchconverter”. This is also described as “simple” to use and yet I cannot find this file on any installation of BI that I have installed on my laptop (5.6.3 through 10.1.3.3.1) and there is no reference to it’s existence on MetaLink. Odd!
]]>all data from old database to new database so can you hemp me hoe to do that? ]]>
We’ve already got a huge community with consultants and customers with a great deal of knowledge about all kinds of area’s, which could be presented in one of these formats.
And the technical implementation is not a big challenge at all either.
Next to the technical benefits for the employees should the marketing and commercial potential of the above be very appealing to any manager… 
And with the rise of ‘new’ Web 2.0 technologies like AJAX, you can develop things you just can’t achieve on the database.
]]>