Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fusion BIP Report With Given File Name Issue

Received Response
93
Views
5
Comments

Summary

Fusion BIP Report With Given File Name Issue

Content

Objective:
Initiate BIP report, get the Asynch report output file into UCM with the given file name for Fusion  HCM / ERP.

WSDL used:
https://<HOST:PORT>/xmlpserver/services/ScheduleReportWSSService?wsdl

Operation used:
    scheduleReport

Issue faced:
When we invoke the report without <deliveryChannels> option given below where we actually provide the require file (TEST_FILE_BIP.txt) name it is working.

But when we invoke with <deliveryChannels> options in the request payload it is not working and we are getting the below exception

        <deliveryChannels>
          <wccOptions>
            <item>
              <WCCAccount>hcm$/dataloader$/export$</WCCAccount>
              <WCCAuthor>TEST_USER</WCCAuthor>
              <WCCFileName>TEST_FILE_BIP.txt</WCCFileName>
              <WCCIncludeMetadata>false</WCCIncludeMetadata>
              <WCCSecurityGroup>FAFusionImportExport</WCCSecurityGroup>
              <WCCServerName>TEST_UCM_SERVER</WCCServerName>
              <WCCTitle>TEST_FILE_BIP.txt</WCCTitle>
            </item>
          </wccOptions>
        </deliveryChannels>

Exception:
        <env:Fault>
             <env:Code>
                <env:Value>env:Receiver</env:Value>
             </env:Code>
             <env:Reason>
                <env:Text xml:lang="en-US">java.lang.NullPointerException</env:Text>
             </env:Reason>
          </env:Fault>

Detail Fault

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope"&gt;
   <env:Header/>
   <env:Body>
      <env:Fault>
         <env:Code>
            <env:Value>env:Receiver</env:Value>
         </env:Code>
         <env:Reason>
            <env:Text xml:lang="en-US">ScheduleServiceImpl::checkOwnerPermission failed due to process job [132709] oracle.xdo.servlet.scheduler.ProcessingException: java.lang.NullPointerException:</env:Text>
         </env:Reason>
         <env:Detail>
            <InvalidParametersException xmlns="http://xmlns.oracle.com/oxp/service/ScheduleReportService"&gt;
               <Message xmlns="">ScheduleServiceImpl::checkOwnerPermission failed due to process job [132709] oracle.xdo.servlet.scheduler.ProcessingException: java.lang.NullPointerException:</Message>
            </InvalidParametersException>
         </env:Detail>
      </env:Fault>
   </env:Body>
</env:Envelope>


Please let us know if anything we missed, or some wrong values are passed for the request.

Regards,
Srini

Answers

  • Suren Danu
    Suren Danu Rank 1 - Community Starter

    Hi Srini

    Hope you were able to fix this, if yes can you share the resolution detail pls. We are getting the similar error so any help would be appreciated.

    Thank you

    Suren

  • Srinivasa Vallabha-Oracle
    Srinivasa Vallabha-Oracle Rank 1 - Community Starter

    Hi Suren

    It is solved by adding proper deliveryChannels values (which is configured in Fusion)

     <tns:deliveryChannels>
                      <tns:wccOptions>
                         <tns:item>
                            <tns:WCCFileName>TEST_File.txt</tns:WCCFileName>
                            <tns:WCCIncludeMetadata>false</tns:WCCIncludeMetadata>
                            <tns:WCCSecurityGroup>FAFusionImportExport</tns:WCCSecurityGroup>
                            <tns:WCCServerName>WCC_USER_NAME</tns:WCCServerName>
                            <tns:WCCTitle>TEST_File.txt</tns:WCCTitle>
                         </tns:item>
                      </tns:wccOptions>
                   </tns:deliveryChannels>

    Regadrs,

    Srini

  • Srinivasa Vallabha-Oracle
    Srinivasa Vallabha-Oracle Rank 1 - Community Starter

    Hi Suren

    It is solved by adding proper deliveryChannels values (which is configured in Fusion)

     <tns:deliveryChannels>
                      <tns:wccOptions>
                         <tns:item>
                            <tns:WCCFileName>TEST_File.txt</tns:WCCFileName>
                            <tns:WCCIncludeMetadata>false</tns:WCCIncludeMetadata>
                            <tns:WCCSecurityGroup>FAFusionImportExport</tns:WCCSecurityGroup>
                            <tns:WCCServerName>WCC_USER_NAME</tns:WCCServerName>
                            <tns:WCCTitle>TEST_File.txt</tns:WCCTitle>
                         </tns:item>
                      </tns:wccOptions>
                   </tns:deliveryChannels>

    Regards,

    Srini

  • Suren Danu
    Suren Danu Rank 1 - Community Starter

    Thanks Srini

    The only difference I see that WCCAccount is not there on your working model. Is that the only change you made; not sure if I am missing anything.

    I am actually giving all values as they are configured in fusion but still getting the same error. 

    Note - trying out few other things as well. 

    Thanks

    Suren

  • kmanda
    kmanda Rank 3 - Community Apprentice

    Hi Suren,

    Did this ever work for you ? SOAPUi protected service ScheduleReportWSSService with Delivery channels is not working.

     

    Thanks