-
What is required attributes related to FDI Financial categories when loading manually
Within the manual upload option for Financial categories there are 5 attributes - CHART_OF_ACCOUNTS, FA_COST_CTR, GL_ACCOUNT, GL_BALANCING and FINANCIAL_CATEGORY. There no clear documentation on the definitions on these attributes. my question : Is "FA_COST_CTR" & "GL_BALANCING" required (mandatory) ? if we do not map…
-
hello team i would like to implement FAW in my environment, can i get a demo platform?
-
Is there a way to bring data from 2 different source tables into the same FDI Fact?
We are backing up some of the FAH tables that are wiped in 90 days from the Fusion database in a separate database. Is there a way to run the FDI data pipeline against the regular FAH tables and then also against this other database we maintain?
-
Displaying last 12 Months of Data based on Current Month Parameter in OAC
Hello All, We have a requirement to show last 12 months of data based on Current Month Period in OAC, we know this can be achieved through OAC Classic Home in FDI,Would like to know how this can be achieved in FDI OAC. In below example we have used filters in different columns to show data by period which is static. wanted…
-
Is possible to represent the people according to Province and Region?
Hi Community, I would like to know if in FDI is possible to represent people according the the Region and Province in which they are currently working. I know that is possible to represent people according to to the Countries, but We need that reprsentation within the same Country. Regards, Luca
-
Can the logo be changed in the new Oracle Analytics interface?
I cannot find instructions for how to change the default Oracle logo in the new Oracle Analytics interface. I found this documentation (https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/apply-custom-logos-and-dashboard-styles.html#GUID-613FCAF2-2565-4E06-9E1F-4DA3EB520D29) for how to change the logo…
-
Filter Manager Count by Assignement type
Hi, I am having trouble getting the correct Manager count, as the Manager Count Fact is counting all my different types of assignments. My company uses four different "Assignment Types," and we do not want to consider someone a manager if they only have Pending, Non-Worker, or Contingent Worker assignments. The main reason…
-
Why is a Newly created Non-Validated invoice does not show up in report right away but the next day?
Newly Created non-validated AP Invoices does not show up in the report after creation. After a while or the next day before 12 noon, it shows up to the the OTBI report. This happened in 2 different instance and the same scenario happened. Not Validated Invoice is created and does not show up in the custom report AP…
-
Is there a way to confirm that the FDI Warehouse Full Reload Schedule has performed successfully?
I understand that you can check refresh statistics in the Common - Warehouse Refresh Statistics subject area, however their is no Process type for Full Reload. I have also checked the DW_WH_REFRESH_SUMMARY in the ADW. Is there a way to confirm that the reload schedule has successfully performed when scheduled using the…
-
Application Roles Reappearing?
We set up custom groups for our organization to access reports that were custom built dependent on their requirements. We granted duty application roles but did not grant content duties due to wanting to hide Oracle delivered reports to the end users. However, recently all the groups were granted content duties without any…
-
Display current and next 5 years dynamically
Hello, I am currently struggeling to to display the attrition data for the current year and the next four years dynamically. The out-of-the-box functionality allows selection for future years but omits the current year, which is critical for the analysis. Has anyone else encountered this limitation? If so, how did you…
-
Snowflake Schema in FDI
Hello, Is it possible to join Dimension to Dimension in FDI? In an existing logical star, we have requirement to join a OOTB dimension table with custom dimension hierarchy table. Regards, Shiva
-
Enterprise Data Management in FDI
How to use EDM in FDI? We have a requirement to develop a set of GL Balances reports based on the custom hierarchies. These hierarchies will be updated every month. We would like to try EDM for this implementation. Our understanding is as below Upload custom hierarchy files in EDM Fusion ERP should pick these hierarchies…
-
HcmTopModelAnalyticsGlobalAM.GradeAM.ValidGradesPVO
Summary: We have a data augmentation requirement in FDI - Job valid grades are not found in any delivered subject area and the PVO of that object is not pulling Data augmentation - HcmTopModelAnalyticsGlobalAM.GradeAM.ValidGradesPVO Content (please ensure you mask any confidential information): We need to create a salary…
-
how to extend the application timeout?
Sometimes I can't save the reports I have been building because the application closes the session, supposedly because of “timeout”, but even being connected and working 100% the application closes. Why this behavior? is there a way to extend or remove the "timeout" in OAC?
-
Which tables should be used for reporting users, roles and actions to generate reports using SQL?
The cybersecurity area has been asking for more detailed traceability of user management in the CX application. We are currently trying to generate reports from the Reports and Analytics module. At the moment we do not know which entities contain the fields we need to reflect. We have tested with opportunity tables, but we…
-
Year on Year (YoY) time series calculations - YoY growth/decline
I'd like to know if the AGO and TODATE time series functions are working by design. Here are the details: We are planning toadded in our dashboard a Quarterly or Yearly Trend which would show the Quarter on Quarter (QoQ) or Year on Year(YoY) growth or decline. Sales YoY growth/Decline = (Sales Current Year - Sales Previous…
-
Steps for creating Shell roles in Fusion
Looking for guidance/documentation steps on how to create Shell roles in Fusion.
-
Transaction Console Invoice Approval History
I am trying to create a report to retrieve information from the transaction console related to invoice approval history. I'm using the tables and SQL below, however, in some cases the approval history table does not provide information for some invoices/transactions. The purpose of the report is to provide the history of…
-
Upcoming FDI ML use cases
According to the Roadmap, current ML use cases include Inferred Skills and Diversity Analysis. Question: Which ML of the upcoming features is powered by ML?
-
How to query custom metrics, for content exploration workbooks
FDI has a content explorer for out of the box metrics. Is there an internal table that stores the custom created key metrics? Our goal is to create a version of the content explorer that incorporates any custom metric…
-
Isolating custom schema resource usage through PDB or separate consumer group
To limit competition of resources (CPU, storage, tempfiles, etc) between the delivered schemas (OAX$OAC) vs. any custom schemas, is there an opportunity/is it supported in the product to have a custom schema being allocated under a separate PDB and/or create a separate non-low, medium, or high connection consumer group and…
-
Recipients don't receive dashboard/report exports emails
We set up SMTP mail server using steps described in: Use the SMTP Mail Server in Oracle Cloud Infrastructure for Email Delivery and are able to create schedules to send out report exports to various recipients. Also when we see under Jobs —> Inspect —> Status we are able to see that the status is completed yet the…
-
Requesting information about archival process for position and requisition approval processes.
Hello Community, Wanted to know the details related to the archiving process of the transaction console for process name "Approve Job Requisition", "Request New Position", "Request Position Change", what is the default archival period for these processes and is this archival process taken care of by oracle or done…
-
An user cannot view data with the role: FAW Licensed ERP Consumers Role
Hello, I have user #1 to which I have assigned the license role: FAW Licensed ERP Consumers Role I have user #2 which has the license role: FAW Service Administrator Role Now, the AR report: AR Transactions Activity Analysis, user #1 does not have any data: But user #2 does have data: It should be noted that the security…
-
What are "_c" attributes in DFFs?
There are several attributes seen in the DFF configuration screen that end with "_c". Please see screenshot. What is the purpose of these attributes and should they be used for reporting?
-
PVO help needed for data augmentation
Hi, I'm trying to pull HCM data through data augmentation and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax registration number (SIRET in French), and all the necessary legal data). I don't know which PVO to select. Any idea ? Also, I'm trying to pull some data that…
-
Can Master-detail analyses in a dashboard be linked on hierarchical column?
In a dashboard in FDI, two analyses (pivot tables) are displayed - both based on the same subject area and use a common hierarchical column (Region>Country>State). When the hierarchy is expanded or collapsed in the master analysis, we would like the detail analysis also to expand/collapse.
-
Filter selection
Hello, I am currently working on limiting the selectable values in a year filter. Currently the year filter is displaying values from 1950 till 2050. However, I would like to limit the selection possibility for the users to either only be able to select years where we have data or years from 2020 until the current year…
-
OTBI Prompt Value getting truncated
Hi all, We are seeing a weird issue in OTBI prompt . When we select prompt value for the first time it returns the data , but 2nd time it automatically shows a truncated data for that value as you can see in the picture and it looks weird and users are not liking it . We have already tried recreating the prompt but this…
