-
Learning - OTBI or BIP tables that can be used to list all rulesets tied to Learning initiatives
Are there tables or subject area that can be used to list all OTBI-based rulesets tied to a learning initiative?
-
Do we have any OOTB FDI/ADW table which stores Individual compensation data in FDI HCM?
Do we have any OOTB FDI/ADW table which stores Individual compensation data (ICD)/Awards that can be used in FDI Data Augmentation.
-
What all bundles should we import while planning to migrate our FDI-PROD to new lower non-prod FDI?
We need some guidance regarding the sequence of bundle import in lower environments. If I import Data config bundle followed by environment bundle - that should suffice ? Or I need to import all bundles separately- Security, content, Semantic bundles ? I have security & semantic model extensions in Prod environment. Is…
-
Is it recommended to change my FDI production instance from Standalone to Integrated type?
I’m facing an issue where, after my FDI instance went down or lost connection with my Fusion applications, we re-established the connection with the help of an SR. However, my FDI instance is now set as Standalone, and the connection method is password-based. Before this, my PROD instance was integrated, so the connection…
-
How to embed the report built with FDI in fusion or any web page
Hi Experts Could you please let me know the steps how to embed the FDI report in fusion or any web page. I'm not sure how to get the URL of the FDI report for embedding. Please help me
-
Embed FDI reports in Fusion
Is there any other way to embed FDI reports in Fusion other than through Visual Builder? I found this blog where they explain the procedure for doing this using Visual Builder: https://blogs.oracle.com/analytics/post/embedding-fusion-analytics-content-in-oracle-application-cloud But is there any other alternative, or is…
-
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
-
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:…
-
How to create a custom role which can be given to users to schedule the workbooks in Orace FDI ?
How to create a custom role which can be given to users to schedule the workbooks in Orace FDI as we cannot give BI admin access to all the users. Not able to find any role with "Schedule Workbook" access.
-
Will updating the source URL details affect the ADW OOTB tables or remove custom schema objects
Will updating the source URL details affect the data stored in ADW out-of-the-box tables or remove custom schema objects? Please clarify the consequences for Oracle FDI and OAC reports, configuration —will SME changes still be preserved in FDI?
-
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?
-
Is it allowed to update connection details while creating fusion cloud integrated FDI instance
Is it permissible to update Fusion connection details during the creation of a Fusion cloud integrated FDI instance, Since oracle is showing the below note: If not under which configuration users are allowed to update source connection details in FDI.
-
No Data Showing in HCM Dashboards (FDI) Despite Successful Pipeline Run
Hi everyone, I’m currently working with Oracle Fusion Data Intelligence (FDI) and have configured and executed the data pipeline for Human Capital Management (HCM). The pipeline completes successfully without any errors. However, when I open HCM dashboards — for example, the Absence Dashboard — the dashboards display: “No…
-
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?
-
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…
