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
92
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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • 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

  • 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

  • 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

  • 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

  • Rank 3 - Community Apprentice

    Hi Suren,

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

     

    Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.