Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Configure web service source to load data from Fusion BI Publisher

Accepted answer
234
Views
7
Comments
lorenzo.casucci
lorenzo.casucci Rank 1 - Community Starter
edited June 2024 in Oracle Analytics Cloud and Server

I receive an error when using Fusion BI Publisher as a web service source

java.lang.NullPointerException

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Hi @user13125124,

    The link you provided is for the FA / OTBI version of BI Publisher.

    If you want to use an SSL certificate for the Web Serviceconnection, upload the SSL certificate in Upload Center before you define the connection to the data source. BIPublisher supports only the basic authentication. This does not support connection to Fusion Apps web services that require WSDL policies. The data returned from web service call should be valid XML format.

    Regards,

    John

Answers

  • BalagurunathanBagavathy-Oracle
    BalagurunathanBagavathy-Oracle Rank 6 - Analytics Lead

    Hi @user13125124 Please explain the issue a bit more. Are you trying to create an OAC DV connection of REST API type? If so, which is the webservice that you are trying to call?

  • lorenzo.casucci
    lorenzo.casucci Rank 1 - Community Starter

    Yes

    I'm trying to connect to Fusion Cloud Erp BIP Report to create a custom integration with external data.

    I did try with SOAP UI calling the same end point and it works!!

    https://fa-erci-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSService

    On OAC Web Service option data model execution gives

    java.lang.NullPointerException

  • BalagurunathanBagavathy-Oracle
    BalagurunathanBagavathy-Oracle Rank 6 - Analytics Lead

    @user13125124 Please access BIP Administration page and navigate to Runtime Configuration → Properties and check if Webservice optimization is set to True.

  • lorenzo.casucci
    lorenzo.casucci Rank 1 - Community Starter

    Hi

    I did try to configure Webservice optimization but no effect

  • Namrata Bhan-Oracle
    Namrata Bhan-Oracle Mod

    Hi @user13125124,

    Could you please mark the appropriate answer as "accepted" in this thread?

    This will allow other forum users to benefit from this thread as it will showcase and highlight the pertinent and valid answers, thereby allowing for a faster problem solution for other users experiencing the same issues as yourself.

    Thanks,

    Namrata

  • lorenzo.casucci
    lorenzo.casucci Rank 1 - Community Starter

    Thanks John

    I do not understand if I need to call WSDL service or REST API via HTTPS.

    As I know REST API is not supported on FA Cloud so I need to go through WSDL.

    Do you know how can I retrieve the ssl certificate from Fusion?

    Why is the SOAP Client working? In this configuration I'm using basic auth.

    Thanks

    Lorenzo