BI Publisher scheduleService v2 -scheduleReport

Naaman Yulianto

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.

Naaman Yulianto

I create an SR about this problem and turns out it is not possible to create recurring jobs (recurrenceExpression) using web services.