Recurring Schedule in Oracle Fusion BI Publisher Reports via SOAP

Viewed 20

I am attempting to use xmlpserver/services/v2/ScheduleService of the Oracle BI Publisher to schedule a recurring job. Unfortunately, with no examples and no luck with try and error method, I can't schedule a report in a recurring manner, I manage, however, to execute it once. I want to understand what tu put in recurrenceExpression, recurrenceExpressionType, repeatCount, repeatInterval, startDate to make it work. I am looking for a daily execution at n o'clock. Here is the 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>

Many fields in the example are blank to protect sensitive data. Here is the link to the documentation: https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/scheduleservice.htm#BIPDV323

0 Answers
Related