-
Request for Legal Employer of Manager in OTBI Analysis
HI in the subject area "Workforce Management - Worker Assignment Real Time", I need to retrieve the legal employer of the manager. Is this possible? If not, is it available in another subject area? I need a list of managers along with their respective legal employer. Thank you.
-
Current DateTime and Current Time Parameters in FDI OAC Workbooks not correct
Hi Very simple question: The Current DateTime and Current Time Parameters are showing incorrect values in our FDI OAC instance. I have checked and in FDI System settings, Default Time Zone For Date Calculations are correct, but still the parameters are wrong…? See screenshot: Time is 11:44 in Copenhagen but Current Time…
-
The art of possible with FDI?
Hi All, I am working with a high profile Higher Education customer in UK who would like to hear from other customers on how effectively they are using FDI. For eg:- Are they only using the pre-built analytics elements of FDI or have they also extended these to create custom reports or analytics etc If anyone is willing to…
-
FTE Reporting
Looking to know if there are examples of good FTE reporting that comes out of the box from Oracle on the fusion or FDI side?
-
How to get the Full Year based on Current Month in OAC DV?
Hello All, We have a requirement in OAC DV to display the full year's amounts/values of data dynamically based on the currently selected period filter. Specifically, the objective is to show accumulated values for the year up to and including the current month. The data is derived from a financial subject area, and we are…
-
How to Create Dynamic Period Parameters in FDI?
Hi everyone, I’m trying to create dynamic parameters in FDI. For example, I have two period parameters: the first one is a selected period, and the second one should automatically take the previous period based on the first selection. I want to display amounts according to these periods. Has anyone come across this…
-
we're getting error when we try to connect Data Configuration under Application Administration
we're getting below error when we try to connect Data Configuration under Application Administration , "An error occurred. Try again"
-
How to track actual delivery status of email received in user inbox via BIP bursting
Hi All, We are bursting emails to users with customized version of seeded reports via BIP email bursting. There is a business ask to validate actual email delivery status of email being delivered to user inbox or not. We can see email sent status in bursting details in Job history page. But it goes to success even in cases…
-
Activity Logs for Reporting Configuration changes
Hello, My customer wants to keep a track of (kinda' audit trail) the reporting configuration changes that are done on the FDI instance - who did that change, what change was done, when was it done, and so on. I see no "activity" tab in this area of reporting configuration. But I am sure the changes are stored in some…
-
Backup Reports in FDI Without Available Bundles – Need Guidance on Adding Bundles
Hi everyone, I need to back up my reports in FDI, but my instance doesn’t have any bundles available to create or perform the backup. If adding a bundle is required, could someone please guide me on how to add it to my instance?
-
How to Remove Null Values in FDI Pivot Table and Display Data by Period, Ledger, and Status?
Hi everyone, I've created a pivot table in FDI, but it's displaying multiple rows due to null values. I want to remove those nulls so the data is shown in a single line, grouped by period, ledger, and status. Additionally, I’d like to apply specific colors based on the status of the period and ledger. Is there a way to…
-
Need to Add Period Status to Report – Not Available in FDI Subject Areas
I need to include the period status in my report, but I’m unable to find any subject area in the Fusion Data Intelligence (FDI) instance that contains this information.
-
How to Configure Cache Reload for Synced OTBI Data in FDI Dataset
I am creating a dataset using the connection available in the FDI instance. I have selected the required columns from an OTBI subject area. Now, it is asking for the "Cache Reload Type." Which option should I choose if I want the dataset to be updated automatically whenever the data is synced?
-
Automatically send email with FDI report as PDF attachments to list of job managers in the filter.
I have a FDI Dashboard with filters for Job Managers. I would like to auto-schedule weekly and send PDF of FDI Dashboard (as output attachment) to each Job manager. is this posisble in FDI? please list the steps i need to take.
-
Suppress zeroes and nulls in FDI Data Visualization
I am hoping to suppress all of the rows showing with null or zero in the screenshot below, while retaining all rows that show values other than zero. I've seen some options for an Expression Filter using the 'Aggregate By' function, but have not yet been successful. I'd also like to convert the nulls to zeroes if at all…
-
Incorrect values are reported for Statistical Accounts within GL Detail Transactions in FDI
For accounts that have statistics and units posted to them, the statistical values are reported incorrectly on FDI reports. There are standard data names for statistics balances in the GL Detail Transactions Subject area but they don't return the correct values. This information is available within the GLBalance Sheet or…
-
Cannot open or schedule a custom report. An error occurred while processing your request.
Receive error message after 10 minutes when opening the report or scheduling it, even the parameter is not visible.
-
Filtering by a large list of values in FDI Modern View
In FDI Classic View, we have the ability to filter by a large list of data via this "pencil" selection within the filter. Is there an equivalent in Modern View? If not, how are others working around this? And is there a fix for this coming?
-
How can I test semantic model changes before publishing the changes?
Hello, I was under the impression that after I applied my extension, I would be able to see the fields that I am adding reflected in the app, but this is not the case. I would like to test that my changes work prior to Merging and Publishing. Am I missing a step? Screenshots below display the Target subject area, the…
-
Payables Table for Prepayment Information
In which Payables (A/P) table can I find information related to prepayments? I am currently developing a customized Aging report and need this information in order to mirror the prepayment date. Please see the attached image from the application where I can view this data. Best regards, Kauan Bohn
-
Required Backend SQL table for Manage Taxes setup
Hi Team, Could anyone please tell us the Table name where the columns("Collecting tax authority" and "Collecting Tax authority site" ) information stored for the task Manage taxes setup. We have gone through all the ZX tables but we are unable to find above mentioned two columns. Attached screenshot with highlighted fields…
-
Fusion Service - Can messages stored as Blob/Clob fields be made available within Analytics?
We have a customer who has a very extensive detailed reporting requirement that also involves messages table containing clob fields. Most of their reports are dependent on this fields. Are blob/clob fields synchronized with FDI to be able to retrieve the messages available as Clob fields within analytics UI.
-
Count vacant positions in FDI using Position Managment Subject Area
We need to get vacant positions through Position Management subject area. The business need is that : the position is considered as vacant if there is no incumbent or if it's occupied only by Pending Workers and or Contingent Workers. Could you please share any formula or expression that may help in FAW ? or if you faced…
-
How Does FDI Forecast Function Handle Partial Quarters?
Hi all, I’m using the built-in forecast function in Oracle Fusion HCM Analytics (FDI) to project quarterly retirement headcount trends. I’m trying to understand how the forecast handles the current quarter when it’s still in progress. Specifically: Does the function treat the current (incomplete) quarter as a full data…
-
User license consumption of uncreated users
Team, I was reviewing the licensing because we have 11 users in the contract. However, when I check the “Usage Tracking” report we see that two users are being counted in the licensing, but we have never created these two users. Why are these users? Are these users actually consuming licensing?
-
Create Data Augmentation for DOO Extensible Flexfields in FDI
Hi, I would like to create a data augmentation for DOO Extensible Flexfields, for example for Header Information, but I'm not able to find a proper source table. Is there a source for this or this must be created? Thanks Giovanni
-
Data level security in Oracle FDI and ERP
I would like to understand how security context information flows from the ERP system to FDI. Currently, I have access to only one ledger in the ERP, allowing me to query financial data related solely to that ledger. However, in FDI, I can see all ledgers, balances, and journal entries that have been posted. My…
-
Combining FDI Reports Exports
Hi Community, I built two FDI reports with the same number of columns and same column names. Is there a way to create an excel export combining the results of these two reports?
-
Production to Test environment refresh impact on FDI
Hi Team, Production to test environment refresh of source(ERP) application is going on and source application is not accessible. It has impacted FDI as well and we are not able to login to FDI/OAC. Is it the expected behavior. Our understanding was , we should able to login FDI/OAC. Once the ERP refresh is done, only full…
-
Snowflake connector in Oracle FDI
Hi Team, There is a pre- configured connector for Snowflake available in FDI. Can it be used to ingest data from multiple tables from snowflake to multiple tables in ADW as there is a requirement to create multiple dashboards based on snowflake data. Can we create multiple integrations using this connector. Can we use this…
