Oracle Fusion BI发布服务器报告中通过SOAP的重复计划

Question

我正试图使用Oracle BI发布服务器的xmlpserver/services/v2/ScheduleService来安排定期作业。不幸的是，由于没有示例，也没有尝试错误方法的运气，我无法以重复的方式安排报告，但我设法执行了一次。我想了解tu在recurrentExpression、RecurrentExpressionType和repeatCount中放入了什么以使其工作。我想每天n点执行死刑。这是XML:

<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:deliveryChannels>
<v2:ftpOptions>
<v2:item>
<v2:ftpServerName>?</v2:ftpServerName>
<v2:remoteFile>?</v2:remoteFile>
<v2:sftpOption>?</v2:sftpOption>
</v2:item>
</v2:ftpOptions>
</v2:deliveryChannels>
<v2:jobLocale>en_US</v2:jobLocale>
<v2:jobTZ>Etc/UTC</v2:jobTZ>
<v2:mergeOutputOption>false</v2:mergeOutputOption>
<v2:notificationTo>?</v2:notificationTo>
<v2:notifyWhenFailed>true</v2:notifyWhenFailed>
<v2:notifyWhenSkipped>true</v2:notifyWhenSkipped>
<v2:notifyWhenWarning>true</v2:notifyWhenWarning>
<v2:recurrenceExpression>?</v2:recurrenceExpression>
<v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>
<v2:repeatCount>1</v2:repeatCount>
<v2:repeatInterval>86400</v2:repeatInterval>
<v2:reportRequest>
<v2:attributeCalendar>Gregorian</v2:attributeCalendar>
<v2:attributeFormat>Text</v2:attributeFormat>
<v2:attributeLocale>fr</v2:attributeLocale>
<v2:reportAbsolutePath>?</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:saveDataOption>true</v2:saveDataOption>
<v2:saveOutputOption>true</v2:saveOutputOption>
<!--Optional:-->
<v2:startDate>2022-09-23T19:07:00Z</v2:startDate>
<v2:userJobName>test_REPORT</v2:userJobName>
</v2:scheduleRequest>
<v2:userID>?</v2:userID>
<v2:password>?</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>

示例中的许多字段为空，以保护敏感数据。以下是文档链接：https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/scheduleservice.htm#BIPDV323

Answer 1

