-
Unable to access Oracle Analytics Challenge instance – No user returned via correlation policy
Hello, I registered for the Oracle Analytics and AI Challenge 2026 and received both the registration confirmation email and the “Your Oracle Analytics environment is ready” email. However, when I click the “Access Oracle Analytics” link and log in, I receive the following error: Oracle Cloud – oacstrategy Identity domain:…
-
OAC AI Agents - Forecasting and other predictive analytics capabilities
Hi team, I have a quick question regarding the AI Agent created and embedded in Oracle Analytics Cloud (OAC). Does it provide forecasting and/or other predictive analytics capabilities? If yes, could you please share the applicable documentation (link) and guidance on how to work and use those features? Thank you!
-
OAS 2025 to 2026 inplace Upgrade Failing for OPSS, MDS, and IAU Schemas with ‘Invalid DB Role’ Error
We are currently performing an in-place upgrade of Oracle Analytics Server (OAS) from version 2025 (FMW 12.2.1.4.0) to OAS 2026 (14.1.2.0.0) on Oracle Linux 8. During the upgrade process, we executed Upgrade Assistant and select the option “All Schemas Used by a Domain.” Observed Behavior The Examine phase completes…
-
Governance plug-in not downloading Dataflow details
I am using the governance plug-in, and I see no dataflow details downloaded. The SYS_DATAFLOWS is empty. The other 2 excels SYS_DATASOURCES, SYS_WORKBOOKS have data. Is anyone else facing this issue? Please advise.
-
Access
How do I get an access to Reporting and Analytics?
-
Problem with variables in Data Filter in the Semantic Model
Good evening, in the same subject area we have a different beaviour for 2 uses with the same profile: the Data Filter to show only the data available for specific users -> with the SAME profile for different users the filter works properly while for other it doesn't work and the value from the variable in this case shows…
-
OAC conneciton to OTM
Hi Team, We have a requirement of extracting data from OTM into OAC for reporting puposes. Please let me know the options for the same in OAC. Regards, Jahnavi
-
OAC Conditional formatting stops working for some Consumer Roles or Users
Recently a user told me they couldn't see any conditional formatting in your dashboard (Table Objet), but when I log in, it works perfectly. I created a new user account for test, I shared the report with the same role and the formatting was visible OK, but after a few hours it stopped working again! Older versions of the…
-
OAC: Automatically Take Snapshot Using Rest API and Store in OCI Bucket
Manage snapshots using Rest API has become more simpler than earlier. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/manage-snaphots-using-rest-apis.html All steps are similar as mentioned in above link , except "Understand OAuth 2.0 token authentication" . Detailed steps : - Create a storage bucket and a…
-
Shipment Dtl with item and PO dtl with PO nbr and seq_nbr have conflicting invn attributes
Hi ,We are getting this error when trying to create Inbound shipment for PO . When we send payload it is giving this error in input interface "Shipment Dtl with item and PO dtl with PO nbr and seq_nbr have conflicting invn attributes." ThanksKavitha
-
Dashboard prompt for direct database request
Hey all, I have built a direct database request in OAC and I want to create a dashboard prompt that will allow me to choose values based on data in one of the columns in the direct database request. Is that possible to do? I have been trying to do it using a presentation variable but keep getting failed to load error in…
-
Universal KPI Banners for Any OAC Dashboard
SQL Expression Parameters let you build a live KPI banner that sits on any dashboard — independent of its datasets. Use it for company-wide metrics, operational alerts, or sales scorecards that every team needs to see. Examples and step-by-step instructions in the attached document.…
-
AI Agent - Subject Area Usage
Hi, Can we create OAC - AI Agent based on Subject area data. Regards Saroj
-
Getting "Not available due to errors" for Assistant with a Dataflow generated dataset
We are getting the "Not available due to errors" in the Assistant tab in a workbook. If I run the search manually it will refresh. I have tried leaving the the re-crawl on the refresh of the dataset. I have also scheduled the the crawl to refresh automatically and neither will work unless I process the search manually.
-
OAS 2025: Data security related question
Hi, we are using OAS2025, with EBS 12.2.1 OBIA 7.6.4, Oracle 19c on Linux. We have quite a few users who had access to a subject area, they created and saved reports in their 'My Folders'. Now over the years, they moved/transferred and don't have that role(s) which provided access to that subject area but they still have…
-
New security model for Data Flows\ Datasets
Hi- I am creating a workbook using a data flow created dataset. while in development, the workbook, dataflow, and resulting dataset are all in the same folder. Now that I have to deploy the workbook to another folder, do I also need to bring the dataflow and dataset to that new folder as well? I'm still a little confused…
-
Connection to Databricks from Oracle Analytics Server - Fails to load catalog
Trying to connect to data bricks from OAS using SIMBA Spark ODBC driver. In the DSN setup the connection is successful, but when try to refer it from OBIEE admin tool to import metadata, not able to see any catalog folders. Is there any listed steps to achieve this connectivity ?
-
How to connect Sharepoint to Oracle using Odata?
Has anyone successfully used OData to connect SharePoint with Oracle Analytics? If OData isn’t supported or practical, what other recommended or supported approaches have you used to integrate SharePoint data with Oracle Analytics?
-
Data Flows Monitoring in OAC
Hi, Is any one built any program / code to monitor data flows in OAC instance? We're familiar with Job feature, but we've noticed that it doesn't provide deeper insights into certain aspects we're interested in. Specifically, we're looking for more detailed information regarding the execution duration of the latest job,…
-
Urgent Request! - Oracle Analytics AI Assistant Embedding is down automatically
Hello OAC Community .We observed today (26-Feb-2026) our embedded AI Assistant is automatically not being displayed on the web page .This was working fine from last couple of weeks .On the console we're seeing the errors as shown in below screenshot : The embedding page was prepared as per the below OAC documentation (With…
-
OL7 to OL8 Migration for Oracle Analytics Server (7.6) & Oracle Http Server.
Hi All, I am testing OL7 to OL8 Migration for Oracle Analytics Server (7.6) & Oracle Http Server. I was able to verify Oracle Analytics Server(7.6) on OL8. For Oracle Http Server, we are using 12.2.1.4.0 version. when i run the silent installation on OL8, Installation was failing with the missing packages Starting check :…
-
EPM Cloud data(RealTime) and ADW data validation through OAC
Hi Everyone We were able to create a report in OAC using EPM Cloud connectivity. Is there a way to leverage this workbook to validate the data that is loaded into ADW? Our end goal is to validate EPM data against ADW. We have a subject area built on top of ADW that is currently being used, and we want to ensure that the…
-
Custom Tooltip Not Displaying Attribute Values in OAC When Columns Are Hidden
I have observed that the Custom Tooltip in OAC does not display Attribute values when multiple Attribute columns are present, and any one of those Attribute columns is hidden in the Pivot View or Table View. In such cases, the Tooltip only shows the Measure values. Has anyone else encountered this issue? Is there a known…
-
custom layout with shared image background
Hi, we are on Jan 2026 release of OAC DV. Trying to save the custom layout with a custom background of shared image. However, this image is not coming over when trying to select this layout. Any suggestions are welcome to address this.
-
in OAC DV, is there possibility of adding filter based on another analysis?
I am looking for a feature 'Add filter based on another analysis'. It exists in classic BI, we are looking for a similar approach Oracle DV. Please let me know how to achieve this
-
How unsubscribe?
-
Building a union report option via subject area is missing OAC DV.
Building a union report option from Subject Area is missing OAC DV. Please guide how to create a union report in DV
-
RESTAPI－SHIPMENT
I would like to register serial numbers at the time of shipment confirmation by using the REST API. Based on my investigation, it seems that shipment data and its child entities cannot be updated directly, so I am trying to use the “ShipmentTransactionRequests (POST)” endpoint to achieve this. The endpoint is described in…
-
Encountering "Max Rows Query Limit" Error
We’re encountering the [nQSError: 60008] "’Exceeded the maximum query governing rows 2000000 from the database " error while trying to retrieve data for a specific period. Even when reducing the period to 1 day, 1 hour, or 1 minute, we still receive the same error. We’ve observed this issue in two scenarios: Case 1: The…
-
In OAC DV, Do we have an option to enable condition based data actions?
In our Summary report, we have a requirement to enable data action links only to specific row values conditionally.
