-
Need help - How to show 0 in case null/blank values in row AND how to rename Grand Total column name
I am creating report in DV which were previously created using Oracle Classic BI. When creating the table, there are columns where it is showing blank in cells where there are no data. However, in Classic BI the blank cells are shown as 0. When I checked the column properties in Classic BI, it has added Custom format as…
-
OAC dashboard performance issue
Hi, We have migrated from OBIEE 12c to OAC. We are seeing a performance issue with one dashboard after migration in OAC. It takes 5 mins to load the report. In OBIEE it returns in seconds. Are there any sepecific settings in OAC to optimize the query/filters? Thanks Padmaja
-
Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Databas
Summary Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Database Cloud Service) Content [Urgent] Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a on-premise database? or DBCS?(Database Cloud Service)? My customer wants to connect DVCS directly with the existing…
-
Unable to create OAC connection to new ADW but connection from SQLDeveloper works fine
I created a new ADW instance to be the target of an OAC Data Flow. ADW creation was successful, and I can connect to the new ADW using SQLDeveloper from my on-prem machine. When I try to create the ADW connection in OAC using those same connection details/wallet file I get "Failed to save the connection. Invalid connection…
-
Triggers being triggered by Data Flow "Save Data" to Database Table - How many times?
Question about saving data from DV via the Save Data to an existing Database Table with a trigger set on it: Let's say you're writing a data flow dataset that will ultimately write 50 records to a table "TBL_SENT_FILES". That table has an after insert trigger on it to do some sort of task. Will that trigger trigger once,…
-
How can i connect from BI client windows to BI Server on linux
Installed: On Server Linux Red Hat 8.3 LINUX.X64_19c_DB Weblogic : 12.2.1.3.0 OBIEE : 12.2.1.4.0 2. On Client Window Server 2022 bi_client_12.2.1.4.0 Everything installed ok, but on step create ODBC, dns test error. So i cannot login BI Admin Online mode. Pics on attached files included error log. Have you encountered this…
-
Fusion SR Attachments: Missing UCM Content ID (DM_DOCUMENT_ID) for UI-Uploaded Files in BI Publisher
I am working on an Oracle Fusion (Service/CRM) requirement where I need to display Service Request attachments in a BI Publisher report along with their UCM details, specifically the content ID (dm_document_id / dDocName) and version ID (dm_version_number) to construct GET_FILE URLs. I am querying FND_ATTACHED_DOCUMENTS…
-
In OAC DV, Do we have an option to show condition based Grand totals in Pivot table?
Our requirement is to enable dimension attribute value specific grand totals in Pivot table. For example: When we enable grand total on pivot table visualization it shows grand totals for all values of columns. We wanted to enable totals only for specific values. Is there a way to achieve this in DV?
-
How to utilise an unbroken time series in a visualisation?
We have a requirement to produce a Pivot Visualisation that includes an unbroken series of dates, from a filterable period, and the value of whatever measure is relevant. For example, in a period of 16/03/26 - 22/03/26 being able to see the number of activities a Resource has handled, including dates when the value is…
-
How to create subfolders in the semantic layer
Hello, I created a semantic layer in OAS where the presentation layer shows 3 table names with fields inside them. When the user opens a new workbook, he see 3 folders - account + time + credit cards, each folder containing a table with its fields. Is it possible to create subfolders? For example, inside an accounts…
-
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.
-
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…
-
How to set log level in OAS for semantic modeler?
Hi, I am trying to set the global/session log level within the Semantic Model for my OAS instance. I attempted to use the same method as the Admin Tool Gather and Analyze Query Logs but it doesn't seem to take effect. I found two articles from last year regarding this limitation, but I'm not certain if Oracle has made any…
-
How to edit Color of a Series in Chart
Hi, Hoping to gain some wisdom from you all. I want to graph Year over Year sales in Netsuite using a Workbook. My initial idea was to have bars for current year and area for last year sales, however, I wasn't able to do that. The best I could do is a Series for Last year and a Series for Current year. I thought that by…
-
Elasticsearch or Opensearch
Hi, Can I use (connect as datasource or dataflow) Elasticsearch or Opensearch in OAC? Thanks
-
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.
-
0Auth2 E-Mail with Oracle Analytics Server 8.2?
Hi Friends! I've managed to get my head around the patch vs upgrade issue. I feel dumb. That said - I have a new issue I'm troubleshooting. I'm trying to get e-mail authentication working with our office365 server. smtp.office365.com:587 using STARTTLS. I've configured & tested the Tenant, Secret & Client ID's using…
-
Unable to find PATCH method in Salesperson Reference Accounts REST Endpoints
Hi , I need to update the Salesperson reference account segments, but I’m unable to find the PATCH method in the Oracle documentation. REST API for Oracle Fusion Cloud Financials - Salesperson Reference Accounts REST Endpoints
-
Using LOCATE() with Wildcards
Is it possible to use LOCATE(), or a similar function, with wildcards? For example, if i'm searching in a string for '%N.___.3__%'. Is it possible to use an existing function to find and extract the value using SUBSTRING()?
-
Oracle Analytics 6.4 >> 7.6 >> 8.2 SPB Question
Hello, Long time user - many time poster. Doing phase precheck for 7.6 & 8.2 SPB from OAS 6.4 // 35608828;OAS STACK PATCH BUNDLE 6.4.0.0.230715 (Patch 35607281) [03/20/2026 10:01:28] - [ERROR] - [preReqCheck] : [239]- OBI component e:\Oracle\Middleware\Oracle_Home\inventory\Components\oracle.bi.publisher\12.2.7.6.1 is not…
-
OAS 2025 client admin tool shuts down
Hi, I have upgraded OAS 2024 to OAS 2025 (8.2) with all the patches I could find and everything seems fine. Instalation is on Windows server. I have installed also corresponding OAS client, setup ODBC connections and everything works ok. The issue is when I try to Import Metadata or view data on physical table……
-
Agent AI Oracle Analytics
Hello Team, I am trying to create an agent AI on oac using a dataset uploaded in the dv section. I created successfully an agent, but when I try to ask a question, the agent doesn't work. I can't see the dataset fields on the following section: How can I solve this problem? Regards
-
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.
-
P2T BICC
Hello! I’m currently involved in a project focused on data extraction via BICC from Oracle Fusion ERP. We have a P2T (Production to Test) process planned, where the Production environment will be copied into the Development environment. At the moment, we have extraction jobs configured in the Development environment, but…
-
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!
-
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…