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
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