关于reccurence和cron表达式请参阅此页：https://docs.oracle.com/cd/E12058_01/doc/doc.1014/e12030/cron_expressions.htm
或此：https://docs.aws.amazon.com/glue/latest/dg/monitor-data-warehouse-schedule.html
我所能提供的只是一个工作示例soap消息(BI Publisher 12.2.1.4.0(，它用两个参数将报告安排在某个开始日期。BIP对开始日期格式非常敏感重复次数是一个整数，也是重复间隔(秒(，没有问题。

<?xml version="1.0" encoding="utf-8"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap-env:Body>
<ns0:scheduleReport xmlns:ns0="http://xmlns.oracle.com/oxp/service/v2">
<ns0:scheduleRequest>
<ns0:dataModelUrl>http://full_url_to_datamodel/YourDataModelName.xdm</ns0:dataModelUrl>
<ns0:jobLocale>hr-Hr</ns0:jobLocale>
<ns0:repeatCount>1</ns0:repeatCount>
<ns0:reportRequest>
<ns0:attributeCalendar>Gregorian</ns0:attributeCalendar>
<ns0:attributeFormat>pdf</ns0:attributeFormat>
<ns0:attributeLocale>hr-Hr</ns0:attributeLocale>
<ns0:attributeTemplate>YourTemplateName.rtf</ns0:attributeTemplate>
<ns0:parameterNameValues>
<ns0:listOfParamNameValues>
<ns0:item>
<ns0:name>PARAM_1_NAME</ns0:name>
<ns0:values>
<ns0:item>PARAM_1_VALUE</ns0:item>
</ns0:values>
</ns0:item>
<ns0:item>
<ns0:name>PARAM_2_NAME</ns0:name>
<ns0:values>
<ns0:item>PARAM_2_VALUE</ns0:item>
</ns0:values>
</ns0:item>
</ns0:listOfParamNameValues>
</ns0:parameterNameValues>
<ns0:reportAbsolutePath>/~user/FolderPath/ToYour/Report/YourReportName.xdo</ns0:reportAbsolutePath>
</ns0:reportRequest>
<ns0:scheduleBurstingOption>True</ns0:scheduleBurstingOption>
<ns0:startDate>2020-10-08T09:00:00+02:00</ns0:startDate>
<ns0:userJobName>YOUR_JOB_NAME_2020-09_1</ns0:userJobName>
</ns0:scheduleRequest>
<ns0:userID>your_username</ns0:userID>
<ns0:password>your_password</ns0:password>
</ns0:scheduleReport>
</soap-env:Body>
</soap-env:Envelope>

我花了一些时间才从医生那里收集到这些信息。wsdl中声明的几乎所有类型都很复杂，所以我必须遍历文档才能使其工作。第一件有帮助的事情是从ScheduleService的wsdl文件中提取方法和类型
以下是从wsdl中提取的方法和类型。

/*
Service ( ScheduleService ) tns="http://xmlns.oracle.com/oxp/service/v2"
Prefixes (1)
ns0 = "http://xmlns.oracle.com/oxp/service/v2"
Ports (1):
(ScheduleService)
Methods (41):
cancelSchedule(xs:string jobInstanceID, xs:string userID, xs:string password, )
cancelScheduleInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
deleteJobHistory(xs:string instanceJobID, xs:string userID, xs:string password, )
deleteJobHistoryInSession(xs:string instanceJobID, xs:string bipSessionToken, )
deleteSchedule(xs:string jobInstanceID, xs:string userID, xs:string password, )
deleteScheduleInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
deliveryService(DeliveryRequest deliveryRequest, xs:string userID, xs:string password, )
deliveryServiceInSession(DeliveryRequest deliveryRequest, xs:string bipSessionToken, )
downloadDocumentData(xs:string jobOutputID, xs:string userID, xs:string password, )
downloadDocumentDataInSession(xs:string jobOutputID, xs:string bipSessionToken, )
downloadXMLData(xs:string jobInstanceID, xs:string userID, xs:string password, )
downloadXMLDataInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
getAllJobInstanceIDs(xs:string submittedJobId, xs:string userID, xs:string password, )
getAllScheduledReport(JobFilterProperties filter, xs:int beginIdx, xs:string userID, xs:string password, )
getAllScheduledReportHistory(JobFilterProperties filter, xs:int beginIdx, xs:string userID, xs:string password, )
getAllScheduledReportHistoryInSession(JobFilterProperties filter, xs:int beginIdx, xs:string bipSessionToken, )
getAllScheduledReportInSession(JobFilterProperties filter, xs:int beginIdx, xs:string bipSessionToken, )
getDeliveryServiceDefinition(xs:string userID, xs:string password, )
getDeliveryServiceDefinitionInSession(xs:string bipSessionToken, )
getDocumentData(xs:string jobOutputID, xs:string userID, xs:string password, )
getDocumentDataInSession(xs:string jobOutputID, xs:string bipSessionToken, )
getScheduledJobInfo(xs:string jobInstanceID, xs:string userID, xs:string password, )
getScheduledJobInfoInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
getScheduledReportDeliveryInfo(xs:string jobOutputID, xs:string userID, xs:string password, )
getScheduledReportDeliveryInfoInSession(xs:string jobOutputID, xs:string bipSessionToken, )
getScheduledReportOutputInfo(xs:string jobInstanceID, xs:string userID, xs:string password, )
getScheduledReportOutputInfoInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
getScheduledReportStatus(xs:string scheduledJobID, xs:string userID, xs:string password, )
getScheduledReportStatusInSession(xs:string scheduledJobID, xs:string bipSessionToken, )
getXMLData(xs:string jobInstanceID, xs:string userID, xs:string password, )
getXMLDataInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
purgeJobHistory(xs:string instanceJobID, xs:string userID, xs:string password, )
purgeJobHistoryInSession(xs:string instanceJobID, xs:string bipSessionToken, )
resendScheduledReport(xs:string outputJobID, xs:string userID, xs:string password, )
resendScheduledReportInSession(xs:string outputJobID, xs:string bipSessionToken, )
resumeSchedule(xs:string jobInstanceID, xs:string userID, xs:string password, )
resumeScheduleInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
scheduleReport(ScheduleRequest scheduleRequest, xs:string userID, xs:string password, )
scheduleReportInSession(ScheduleRequest scheduleRequest, xs:string bipSessionToken, )
suspendSchedule(xs:string jobInstanceID, xs:string userID, xs:string password, )
suspendScheduleInSession(xs:string jobInstanceID, xs:string bipSessionToken, )
Types (44):
AccessDeniedException
ArrayOfEMailDeliveryOption
ArrayOfFTPDeliveryOption
ArrayOfFaxDeliveryOption
ArrayOfJobInfo
ArrayOfJobOutput
ArrayOfJobOutputDelivery
ArrayOfLocalDeliveryOption
ArrayOfMetaData
ArrayOfParamNameValue
ArrayOfPrintDeliveryOption
ArrayOfString
ArrayOfWCCDeliveryOption
ArrayOfWebDAVDeliveryOption
BIPDataSource
DeliveryChannels
DeliveryRequest
DeliveryServiceDefinition
EMailDeliveryOption
FTPDeliveryOption
FaxDeliveryOption
FileDataSource
InvalidParametersException
JDBCDataSource
JobDetail
JobFilterProperties
JobInfo
JobInfosList
JobOutput
JobOutputDelivery
JobOutputDeliverysList
JobOutputsList
JobStatus
LocalDeliveryOption
MetaData
MetaDataList
OperationFailedException
ParamNameValue
ParamNameValues
PrintDeliveryOption
ReportRequest
ScheduleRequest
WCCDeliveryOption
WebDAVDeliveryOption
*/