-
FDI - Data Augmentation Completed but no data Inserted into the table
I have created an Oracle CPQ connection in Fusion Data Intelligence (FDI). After that, I have created Data Augmentation with 13 columns (1 Primary Key, 1 Incremental Key and 11 normal Attribute columns). The Data Augmentation run completed, but no data was inserted into the table. I checked the Warehouse Refresh…
-
How do I add a missing hierarchical dimension to an OOTB Subject Area?
Hi, I'm trying to add the Department Hierarchy to an existing ootb subject area in FDI. I see that the hierarchy is included in other subject areas, but it's missing in the one I need to use. I tried doing this through augmentation, but I'm having trouble understanding which is the right pvo and how the it relates to the…
-
Can someone help me to understand what Briefing Books are?
I found documentation for Taleo and Apex but I need them for Oracle FDI
-
Replace Oracle logo with customer logo in finance standard reports
We are experiencing issues with standard reports in finance, where the report output shows oracle logo while customer wants to see their own logo. There are many reports where the change is required. There might be a way to change it in all the standard reports at once. Can someone please suggest? Thanks, Shailender
-
Oracle ADW - Pre built Roles, Custom Roles
This question is regarding Dev Ops direct client access in Non Prod to ADW DB standard content prior to building some downstream integrations to on premise applications. As we know in ADW we have the OOB schema with prebuilt content and in particular the tables and views. Does Oracle provide any OOB roles to segregate…
-
Set PARAM_EFFECTIVE_DATE in OAC/FAW
Summary How to run report with effective date parameter Content Hi, In OTBI, we can run a report with an effective date by putting for example SET VARIABLE PARAM_EFFECTIVE_DATE='2021-07-31'; in the PREFIX. This would show us how the data looked on a specific day in the past/future. How would we do this in OAC/FAW? I have…
-
Has anyone been able to successfully add calculations to a subject area?
I'm trying to use the SCM - Sales Orders subject area. The metrics that it gives me are fine but not exactly what I need. I am trying to do a calculation in the subject area using existing measures on the fact. For example, Ordered Qty * conversion rate = New Ordered Qty Metric. By doing this, I am required to add the…
-
OTL Table to connect from HCM Common Lookups (value sets)
Hello, We're trying to create an OTL BIP report with a column that uses value sets (HCM Common Lookups). The base table that we use is HWM_TM_REC. Per checking, we cannot find any columns to connect to FND_LOOKUP_VALUES table (table that stores the lookup values). Can you please help find which OTL Table we can use to…
-
How to configure FDI instance on free trial OCI instance ?
I want to configure new FDI instance as a free trial instance and I have an OCI free instance.
-
FDI & Redwood
Hi All - is it possible to embed FDI analytics into Redwood UI?
-
Enable OTBI report in PPM Manage Financial Prj analytics window as shortcut for all job managers
I have developed some OTBI and BIP reports and I would like to centrally enable this report in the ERP Project financial plan right analystics tab as favorites/shortcut for list of users / or role. (Instead of each user manualy saving as themselves through the gear icon) I mean having it centrally enabled in the right…
-
Enable OTBI report in PPM Manage Financial Prj analytics window as shortcut for all job managers
I have developed some OTBI and BIP reports and I would like to centrally enable this report in the ERP Project financial plan right analystics tab as favorites/shortcut for list of users / or role. (Instead of each user manualy saving as themselves through the gear icon) I mean having it centrally enabled in the right…
-
How to extend subject areas with a dataset created via Excel upload?
Is there a way to extend subject areas with a dataset created via Excel upload?
-
Is there a workshop to test a deployment?
About a year ago, there was a workshop that provided links to test analytics and its deployment. Is there any area like that we could use to test and deploy?
-
Applying segment security for CAA (Configurable Account Analysis)
Team - Customer having multiple companies under one fusion implementaion. When they're accessing the data in OAC, they're able to see other companies data. Is there a way to restrict the user logged in to view the respective balancing segment data and filtering other balancing segment values.
-
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERP
I have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of each user manualy saving as tehmselves short cut) I mean having it centrally enabled in the below window in reports /analytics for list of users or role.…
-
Enable custom reports centrally for all Job managers in PPM manage project financial plan analytics
We are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the right. Alternatively, how could we redirect the pop up tab to look at a role specific custom reporting folder instead of out of teh box folder Could you…
-
Lab for fdi ?
Hi, I've requested an OAC lab from MyLearn HCM Global Human course but I would like to know whether or not I could also have access to the fdi console to be able to show my trainees all the fdi settings and functionalities (pipe, data aug, SME, etc), or if only the OAC vizualization part was available as a demo ? Regards,…
-
How to identify missing Associations in a Taxable Benefits Calculation Card
Hi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been entered into the card correctly but the Association Details have been missed. This results in the Calculation Component being ignored. I have tried to…
-
Cannot select ${keyValuesForColumn} columns from dataset in FDI
Hello, I'm using below documentation in order to create deep link in FDI FAW: How to Implement Deep Link To Drill down to Asset Depreciation Fusion Screen (Doc ID 2960828.1)…
-
Is anyone else experiencing issues with copying and pasting canvases and the canvas disappears?
This past week, both myself and a colleague have been unable to copy and paste most canvases. It will typically paste for a moment and then disappear altogether. Occasionally a certain canvas will actually copy and paste, but most will not currently . Has anyone else experienced this? Is there any workarounds or fixes?…
-
Rehired user getting created as a duplicate user in ERP.
When a user that has been terminated is rehired, it creates a duplicate user in ERP for them with the same user ID but a different assignment number. This behavior is new and is causing issues for the import because it looks for a valid Manager and users have the original Manager assignment number instead of the new one…
-
FDI HCM Reporting Config - what happens when "View Own Context" is set to "No"?
What is the purpose of reporting configuration (HCM Analytics) "View Own Context" ? By default it is set to "Yes", for which requirements should this be set to "No"?
-
HCM - Position subject area showing Assignment Category Code rather than Assignment Category Name
When I pull in the Assignment Category from the HCM - Positions subject area, the results that I see are the Assignment Category Code, and not the Assignment Category name. Maybe this is being caused by something that my organization has configured incorrectly but it doesn't appear so to me. From what I can tell from the…
-
Query to fetch task assigned to , completed by , task archive date , purge date for onboarding check
Query to fetch task assigned to , completed by , task archive date , purge date for onboarding checklist task of retired employees
-
How to identify open and closed transaction in FDI Budgetary Control
Hi, We are using FDI Budgetary Control subject areas for Budget Utilizations reports. Currently, the data in both Budgetary Control - Balances and Transactions subject areas contains all the transactions. Our end users would like to see only open transactions in all the reports. We have verified all the attributes…
-
Income Statement: Branch wise Gross profit and percentage calculation
We need to display branch-wise gross profit and its percentage on our Income Statement report in FRS. Here's how we envision the calculation: * Gross Profit: Total Revenue - Total Direct Costs * Gross Profit Percentage: (Gross Profit / Total Revenue) * 100 The key challenge is that we don't have a specific natural account…
-
Different tabs for each branch in FRS
I am working on an FRS report. There is a requirement where I need to create Income Statement report in FRS. I have developed three grids. First grid will give the total values for each field based on Natural account. Second grid will give branch wise data for each field. I am able to see all the branches for a particular…
-
How to automate FDI bundle backups?
Are there rest APIs available to help with this or how is it done?
-
Semantic Model Extension - not able to see new column added on database
We have an existing custom Subject Area in FDI. We have added new columns to the backend database. While creating a Semantic Model extension to add a physical column, I am not able to see that new column.
