My Oracle Support Banner

Why are scheduled Siebel BI Publisher Reports not generating after applying the Siebel FixPack ? (Doc ID 1382647.1)

Last updated on NOVEMBER 28, 2017

Applies to:

Siebel Reports - Version SIA [21229] and later
Information in this document applies to any platform.


Having applied the Siebel FixPack whenever a Scheduled Report is run the report returns "No Data Found".

The standard report generation from the Siebel UI results in correct report generation and is not impacted.

In order to confirm that this behaviour is being encountered a review of the <report_name>.xdo file from the %ORACLE_HOME%\xmlp\XMLP\Reports\SiebelCRMReports\<report_name> folder should be made. This file will include a section for GetReportData_Input which should appear as follows :


If the .xdo file does not show this format and shows a format such as that shown below :


then the scheduled report will most likely return no data and the following error messages may be seen :

In the EAIObjMgr_xxx.log file :

WebSvcInbound WSInboundTrace 3 0000b0964ed80b1c:0 2011-12-02 12:17:50 Executing web service operation 'GetReportData' by calling method 'GetReportData' of business service 'XMLP Data Service'
Executing Operation '&1' by calling method '&2' of business service '&3'

ObjMgrBusServiceLog InvokeMethod 4 0000b0964ed80b1c:0 2011-12-02 12:17:50 Begin: Business Service 'XMLP Data Service' invoke method: 'GetReportData' at 2195d3a8

ObjMgrBusServiceLog Warning 2 0000b0964ed80b1c:0 2011-12-02 12:17:50 (service.cpp (1110)) SBL-DAT-00125: Required in argument 'TimeZone' not supplied for 'GetReportData' method in Business Service 'XMLP Data Service'

ObjMgrBusServiceLog InvokeMethod 4 0000b0964ed80b1c:0 2011-12-02 12:17:50 End: Business Service 'XMLP Data Service' invoke method: 'GetReportData' at 2195d3a8

In the BI Publishers xdo.log file immediately following the scheduled report request :

</soap:Envelope>, XPATH = [/GetReportData_Output/_XmlData/text()]
[120211_122454750][][EXCEPTION] java.lang.NullPointerException
at oracle.apps.xdo.webservice.wsclient.WSClient.findNodeByXPath(
at oracle.apps.xdo.webservice.wsclient.WSClient.sendMessage(
at oracle.apps.xdo.webservice.wsclient.WSClient.invokeWebServiceWithRequest(
at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(
at oracle.apps.xdo.servlet.CoreProcessor.processScheduledRequest(
at oracle.apps.xdo.servlet.CoreProcessor.generateScheduledDocument(
at oracle.apps.xdo.servlet.ReportImpl.renderScheduledJob(
at oracle.apps.xdo.servlet.scheduler.XDOJob.generateReport(
at oracle.apps.xdo.servlet.scheduler.XDOJob.execute(
at org.quartz.simpl.SimpleThreadPool$


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.