-
FAW ERP Data Validation - User Accounts/Security
My understanding of how the data validations run is as follows The validation is run against the FAW ADW database (via FAW reporting layer) The validation is run against the ERP (via OTBI reporting layer) The results are compared and reported back My question is around what account is used security-wise. When we set up FAW…
-
The IDCS does not appear from the Manage Users
We have administrator users with the FAW Service Administrator group, these are users that will also manage the FDI security. However, when they click on the Manage Users option they should be directed to the Identity Cloud Service but the application does not appear. What do I need to relate to these users?
-
ESS Job name not display in Report
We are trying to build a report for the list of ess jobs scheduled but we are no able to get the full name of the ess job scheduled only a short name is available is there any table to hold the display name of the ess job? If try to get from ess_request_history some schedule job name not populate. Please let me know if any…
-
How can I pull a newly created ADW indicator and use it in oac ?
Hi, I've been trying to create indicators directly in ADW through the creation of views. For exemple, 2 columns with the number of males and females. When I try to add these columns through my SME feature in FDI, I'm able to see them in OAC but only as attribute... Where in ADW, they are numeric. Could someone explain me…
-
Question about the Connector (preview as of 24R3): "Oracle E-Business Suite On-Prem"
Did anyone use this connector (currently in Preview as of 24R3)? The following is mentioned in the preview area for Connectors: Oracle E-Business Suite On-Prem This feature enables configuring a remote agent to load data from on-premises Oracle E-Business Suite (EBS) to build a managed data pipeline with data from that…
-
12-month rolling termination count
Hi, I'm trying to add a column with the 12-month period rolling suffered termination count SME ("suffered termination" includes : resignation from employees and end of the probation at the employee initiative only. Our developer has already created a fact and columns. Here are more details : Fact : Columns : I would like…
-
What is the impact of not Assign Financial Categories to the Natural Accounts
One of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doing this step. Regards, Omran
-
Inventory Valuation Analysis workbook not showing any data
Hi team! I activated SCM offering to be able to see SCM workbooks. I picked Inventory Valuation Analysis workbook, for example, to test data visualization. However, when I choose filters there's no current information to pick and therefore, there's no data to show on the workbook: Is this issue security related? Which…
-
Can we limit the USE-AS filter option not to affect other canvases.
Hi, We would like to know whether there is an option to limit the USE-AS filter option not to affect other canvases. In the below example, When we click on the tile "DSO by Month" "0.58" value, The previous tile "DSO by Quarter" also changes to "0.58" instead of the total value which is "1.22". Is there a way we can…
-
Unresolved accounts in Catalog Folder Permissions
FDI instance provisioning is done and logged into Analytics for the first time. When checked the permissions on the catalog folders, there are many accounts listed with Unresolved accounts. How to identify these accounts and resolve the error and also It seems only Service Administrator has the access to view the prebuilt…
-
How to display Historic data in FDI
Hi, I see that by adding some FACTS metric (eg: Headcount Turnover) I'm able to see historic data for assignments and I can also filter by date: Is there a way to have the same without adding the Headcount Turnover? Thank you
-
How to hide facts from chart/table
Hi, we need to display historical data for each person and we saw that Time folder doesn't fit our needs since filtering by it's elements doesn't allow to get back in time. We noted that this isn't completely true because if we add some Facts to our charts/tables, like Headcount Turnover, it is possible to filter back in…
-
% female
Hi, I've been trying to create a report where I'd like to see the number of males and females who have a specific status, by legal entity. To do so, I've added the gender column 'Sexe' and I aggreagated it as a number to see the value for each gender. I've also enabled the sum line/column. And I added as a filter, the…
-
DEV FDI connected to HCM PRod
Hi, I have 2 FDI instances, one for Dev and one for Prod. The Dev one is connected to the HCM dev of my client which has been last updated 10 months ago… and the HCM instance is used for different stuff so it can't be updated monthly as I would like to… Is there any harm to connect my FDI Dev to HCM Prod even if my FDI…
-
BAP/FAW Subject Area->Not Listing Columns Related to Resource Usage/Quantity to capture actual usag
Hi Team, BAP/FAW for manufactruring subject area no showing resource usage/quantity related columns. we are building mfg dash board to review the actual resource usage hours in a given date range for resources against work orders. refer the screen shot of what we are looking for. we want to pull the same information…
-
Need help Request Non Catalog Learning notification template.
We need to modify Request Non Catalog Learning notification template. How can we map the notification to BIP report. We modified the report "LearningRequestApprovalReportTemplate" but changes are not reflected in the notification. Please advise.
-
Prebuilt Fusion Data Pipeline Refresh Times Optimization
Hi Team, The Oracle Managed Fusion data pipeline is taking a very long time around 4hrs 30mins for the incremental refresh every night, is there a way we can optimize this schedule by considering any key factors. This is causing daily data load delays into our business system. Please let us know any feasible approaches and…
-
Show numbers in map
Hi, I need to show numbers in this map. I set the Number Format but it was ineffective. Why?
-
Count the number of HIRES in a specific way
Hi, I need to create a line chart showing the number of hires for each company year by year. One of these companies, let's say company "A", should also add the hires of another company, let's say company "B", when year < 2023 because it was merged with the first one. Is there a way to create a key metric or a calculation…
-
Ask Financial Calendar in FAW
Summary: Load another calendar in FAW Content (required): We recently implemented FAW and we need to load Financial Calendar, can someone guide us in how we can load the finanacial calendar and use it. Version (include the version you are using, if applicable): 21.R3.P4 Code Snippet (add any code snippets that support your…
-
Enterprise Calendar and Fiscal Date dimension
Hi, Just wanted to know what is the effect setting "Enterprise Calendar" in the FDI reporting configuration? We have 2 option, which is the organisation calendar and gregorian calendar. Does this affect the OACS reports and Semantic layer? if yes, in what way? Also, what is the source in populating the the below Fiscal…
-
Export data from OAC to another source
Hi, I noticed that OAC can be connected to Snowflake, SFTP, etc to bring data to the console. Is there any native way not to import BUT to export data to other sources (SFTP, Snowflake, etc) ? Thanks, Regards, Lauriane
-
Activating a functional area in FDI
We recently provisioned FDI environment and has started configuring FDI. As a first step, we enabled preview features and then generally available features. As a next step, we created functional area and there were 3 options available- Save without running(you can schedule later- if we use this, functional area gets saved…
-
How to create a % column
Hello, I have a custom field which can assume 4 values, one for each of these columns: I need to add a column where I show the percent of RETE column compared to the sum of each row. For instance at row 4 this percent should be 24/(47+0+24+0) = 34%. I guess I need to create a new calculation but I have no idea how to…
-
Error in SQL query from a connection to Fusion ERP
I established a connection with Fusion ERP, I want to make a manual query through SQL but when I try to do it I get the following message: "There was an unexpected error while processing this request. Please try again" How can I make a direct query to the database using SQL from FDI?
-
Why this division doesn't work?
I have these yellow key metrics: Why the green calculation, which is simply a division between the 2, always returns 0?
-
How do I use the segment hierarchy prompt in FDI rather than having different prompts for each level
I am trying to build a report where you can select different parents in the cost centre hierarchy. How can I do this with one hierarchy prompt rather than having multiple prompts for each different level
-
New Hire Headcount Retention Formula
We have a requirement to report on New Hire Retention and I need help understanding how the Oracle measure is calculated in FDI. It looks like New Hire Turnover rate is # of New Hire Termination Headcount / Total Average Headcount and it looks like the New Hire Retention is taking the subtracting the Turnover rate from 100…
-
Is there a OOTB subject area that contains Corporate Card information?
We are looking to create a report based on expenses and corporate cards however are struggling to find this information. Is this data available OOTB in FDI? Thanks, Georgina
-
Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?
Ran the Supplier Balance Aging Report and encountered this error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ORA-06512: at line 4 Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?
