-
Grand Total Mismatch Issue in OAS
Hello everyone, I'm having trouble understanding why my grand total is showing the wrong number when I sum the values in my rows. The column named "SIT. PC CALC" shows descriptions based on my sales — specifically, whether they are pending ("PENDENTE" in Portuguese) or not pending. The "QTD. PC" column represents the…
-
OAC Sequence failing due to data set not found
Hi Team, We are facing the below issue when the scheduled OAC sequence fails. We are unable to see this particular dataset under Data → Dataset folder. However, when we check the dataset through Content Management in the OAC Console, the dataset is visible there. Could you please help us understand what changes or steps…
-
How to make a Sequence run sequentially?
I feel this used to work the way I expect, so maybe it's a recent change (bug) - but I want to confirm my own understanding before I report anything. I want to use a Sequence to run a list of data flows. I expect each to run through to completion before the next one begins. To do this I've turn on "ordered" in the design.…
-
OAC DV - Download data button on canvas 1 which exports data as a csv from another canvas
In OAC DV, I am trying to achieve data export from a canvas by clicking on a download button on canvas 1. On clicking, I should be able to download the data as csv from another canvas that has a table visualisation. I have tried multiple approaches, but so far has only been able to achieve the navigation and not the…
-
OAC DV, Do we have any feature to have saved customization in DV as similar to Classic BI dashboards
In OAC DV, Do we have any feature in DV workbooks to have saved customization as similar to Classic BI dashboards?
-
Remove recipients from agents via command line?
We are having hundreds of agents which contain e.g. outdated email addresses and/or inactive AD users (due to different reasons). Now want to fully remove the recipients from the list of recipients. Within the xml I noticed two tags, specificRecipients and emailRecipients. Example: unsafe:saw:specificRecipients <saw:user…
-
Updating SSL certificates in Java Keystores
Hello, It is that time of year for us to renew our expiring SSL certificates used in Weblogic for our Oracle Analytics Server environment. We have 2 keystores (identity and trust) plus 2 other keystores where certs are added. Each keystore hosts a full chain of certs: base, root, interm1, and interm2. What approach do…
-
OAC DV, Do we have any feature available to set canvas level access permission to different roles?
In OAC DV, Do we have any feature available to set canvas level access permission to different roles
-
Issues when trying to apply patch 39023318
Hello, With the April CPU delayed, I'm try resolve a critical vulnerability that turns up in security scans, per CVE-2026-21992. This page and the scans say to apply patch 39023318. However, when I try to apply this patch, I get the following message: Skip patch 39023318 from list of patches to apply: This patch is skipped…
-
OAC domain type migration Oracle Identity Cloud Service - Enterprise User - User per month to Oracle
If we upgrade OAC domain type license from Oracle Identity Cloud Service - Enterprise User - User per month to Oracle apps premium .. What are the action items to take before migrate the license and is any impact on existing RLS(Row level security) and SSO configurations ?
-
Can we use more than one dataset when using AI Agents?
Is it possible to use more than one dataset when using AI Agents? It is possible with AI Assistant. Is the feature available with AI Agents? If not, will it be made available in future updates? Thank you!
-
How to Enable Indexing on CSV Datasets? Getting Error Everytime
Want to enable AI Assitant feature on workbooks, We have all rights, seen all documentations & related videos on official channel, not missing a single step,, Also try in Inspect>Search>Scope> Manual + Recommendation settings but the changes saved, during Run facing the error. We have tried on small CSVs like 05 rows of…
-
How to apply EBS value sets security on reports?
Hi, In Oracle Analytics we have created reports getting data from Oracle EBS using connection. Now how we can apply user level access as per security rules assigned in Oracle EBS R12 in these reports as well. So if a user is of company 01 shall only view data of 01 of company segment and other user if of 02 shall be…
-
Oracle Analytics Mobile (Android) – Application Performance is Very Slow
Dear All, We are currently facing an issue with Oracle Analytics Mobile on Android. None of the dashboards or reports are loading successfully , the application keeps showing the loading screen indefinitely without rendering the content. Has anyone else encountered this problem, and are there recommended fixes or…
-
CPU APRIL-2026 PATCH FOR OBIEE 12.2.1.4.0
Will there be any CPU patch OBI SPBAT for OBIEE 12.2.1.4. this cycle? The product is in prem support til end of 2026 but it is completely absent from Oracle Analytics - Critical Patch Update (CPU) Program April 2026 Patch Availability Document (PAD) KA1576 & it is still showing JAN patches on the Advisor: Critical Patch…
-
Is it possible to use Parameters to control the Format applied to dates?
There's an interesting blog/video that shows how to use a combination of Parameters and Calculations to create "Dynamic Filters". Such as having a User be able to select that they wish to view the data by Month or by Week and, functionally, it works. My only frustration with the result is the format of the Date applied to…
-
OAS Admin Tool Connection Issue with Postgresql Database
Hi All, In our company we need to connect Cloudberry database via OAS 8.2 Admin tool. I added the postgresql jar file under \lib directory and restart the servers. After on admin tool, create a new datase and add a new connection pool. However in the connection pool page, I can not select JBDC as database type. As you can…
-
Forecast Does Not Work in DV - Other Timeseries Functions Work
Hi. I encounter this error when I drag Forecast into the Data Visauliser Workbook: State: HY000. Code: 22073. [nQSError: 22073] Internal Error: (Generation of physical plan for dimension query failed with (HY000) State: HY000. Code: 42064. [nQSError: 42064] Incorrect dimension specified for TimeDimSeqNum function.…
-
Semantic Model Migration: Hierarchy (logical dimension) based on two logical tables
This is probably going to raise some eyebrows asking this question, but is there a way to turn off this check when importing a model from an RPD to Semantic Modeler? I'm certain that the answer is NO, but thought I'd ask anyway. I understand why it's there, and why it's needed. However, we have some a couple of rat's nests…
-
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.
-
Export OAS data visualization charts to excel
-
Roles associated to groups don't work in OAC
Hello Team, We're experiencing issues accessing the Oracle Analytics Cloud instance using a custom application role, for example, R_1 associated with the GRP_1 group. We performed the following steps: - created a group on Oracle Cloud Infrastructure - created an application role in the OAC console - associated the group…
-
How to expand on year to see months on OAS
Hello everyone, I appreciate your time in answering my question in advance. Quick question: I'd like to visualize my sales based on year, but I'd also like to allow users to have something like an arrow to click on and then show the months, and then click on the months and see the days. I have my time dimension all set on…
-
how to change status of agents Enable/ Disable in oracle Analytics cloud (OAC)
We have 200+ agents we need to change the status of agent from Enable to disable . Scheduler is already Suspended. please help me on this how can we achieve this.
-
Step by Step Row Counts in OAS Data Flow?
Is there any straightforward way for a Non-Admin user (therefore no easy access to backend logs) to see how many rows are being manipulated in any given step of a Data Flow that they are working with? This functionality is fairly easily available in similar competing products, and our users are clamoring for it, but we…
-
Does OAC Gantt visualization have ability to add columns of data in chart?
I'm trying to create a Gantt visualization in OAC ODV that looks like the configuration in the snapshot below. All the columns are in the source data except the Days column, which I created using the timestampdiff function. I found something online that mentioned combining a Gantt and Table visualization but couldn't…
-
print bar code
-
Patch Oracle DB Client
I have OBI installation 12.2.1.4 with the 19c installed. How do I patch the DB client of this Installation? Thanks in advance
-
Not being able to generate a "AGO" function on OAS
Hello everyone, I appreciate your time in answering my question in advance. I am currently using the Oracle BI Administration Tool version 12.2.1.4.0 to upload databases to my Oracle Analytics Server. My question is: I am not able to generate an AGO function on my Analytics Server. The problem is probably on the OBIEE…
-
OAS 2025 DV - Data Labels Inside Bars with Bar Chart Visualizations
I am working with a horizontal bar chart in DV with an amount field for my X-Axis and programs for my Y-Axis. I see that I can create and adjust data labels for the amount with no problem and move the data label inside the bar, but again this is only for the amount / field on the X-Axis. I don't see a feature like this…
