Problem in configuring BI report in OTM 6.0

[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]

Re: Problem in configuring BI report in OTM 6.0

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

[kkchopra]

Re: Problem in configuring BI report in OTM 6.0

Hi,

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


Cheers,
Kamleshwar Chopra

[l_kator]

Re: Problem in configuring BI report in OTM 6.0

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

[kkchopra]

Re: Problem in configuring BI report in OTM 6.0

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]

Re: Problem in configuring BI report in OTM 6.0

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]

Re: Problem in configuring BI report in OTM 6.0

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]

Re: Problem in configuring BI report in OTM 6.0

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

[kkchopra]

Re: Problem in configuring BI report in OTM 6.0

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]

Re: Problem in configuring BI report in OTM 6.0

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

[l_kator]

Re: Problem in configuring BI report in OTM 6.0

Note about publisher. But you ask about OTM6
The precustomized reports work?
You have separately installed BIP? You can check up as in it your templates works?

[kkchopra]

Re: Problem in configuring BI report in OTM 6.0

Hello,

Actually I dont have separate installation of BI Pub but it seems internally OTM code is referring to the same BI pub shared files or utilities since here we are playing with RTF files. As you can see in the error log it say conversion of RTF to XSL failed.

Cheers,
Kamleshwar

[xiaojia0820]

Re: Problem in configuring BI report in OTM 6.0

kkchopra, i'd like to know whether your problem has been fixed. im experiencing the same issue on OTM6 too. Please let me know if you've already got a solution.