-
Data Flow writing to Dataset tables (July update? Bug?)
We've had some data flows configured to give self-service management over what used to be a complex ETL process. Several of these "broke" recently, generating errors and all kinds of issues. After extensive research, we've found that the option to Save to a Dataset Table used to save the mentioned table as its own dataset.…
-
OAS to OAC schedule report parameters question
So in OAS you put dynamic parameters in the SQL. Create the report and when you go to schedule the report, you select the parameters in the General Tab. So you can use one report and create multiple schedules off one report HOW do you do this in OAC??????
-
Arabic translations in the semantic models presentation layer?
Hi, In OAS after creating Subject Areas now if we need to add Arabic translation for each column then what are the steps? Is there any standard table available in which we can upload or we need to create custom table or if there is any other standard way which I am missing. Thanks
-
Re the Announcement OAC - TLS 1.0 and TLS 1.1 Desupport for Oracle Database Connections [SEP 2026]
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
-
How do we know how many rows a DF has processed/loaded?
When I look at a DF log, I see the below. No of rows successfully loaded is always 0. Where else can this information be found? "Job Type": "DATAFLOW", "Name": "XXXXX", "Number of Rows Successfully Loaded": "0", "Number of Tasks": "1", "Request Type": "Scheduled", "Status": "Completed" Thanks, Usha
-
error in updating analysis via SOAP in Oracle Analytics server
Hi, i am trying to update direct query analysis in Oracle Analytical server using SOAP. in excel file i have analysis name, old sql, new sql, old connection and new connection. But when i try to write back the analysis or create the backup of it, it is failing. getting below error Probing writeObjects endpoint … ❌…
-
OAS query filter with calculated field. Getting Bulk fetch failed.
have a calculated column that has bit more complex condition formula and i put filter items to use it as filter column that caused the error --Bulk fetch failed. So i put the calculated formula into two separated columns and put filters on them.. it's working now. I am just curious that complicated calculated column (not…
-
Enable Secure OAC Report Embedding with Seamless Authentication and User-Level Data Access
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
-
Siebel CRM 26.x and Oracle Analytics Server 2026 Compatibility Confirmation
Hi Team, I would like to confirm the supported compatibility between Siebel CRM 26.x and Oracle Analytics Server 2026? is it certified ? We currently on the upgrade process to Siebel CRM 26.x with an existing OBIEE environment, and we are evaluating the migration from OBIEE to Oracle Analytics Server 2026. which will be…
-
OAS 2026 DV Workbook Metadata via REST APIs
Hi Oracle Analytics Community, I'm exploring OAS 2026 REST APIs for workbook governance and metadata analysis. For a DV workbook, can the available APIs expose enough metadata to programmatically retrieve: Formulas / calculated measures Filters (workbook & visualization level) Aggregation grain Temporal logic (date fields,…
-
OAS 2026 SSO/SAML Configuration Documentation
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…
-
Historical Reporting in OAC
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…
-
How are OAC AI Agent tokens charged as AIDP units, and what guardrails control model usage?
Hi everyone, with the July patch changes, could someone clarify how OAC AI Agent tokens are being mapped/used as AIDP units for chargeback purposes? Specifically: What’s the charging model now (e.g., how tokens translate into AIDP units, and what gets counted)? What guardrails are in place (or recommended) to control usage…
-
Oracle EBS responsiblity as Role in BIP reports folder in OAS
Hi, Kindly suggest if in OAS BIP reports we need to apply access security on folder based on Oracle EBS authentication and EBS responsibity need to be folder role so when user will login if he/she will have relevant responsiblity assigned then folder access will be there. My challenge is EBS auth I am able to configure in…
-
Trying to average a calculation row in a table
The difference column is a calculation, and I would like to average that row.
-
Complex filter issue. How do I do this
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'') ) ),…
-
Oracle Analytics Server roadmap for Java 25 certification
Hi Oracle Community, Our product standard is moving toward Java 25 across all components. Could you please share whether Oracle Analytics Server is planned to support and certify Java 25? Specifically, we would appreciate guidance on: The expected OAS release/version that will certify Java 25 The anticipated timeline or…
-
Facts of different granularity and unbalanced hierarchy
Hi gurus, We need to model the following situation in the OBIEE/OAS repository. The main dimensions are RISK and ORGANIZATION. The indicators are the number of EMPLOYEES EXPOSED to risks and the number of EMPLOYEES (STAFF) per node in the ORGANIZATION. The level of granularity is therefore different for these two…
-
Is there a supported method in OAS 2026 to suppress or disable the "Drill to Attribute/Hierarchy"?
Hi Everyone, We're running into a challenge in OAS 2026 with Data Visualization (DV) workbooks embedded in Classic Answers dashboards. Our requirement is to: Allow the embedded DV workbook to respond to Answers dashboard prompts. Prevent users from accessing the "Drill to Attribute/Hierarchy..." option from the right-click…
-
Parameter Referencing is not working in OACS DV
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
-
Oracle analytics rest apis
Hi, i have installed oracle analytics o2026 n my local machine and it is working and running fine. i want use its rest apis via python. but i came to know that web tier is must for this. so i installed web tier as well. now it is working fine http://localhost:7777/analytics/saw.dll?bieehome&startPage=1 also. but i am…
-
Email Scheduler Failing when Sending Excel Files
I am getting a general error when my workbook's scheduled email tries to send out an excel file (See below error). I have tested and successfully send a scheduled email that sends a PDF - so I am wondering if there is an issue with sending excel files currently? It worked fine until this morning:
-
OAC Client Admin Tool
Hi, do we have any version of OAC client Admin tool to work on RPD. If any links please share thanks.
-
Oracle OAS 2024 integrate with MSAD and DV console
we have configure ActiveDirecroryProvider , and it works, users/groups shown in weblogic console But these MSAD users/groups are not shown in DV console…
-
Runcat replace doesn´t work if input file contains special characters / German umlauts
I am trying to change the agent setting "Run as" via the runcat command. The path to the agent contains special characters and/ or German umlauts. Example command: /mypath/runcat.sh -cmd replace -inputFile "/mypath/replace_RunAsSpecifiedUser.xml" -folderFromFile "/path/folders.txt" -online…
-
Need to apply security based on logged in user in subject areas?
Hi, In on premises oracle analytics DV 2026 connected with Oracle EBS GL need to apply GL security rules so want to know in analytics any session variable is there to get currently logged in user to used in queries? If any standard way is possible please also share or using SQL then need user name to be in variable. thanks
-
OAC REST API Dataset – intermittent refresh failures with “nQSError: 47123 Invalid connection detail
We are experiencing an intermittent refresh issue with an Oracle Analytics Cloud dataset that uses a REST API (Preview) connection. The dataset is used in a workbook join to apply user visibility/security filtering. It retrieves two fields from a Fusion REST endpoint: UserName SecurityContextValue The refresh behavior is…
-
Custom SSO with /xmlpserver Sign Out not working
We have implemented a custom SSO solution for OAS 8.2 using Oracle HTTP Server (OHS), Shibboleth, and Microsoft Azure Entra ID. User authentication is working successfully. However, we are encountering an issue with the sign-out process. When users click the Sign Out option in OAS, they are not being logged out. Instead,…
-
OAS presentation variable upper filter
HI, i am putting this one presentation variable and using converting this filter to SQL. https://community.oracle.com/products/oracleanalytics/discussion/1924/obiee-use-upper-on-presentation-variable-in-filter It's on the dashboard and if I click on Analyze link, it doesn't transfer the upper variable to the actual query.…
-
Oracle Analytics Server 2026 - Date format is showing "Unicode Char" on terminal
We've recently upgraded Oracle Analytics Sever from 8.2 to version 26.01. We noticed that when date is displayed on Unix terminal, its showing extra character like in attached image. How this can be fixed, is there any document or note provide information on date format changes in 2026? Thanks in advance!