Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Trouble using web-service as data source

Summary
Trouble using web-service as data source
Content
OS: RHEL 7.2
BIP 11.1.1.9 enterprise
Flexcube 11.6
Hi Team,
I am trying to integrate a Flexcube API into BI publisher as a data source, but consistently facing issues while trying to do so.
The API I am using is implemented in WSDL form and is populating the method names when trying to build data model using the same.
The Web source definition is as below
server protocol: HTTP
server: IP address of API server
Port: The active port
URL suffix: AppServices/services/XfaceAccountStatementInquiryWrapper?wsdl
Complex type: Yes
WS-security: 2002
Authentication: XML Soap
user/password not required
The Data model, data set properties are as below
Here I get numerous parameters to be set but compulsory parameters have been created and their values set. I dont see an option to exclude the other optional tags, so I have to set the values for them in one way or the other. Hence created a null value parameter "nil" which has been selected from dropdown against each.
When I go to data Tab, I m getting below
soapenv:Envelope
soapenv:Body









faultstring (unknown)
detail
However if I run the same API from command line as a CURL request, it executes and returns proper results.
The curl contains only the mandatory tags.
Please help in identifying the cause of the issue. Let me know if I can provide any more info.
Thanks
Saurabh