-
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!
-
Oracle Analytics Server 2026 - Schedule option missing in DV->Export->Email
We've recently upgraded Oracle Analytics Sever from 8.2 to version 26.01. Schedule workbook is enabled by following steps from - Enable the Workbook Email Scheduler Node.js process is getting started, OAS has been restarted after the setup, permissions are given to the user's role, however still not seeing "Schedule"…
-
Time Series Setup/Creation in OA 2026 DV?
Hi, In an on premises Oracle Analytics 2026 version need to create time series so if any latest details avaialble on how to do like a video or link will be appreciated. As there is hierarchy creation so need to understand in details. Need to create for Oracle EBS General Ledger. Thanks
-
Report in OAs 8.2 don't finish loading after report was migrated
A report with a hierarchy does not finish loading, the hierarchy has already been recreated, the logical dimension but it continues not to work, an SR was raised but they indicate that it is necessary to review permissions, recreate the hierarchy but it continues to work, i don't know if this is a bug of the application,…
-
"On Click" data action on a Tile visualization?
Is this available and I'm just missing it? I do see where the right-click data action is available for a Tile but now that we have "on click" available for buttons and other visualizations it is confusing for our users that data actions on Tiles are different. Is this a planned enhancement if not already available?
-
How to model in the web bases semantic modeler a Fact table with multiple joins to same dimension
Hi! I have a Fact Enrollment table, i have enrollment dates, but also completion dates. I have a Calendar dimension. I am trying to implement the best way possible the joins. I have been reading and there are multiple ways, but I am not sure what way to go. In the physical layer I cant join twice on the same calendar…
-
Unable to expand account hierarchy for some of the accounts where there are no balances.
I have worked on a report where i have to display budget and actual amounts for expenditures and revenues, i am filtering the report for budget code and agency filters but unable to expand the accounts where the actual amounts are 0.
-
502 Bad Gateway Error Consistently
I am consistently getting a 502 Bad Gateway Error when trying to login to our instance. Wondering if this is unique to us or if there is something that we can do to fix it.
-
R13.x Deprecated and New BI View Objects
Hi Oracle Analytics Product Team, I wanted to check who do I need to reach out to get the latest xlsx for the 26C Deprecated BI PVOs? R13.x Deprecated and New BI View Objects - Oracle As per Oracle Fusion Cloud Applications Suite What's Notable and Different in Oracle Transactional Business Intelligence following is the…
-
Deployment takes time to show Subject Area?
Hi, When we deploy subject area it takes time to show when we try to create analysis or work book. How to avoid this delay in deployment while development. It is latest on premises 2026 version and using data visualizer to deploy. thanks
