[dkhemani]

Hi All,
We are trying to configure a custom report in OTM which was developed and tested using BI publisher.
Following steps were done to configure the report in OTM

1. Create a query template
2. Create the format template
3. The query and format template were then uploaded in OTM.
4. The report was configured using the query and format template in OTM. Parameter was also created so as to filter the records
5. Report was then called from the Report Manager option.
The report did not fetch the records based on the paramter that was passed.
I just have one parameter that was defined in the Query template. The records are fethched correctly in BI publisher. However when the parameter was created in the OTM report, it did not pass the value to the query.
Any thoughts on where I am going wrong here.

Regards
Deepak

[l_kator]

OTM 6 pass parameters in format: filter~'DOMAIN.VALUE' ('SAME AS~'CRP3.01433')

[kkchopra]

Hi,

Could you please share as how to integrate BI Pub with OTM 6.0 ?


Cheers,
Kamleshwar Chopra

[l_kator]

It is not necessary. In отм6 the tool which works as BIP is already integrated

[kkchopra]

Hi,

Thanks for the quick response. But I am still confused as how to create and add new reports in OTM ?

Cheers,
Kamleshwar

[l_kator]

For this it is necessary to create .xml file with SQL and .rtf template file .And then uploaded files to OTM in Business Process Automation>Power Data>Document Generation>Reports>new

[kkchopra]

Thanks for this very useful info. I tried with this by creating dummy XML SQL file and format template.

But I am able to uplaod SQL XML file but not the format template and I am getting following error. If you have any clue on this then it would be great:

Not able to transform the uploaded template to xsl.
java.lang.IllegalAccessError: tried to access class oracle/apps/xdo/common/xliff/CommonXLIFFUtil$XLIFFHeaderInfo from class oracle/apps/xdo/template/rtf/xliff/XLIFFUtil

[l_kator]

I attach zip with .xml and .rtf files. Try to use it. If it works do a similar files.

[kkchopra]

No Bro, even your format_template file (RTF) is also giving the same error. I am getting following in a stack trace. Any clue as what all areas we can check to fix this OR Is it related to some installation or access issue ?


Stack Trace
Not able to transform the uploaded template to xsl.
java.lang.IllegalAccessError: tried to access class oracle/apps/xdo/common/xliff/CommonXLIFFUtil$XLIFFHeaderInfo from class oracle/apps/xdo/template/rtf/xliff/XLIFFUtil
java.lang.IllegalAccessError: tried to access class oracle/apps/xdo/common/xliff/CommonXLIFFUtil$XLIFFHeaderInfo from class oracle/apps/xdo/template/rtf/xliff/XLIFFUtil
at oracle.apps.xdo.template.rtf.xliff.XLIFFUtil.extra ctXLIFF(XLIFFUtil.java:476)
at oracle.apps.xdo.template.rtf.FOTemplate.writeBPXML (FOTemplate.java:1392)
at oracle.apps.xdo.template.rtf.RTF2XSLParser.writeBP XML(RTF2XSLParser.java:1369)
at oracle.apps.xdo.template.rtf.RTF2XSLParser.writeBP XML(RTF2XSLParser.java:1383)
at oracle.apps.xdo.template.rtf.RTF2XSLParser.writeBP XML(RTF2XSLParser.java:1376)
at oracle.apps.xdo.template.RTFProcessor.process(RTFP rocessor.java:256)
at glog.server.document.FormatTemplatePersistenceHand ler.postSave(FormatTemplatePersistenceHandler.java :80)
at glog.util.persistence.PersistenceManager.execute(P ersistenceManager.java:132)
at glog.util.genericcontainer.GenericContainerUtilSes sionBean.store(GenericContainerUtilSessionBean.jav a:37)
at glog.util.genericcontainer.GenericContainerUtilSes sionServerSideEJBWrapper.store(GenericContainerUti lSessionServerSideEJBWrapper.java:46)
at glog.util.genericcontainer.GenericContainerUtilSes sionBean.compareAndStore(GenericContainerUtilSessi onBean.java:123)
at glog.util.genericcontainer.GenericContainerUtilSes sionServerSideEJBWrapper.compareAndStore(GenericCo ntainerUtilSessionServerSideEJBWrapper.java:26
at sun.reflect.GeneratedMethodAccessor218.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxRequi redInterceptor.invoke(TxRequiredInterceptor.java:5 0)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:47)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 7)
at GenericContainerUtilSessionHome_RemoteProxy_385en7 8.compareAndStore(Unknown Source)
at glog.webserver.update.AbstractUpdate.callGenericCo ntainer(AbstractUpdate.java:359)
at glog.webserver.update.GenericContainerXMLUpdate.pr ocess(GenericContainerXMLUpdate.java:10
at glog.server.xmlupdate.XMLUpdateSessionBean.updateA ndTrack(XMLUpdateSessionBean.java:244)
at glog.server.xmlupdate.XMLUpdateSessionServerSideEJ BWrapper.updateAndTrack(XMLUpdateSessionServerSide EJBWrapper.java:344)
at sun.reflect.GeneratedMethodAccessor287.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxRequi redInterceptor.invoke(TxRequiredInterceptor.java:5 0)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:47)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 7)
at XMLUpdateSessionHome_RemoteProxy_6658h1d.updateAnd Track(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.evermind.server.rmi.RmiMethodCall.run(RmiMetho dCall.java:53)
at com.evermind.util.ReleasableResourcePooledExecutor $MyWorker.run(ReleasableResourcePooledExecutor.jav a:304)
at java.lang.Thread.run(Thread.java:595)

[kkchopra]

It seems to be some BI Pub. patch issue as same error is mentioned in the Metalink Note - 473153.1.