Integration

Get Involved. Join the Conversation.

Topic

    Subarna Karmakar
    Rundatamodel for report service
    Topic posted November 7, 2019 by Subarna Karmakar, tagged Cloud, Integration, SOAP, Web Services, Workday 
    17 Views, 2 Comments
    Title:
    Rundatamodel for report service
    Summary:
    Rundatamodel for report service
    Content:

    Hi,

     

    I am trying to invoke a report service for HCM through ICS where providing the person number in the report will fetch the output of the worker . But whilei nvoking the report service I am receiving below error . The report is present in the location correctly

    {http://schemas.oracle.com/bpel/extension}remoteFault - oracle.xdo.webservice.exception.OperationFailedException: PublicReportServiceImpl::generateReportXMLData Failure due to unable to Access and oracle.xdo.servlet.CreateException: Data Model definition not found:/Custom/Human Capital Management/AMT Active Assignment Integration Report.xdo

    Please help.

    Comment

     

    • Subarna Karmakar

      Tried to use SOAP UI to use operation -rundatamodel with the below input

       

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
         <soapenv:Header/>
         <soapenv:Body>
            <v2:runDataModel>
               <v2:reportRequest>
                  <v2:XDOPropertyList>
                     <v2:metaDataList>
                        <!--Zero or more repetitions:-->
                        <v2:item>
                           <v2:metaDataName>?</v2:metaDataName>
                           <v2:metaDataValue>?</v2:metaDataValue>
                        </v2:item>
                     </v2:metaDataList>
                  </v2:XDOPropertyList>
                  <v2:attributeCalendar>?</v2:attributeCalendar>
                  <v2:attributeFormat>?</v2:attributeFormat>
                  <v2:attributeLocale>?</v2:attributeLocale>
                  <v2:attributeTemplate>?</v2:attributeTemplate>
                  <v2:attributeTimezone>?</v2:attributeTimezone>
                  <v2:attributeUILocale>?</v2:attributeUILocale>
                  <v2:byPassCache>?</v2:byPassCache>
                  <v2:dynamicDataSource>
                     <v2:JDBCDataSource>
                        <v2:JDBCDriverClass>?</v2:JDBCDriverClass>
                        <v2:JDBCDriverType>?</v2:JDBCDriverType>
                        <v2:JDBCPassword>?</v2:JDBCPassword>
                        <v2:JDBCURL>?</v2:JDBCURL>
                        <v2:JDBCUserName>?</v2:JDBCUserName>
                        <v2:dataSourceName>?</v2:dataSourceName>
                        <v2:postProcessFunc>?</v2:postProcessFunc>
                        <v2:preProcessFunc>?</v2:preProcessFunc>
                        <v2:useProxyAuth>?</v2:useProxyAuth>
                     </v2:JDBCDataSource>
                     <v2:fileDataSource>
                        <v2:dynamicDataSourcePath>?</v2:dynamicDataSourcePath>
                        <v2:temporaryDataSource>?</v2:temporaryDataSource>
                     </v2:fileDataSource>
                  </v2:dynamicDataSource>
                  <v2:flattenXML>?</v2:flattenXML>
                  <v2:parameterNameValues>
                     <v2:listOfParamNameValues>
                        <!--Zero or more repetitions:-->
                        <v2:item>
                           <v2:UIType>?</v2:UIType>
                           <v2:dataType>?</v2:dataType>
                           <v2:dateFormatString>?</v2:dateFormatString>
                           <v2:dateFrom>?</v2:dateFrom>
                           <v2:dateTo>?</v2:dateTo>
                           <v2:defaultValue>?</v2:defaultValue>
                           <v2:fieldSize>?</v2:fieldSize>
                           <v2:label>?</v2:label>
                           <v2:lovLabels>
                              <!--Zero or more repetitions:-->
                              <v2:item>?</v2:item>
                           </v2:lovLabels>
                           <v2:multiValuesAllowed>?</v2:multiValuesAllowed>
                           <v2:name>P_PERSON_NUMBER</v2:name>
                           <v2:refreshParamOnChange>?</v2:refreshParamOnChange>
                           <v2:selectAll>?</v2:selectAll>
                           <v2:templateParam>?</v2:templateParam>
                           <v2:useNullForAll>?</v2:useNullForAll>
                           <v2:values>
                              <!--Zero or more repetitions:-->
                              <v2:item>29544</v2:item>
                           </v2:values>
                        </v2:item>
                     </v2:listOfParamNameValues>
                  </v2:parameterNameValues>
                  <v2:reportAbsolutePath>/Custom/Integration/AMT Active Assignment Integration Report.xdo</v2:reportAbsolutePath>
                  <v2:reportData>cid:238548358470</v2:reportData>
                  <v2:reportOutputPath>?</v2:reportOutputPath>
                  <v2:reportRawData>?</v2:reportRawData>
                  <v2:sizeOfDataChunkDownload>?</v2:sizeOfDataChunkDownload>
               </v2:reportRequest>
               <v2:userID>INTEGRATION</v2:userID>
               <v2:password>welcome123</v2:password>
            </v2:runDataModel>
         </soapenv:Body>
      </soapenv:Envelope>

       

       

      Reponse: 

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <soapenv:Body>
            <soapenv:Fault>
               <faultcode>soapenv:Server.userException</faultcode>
               <faultstring>java.lang.NumberFormatException: Invalid boolean</faultstring>
               <detail>
                  <ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">lpc8far05026b05.usdc6.oraclecloud.com</ns1:hostname>
               </detail>
            </soapenv:Fault>
         </soapenv:Body>
      </soapenv:Envelope>

       

      What can be done to rectify the error?

      • Hemanth Lakkaraju

        Do you think the request used here is valid - with all "?"s!! Use correct payload. If you don't know the field values to be used, use minimum required values in payload, remove others and try it.

        For eg:  byPassCache is a boolean flag and passing ? is invalid which conforms the error!