Scheduling a BI Report recursively using webservices

User_AT83E

Organization Name

Deloitte

Description

Hi Team,

My Idea here is to schedule BI Reports using web services (SOAP UI)

Use Case and Business Need

The main reason to use this case is : Whenever there is a patch upgrade in production instance, there would be an issue that occurs which would be causing scheduling issues. So, in order to resolve this issue, we would contact client to get the person of contact who can do modifications in production environment so as to reschedule/cancel/delete the report jobs.
This whole process would be a laborious process. So, in order to save time, we propose the below Idea

More details

ScheduleService webservice was used  in SOAP UI  where ReportSchedule method was used to schedule the service
The following payload was schedule the report

<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:emailOptions>
                  <!--Zero or more repetitions:-->
                  <v2:item>
                     <v2:emailFrom>donotreply@sample.com</v2:emailFrom>
                     <v2:emailTo>bobreddy@deloitte.com</v2:emailTo>
                  </v2:item>
               </v2:emailOptions>
            </v2:deliveryChannels>
            <v2:reportRequest>
               <v2:attributeCalendar>Gregorian</v2:attributeCalendar>
               <v2:attributeFormat>PDF</v2:attributeFormat>
               <v2:attributeLocale>en-US</v2:attributeLocale>
               <v2:attributeTemplate>POC_SOAP_UI_Report</v2:attributeTemplate>
               <v2:byPassCache>true</v2:byPassCache>
               <v2:reportAbsolutePath>/Custom/FDX Custom/Interfaces/PTP/POC_SOAP_UI_Report.xdo</v2:reportAbsolutePath>
               <v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
            </v2:reportRequest>
         </v2:scheduleRequest>
         <v2:userID>I*******L</v2:userID>
         <v2:password>B********</v2:password>
      </v2:scheduleReport>
   </soapenv:Body>
</soapenv:Envelope>
 
This request has worked successfully and was able to schedule this report once immediately

To the same payload, few other tags were added such that I can schedule that report  periodically
For example: If requirement was to schedule the report once every 10 minutes between a given start date and end date,
the following payload was used

<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:emailOptions>
                  <!--Zero or more repetitions:-->
                  <v2:item>
                     <v2:emailFrom>donotreply@sample.com</v2:emailFrom>
                     <v2:emailTo>bobreddy@deloitte.com</v2:emailTo>
                  </v2:item>
               </v2:emailOptions>
            </v2:deliveryChannels>
            <v2:endDate>2019-10-14T07:10:00</v2:endDate>
            <v2:recurrenceExpression>0 0/10 * 1/1 * ? *</v2:recurrenceExpression>
            <v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>
            <!--<v2:repeatCount>1</v2:repeatCount>-->
            <!--<v2:repeatInterval></v2:repeatInterval>-->
            <v2:reportRequest>
               <v2:attributeCalendar>Gregorian</v2:attributeCalendar>
               <v2:attributeFormat>PDF</v2:attributeFormat>
               <v2:attributeLocale>en-US</v2:attributeLocale>
               <v2:attributeTemplate>POC_SOAP_UI_Report</v2:attributeTemplate>
               <v2:byPassCache>true</v2:byPassCache>
               <v2:reportAbsolutePath>/Custom/FDX Custom/Interfaces/PTP/POC_SOAP_UI_Report.xdo</v2:reportAbsolutePath>
               <v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
            </v2:reportRequest>
            <v2:startDate>2019-10-14T06:10:00</v2:startDate>
         </v2:scheduleRequest>
         <v2:userID>I*******L</v2:userID>
         <v2:password>********</v2:password>
      </v2:scheduleReport>
   </soapenv:Body>
</soapenv:Envelope>

The scheduling is expected to happen every time on the below time once the scheduling is initiated

1.	Monday, October 14, 2019 6:20 AM
2.	Monday, October 14, 2019 6:30 AM
3.	Monday, October 14, 2019 6:40 AM
4.	Monday, October 14, 2019 6:50 AM
5.	Monday, October 14, 2019 7:00 AM

But the issue here is once the  request is submitted, it is giving a job ID, but there is no scheduled job that is getting created for that ID

Original Idea Number: d253a267fc