Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher scheduleService v2 -scheduleReport

Hello everyone,
I facing a problem when trying scheduling a report using SOAP scheduleService v2.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
<soapenv:Header/>
<soapenv:Body>
<v2:scheduleReport>
<v2:scheduleRequest>
<v2:dataModelUrl>Custom/Financials/Receivables/SPH AR - Invoice/SPH_AR_INVOICE_DM.xdm</v2:dataModelUrl>
<v2:deliveryChannels>
<v2:wccOptions>
<v2:item>
<v2:WCCFileName>AR_INVOICE</v2:WCCFileName>
<v2:WCCFolderPath>/Contribution Folders/CRM/SPH Invoice</v2:WCCFolderPath>
<v2:WCCSecurityGroup>CRMStage</v2:WCCSecurityGroup>
<v2:WCCServerName>FA_UCM_PROVISIONED</v2:WCCServerName>
<v2:WCCTitle>SPH_AR_INVOICE</v2:WCCTitle>
</v2:item>
</v2:wccOptions>
</v2:deliveryChannels>
<v2:reportRequest>
<v2:attributeFormat>pdf</v2:attributeFormat>
<v2:parameterNameValues>
<v2:listOfParamNameValues>
<v2:item>
<v2:name>P_BU_ID</v2:name>
<v2:values>
<v2:item>300000002579760</v2:item>
</v2:values>
</v2:item>
<v2:item>
<v2:name>P_OPBAL</v2:name>
<v2:values>
<v2:item>NO</v2:item>
</v2:values>
</v2:item>
<v2:item>
<v2:name>PERIODEAWAL</v2:name>
<v2:values>
<v2:item>2023-06-01</v2:item>
</v2:values>
</v2:item>
<v2:item>
<v2:name>PERIODEAKHIR</v2:name>
<v2:values>
<v2:item>2023-06-30</v2:item>
</v2:values>
</v2:item>
</v2:listOfParamNameValues>
</v2:parameterNameValues>
<v2:reportAbsolutePath>/Custom/Financials/Receivables/AR - Invoice/AR - Invoice.xdo</v2:reportAbsolutePath>
</v2:reportRequest>
<v2:saveDataOption>false</v2:saveDataOption>
<v2:saveOutputOption>true</v2:saveOutputOption>
<v2:schedulePublicOption>false</v2:schedulePublicOption>
<v2:startDate>SYSDATE</v2:startDate>
<v2:endDate>2023-07-22T08:54:41Z</v2:endDate>
<v2:userJobDesc>SPH_AR_INVOICE</v2:userJobDesc>
<v2:userJobName>SPH_AR_INVOICE</v2:userJobName>
<v2:recurrenceExpression>0 0/5 * * * ?</v2:recurrenceExpression>
<v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>
</v2:scheduleRequest>
<v2:userID>naamanyulianto</v2:userID>
<v2:password>febo@345</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>
The soapUI message and error message am getting while scheduling a report ScheduleServiceImpl::scheduleReport failure due to: null.
Best Answer
-
I create an SR about this problem and turns out it is not possible to create recurring jobs (recurrenceExpression) using web services.
0