Hi Experts
I'm getting 401 authentication error while calling OAC report using soap web service basic credentials. Please help me how to pass basic credentials like username password and run report.
Hi @learning123 ,
The above link is for Publisher, but as your talk about OAC report, I assume you mean "classic" analyses/dashboards and you are calling the WSDL located at /analytics-ws/saw.dll/wsdl/v12 ?
If that's the case, you need to authenticate first, there is a method for it. The thing is that OAC does use a SSO with IDCS etc., and the webservice should preferably be called using a token instead of your credentials (username/password). Even more so if you have MFA enable: the webservice will not be able to ask you for your authenticator code or whatever form of MFA you have enabled. In that case you should use the token instead to tell the webservice you are authenticated.
Can you do a simple Browser Test:
Navigate to: https://<oac-domain>/xmlpserver/services/v2/ReportService?wsdl If a login prompt appears → enter credentials.
If login fails → credentials invalid for SOAP
If login succeeds → Basic Auth is enabled and working
@Gianni Ceresa thank you, is there a way to authenticate using fusion user name and passport. I could see my OAC instance is using fusion login as well as idcs.. both option is available
as im calling the report using SOAP web service, is it possible to pass this in the basic authentication ?
If you read the specification of the web services, you will see there is one to authenticate and receive a session ID you should then pass to all your requests. That's the historical way to use the web service, before the token was introduced recently.
You can't use just basic authentication, because that isn't something supported by the service (it will be ignored).
You should use the methods of the SAWSessionService service to login and logout when done: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/c_sawsessionservice_service.html#GUID-7FF44E3E-AA62-4411-83DE-AC6DDB1B0A88
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
Hi , I am calling one parameter in another parameter and it is not working. 1st parameter is showing values, while calling the 1st parameter in second it is not showing any values. Regards, Sree Hari M
