-
New Licensed Roles - Viewer vs. Consumer
In 26R1 there are new licensed roles that make a distinction between "viewer" vs. "consumer". What's the actual implication for having viewer vs. consumer licensed role access? Licensed Roles
-
OOTB Workbooks lineage to Fusion Modules
With more and more OOTB contents being created and available in FAIDP/FDI, what is the best way to figure out the workbook to Fusion module lineage e.g. a newly available workbook in HCM Analytics called GROW, what modules customer must be using to be able to see data in this workbook. Is there a simple way to get this…
-
DFF values are coming as code not description
I am noticed in a client implementation that while in OTBI the Grade DFF brings the right values from description but the same DFF in FAIDP/FDI is bring the corresponding code rather than the description/value. Anyone seen this behaviour?
-
How to Enable Indexing on CSV Dataset in Oracle Analytical Cloud
I am following the same steps for enabling indexing on CSV dataset, but getting error "Run now failed: Indexing is not enable." Why?
-
FDI BIP Connector - Run In Chunk Mode - Invalid parameters for BIP chunking error
Hi, I am trying to use the Run In Chunk Mode option in the BIP Connector configuration in FDI to handle a large BIP report (~4M rows).We have configured the following in the connection: → Run In Chunk Mode: enabled → Chunk Days: 30 I get the following error when testing the connection:…
-
Enable AI Assistant for Datasets not just Subject Areas
In OAC there's a capability to index a specific dataset for AI assistant usage. Is this supported on the FAIDP side? When going to the OAC console of FAIDP I see subject areas listed, but not datasets.
-
Is it possible to upload a BIP report .catalog object using the SOAP web services?
I've done some POCs using the SOAP web services provided (CatalogService (oracle.com)); however, I haven't found any of these web services that can upload a .catalog file. It would be helpful to have a web service that can upload the .catalog files created in UI when archiving BIP reports in order to migrate a version of…
-
OTBI Report Automation - Upload .catalog file
This might be repetition of the question - Is it possible to upload a BIP report .catalog object using the SOAP web services? - Oracle In order to enforce change control and git actions, we are automating the BIP Report upload process. To keep things consistent for FRS, BIP, OTBI reports, we are going to ask developer to…
-
Slowly Changing Dimension - type 2
Hi All I want to keep track about my customers, like how many join/left and rejoin on daily basis. Also want to track with many other attributes. Does FDI support SCD-2 or change data capture (CDC)?
-
Conditional Formatting Against Dynamic Targets
I want to apply conditional formatting for one value against another calculated value. We can use turnover as my example. Let's say the YTD annualized turnover value for the company is 15%. I've created a visualization that applies all the applicable filters and produces a value of 15% for the entire company. I want my…
-
Assign Financial CUSTOM Categories to the Natural Accounts
Hi all, I’m working on Oracle ERP Analytics and trying to understand how to add new (custom) Financial Categories that can be assigned to Natural Account segment values. I followed the standard navigation: Setup and Maintenance Financials → Financial Reporting Structures Manage Chart of Accounts Structure Instances Edit…
-
How to handle custom categories in financial categories for natural accounts in FDI
Prebuilt analyses and metrics in the GL subject areas are based on the standard financial categories provided by Fusion Applications. If custom categories are defined, corresponding derived metrics must be created to ensure accurate reporting. There are missing blogs (404 error) blogs of this topic so if there is a new…
-
Fusion AIDP integrated ADW
Hi All, Are there any technical or licensing constraints associated with using Delta Sharing capabilities with the built-in AIDP Autonomous Database? Since ADW now supports Delta Sharing, there is interest within our organization to evaluate this capability.” thanks,
-
FDI - Is there a Manager Flag or Supervisor Indicator field available for selection
e.g. If I used the the Subject Area MTS HR Analytics - Workforce Snapshot to build a Report, is there a field equivalent to something like Supervisor Indicator that is present in OAC?
-
FDI 26ai ADW: GRANT SELECT ON SCHEMA OAX$DW to a custom database user?
Is it possible to grant select any table on schema OAX$DW to a custom database user within a 26ai ADW? If so, please clarify any pre-requisite steps such as ADMIN or OAX_USER needing specific privileges before trying to run the grant statement. Thanks & Regards, Angel
-
FDI - the currect way to marge sandbox
hi I have auto main sandbox that is automaticity configured with fusion and cx i built additional 3 sandbox and i want to publish them together what is the correct way to accomplish this ? didn't find any useful doc for this :( —- apply to the additional sandbox is replacing the sandbox when i click marge to main sandbox ,…
-
FAW HCM - Workforce Rewards - Payroll Balances Offering
Summary: Fusion analytics Warehouse now offers a new subject area on payroll balances. Content (required): Payroll as of now is in Generally Available. So customer need to enable it from Enable Feature UI - Generally Available. To start using payroll subject area ,there is a Balance Group in Cloud HCM - Analytics Balance…
-
How Long For Semantic Model Extension Field Changes to Show Up On Oracle Analytics Cloud?
Very often when I create or modify a semantic model extension, apply and publish. It takes about 15 minutes to actually see the changes in OAC. Is there a way to apply changes immediately?
-
Getting Oauth error while invoking the Oracle RODS API for SCM
I am trying to invoke the RODS api for the new fusion extract tool . This URL is used to get the extract definitions, it works when using the access token from the UI https://<>.fa.ocs.oraclecloud.com/api/boss/data/objects/ora/commonBoss/dataExport/v1:1431/$en/exportDefinitions/$query but fails with following error when…
-
Oracle Agent Studio — Agent Unable to Read Excel/CSV File for Project Template Creation
I have built an agent in Oracle Agent Studio that creates Project Templates successfully when I provide the details as plain text in the chat. However, when I try to provide the same information via an uploaded file (Excel or CSV format), the agent is unable to read or process the file. Here is what works: ✅ I type the…
-
Custom Financial Categories in FDI
Can more than one custom financial category be assigned to the same natural account (or a combination of CoA segments)? For example natural account 11001 gets assigned to Revenue A for reporting 'use case 1 ' and also assigned to Revenue B for 'use case 2' ?
-
FTE by Gender/Nationality
I am trying to create a workbook using the subject area 'HCM - Workforce Core'. Attached the one I created. , but I have to filter it with some salary code(lonkode). ( We already have the same report available in Qlik and I am trying to recreate it in OAC), but I don't see any HCM related subject area is having this…
-
How can I add an FDI-built dashboard to the Oracle Fusion Cloud homepage?
I want to integrate a report developed in FDI directly into the Oracle Fusion Cloud homepage. The idea is not to share a link that redirects to FDI, but rather to allow users to view and access the report embedded within Oracle Fusion Cloud without leaving the platform. Is this type of integration possible? I haven't found…
-
I am looking for a PVO for PJB_BILLING_CONTROLS table
I am looking for a PVO for PJB_BILLING_CONTROLS table. If not, is there any other table/ PVO that I can use to get the below columns: contract_id,SOFT_LIMIT_AMOUNT,contract_line_id,version_type,ITD_REVENUE_AMOUNT
-
Is it possible to create a report and host it in my own repository?
I want to create a table-like report in FDI and host it in an external repository, for example, a Microsoft SharePoint site. However, my need is not to manually export the file and upload it to SharePoint, but rather to have the report (Excel-style) stored directly there and automatically updated with the information…
-
FDI dashboards for Advance Collections
Does Oracle ERP FDI has any out of the box dashboards and KPIs for Advance Collections?
-
Adding Supporting References to Configurable Account Analysis (CAA)
I’m working with Oracle FDI's Configurable Account Analysis (CAA). Currently, I see that supporting references are not directly available in CAA, they can only be viewed through the relevant subject areas. My question is: Is there a way to integrate supporting references into CAA reports? Could this be achieved through…
-
I want enable AI Agents in Oracle Analytics
I want to enable AI Agents in my environment. However, I followed the documentation below, but I don't have the same access to enable permissions from the console, Is this available for a specific version? We're currently on 26.R1…
-
Error while trying to upload regression model
We are following this guide: https://blogs.oracle.com/analytics/create-a-data-science-model-for-oac We are trying to upload a multiple linear regression model in python but we are facing the attached error. Does anyone knows why? Here the .py source code:
-
How to Dynamically filter Data in FDI/FAIDP 26R1?
I am not getting how to filter data using variable in semantic layer extension → Security. There is no step for adding data security available any more. Now I know Custom Security Context is an option but that is more of Hardcoded Solution So, Want to understand how is it possible now ?
