-
Fusion Analytics Autonomous database Series: Creating Custom Schema
FDI customers often want to restrict access to sensitive tables. The Blog tries to address this critical need by outlining how custom schemas can be created with tailored access. The post provides a sample custom script that users can use to customize the script per their own use cases…
-
Briefing Book Option is not enabling in Oracle Analytics Classic Home of FDI
Hello, We are trying to create Briefing book in the Oracle Analytics Cloud Classic Home of FDI. Even though Add to Briefing Book option is enabled in Dashboards couldn't create Briefing Book in OAC classic Home. Could see this option available for OTBI Fusion Attached screenshot for reference Add to Briefing Book Enabled…
-
Is there a formula that will produce the same result as setting Sum By Dimension in the visual
We have a requirement to show reports in constant currency and USD. In the Financials - AP Payments subject area, I have added exchange rates on the Currency dimension. My calculation is Payments Amount CD: SUM( Payments Amount * Exchange Rate BY Ledger Currency ) I'm using Payments Amount from Facts - Ledger Currency and…
-
Absence Analysis Not Populating with Data
We are trying to create an absences dashboard and started with the prebuilt dashboard. However, the out of box dashboard is populating with 0's or no data found. Where can I look to identify why none of the approved metrics work? I have the same problem in the Absence - Diversity overview, where only rejected stats come…
-
Export FAW Object List
Is there a way to export the list of objects from the Content Management screen in the Console or is there a table in the database that has this information?
-
Auditing report for Admin activities
We have a requirement to get Auditing report for the Admin activities which will include the information about updating the Resources information, Security console related changes, Sandbox related changes, Setup & Maintenance activities etc. We have got below documents regarding existing functionalities of Admin activities…
-
FAW: SME Warning/Error Banner Notification - There Are Errors In Your current Semantic Extensions
Customer’s might see below notification banner in SME tile - this message banner is a proactive notfication to inform customers of any missing columns which are used in SME which should be reviewed and corrected. This message should not have any SME/user impact. Please click Learn More on the Banner Message to get error…
-
Calculated Fields Sorting
Currently Calculated Fields when working in a canvas view have no options for sorting. Some more complex views can lead to dozens of calculations, having the ability to sort these by type, recent, and Alphabetically would be incredibly helpful.
-
Can a defect identified in OAC be sent to another user for acceptance?
We have created an OAC dashboard to identify contract defects such as missing data elements or conflicting information for completeness and accuracy. In some cases, the defect can be allowed to exist, but we would like the ability to route it to the process owner to accept the defect. Can a defect identified in OAC be sent…
-
Turnover By Country and Enterprise Period
Hi Team, I am writing to address an issue regarding the turnover calculations for multiple countries within the enterprise period. Currently, when I query the turnover for a single country, the results are accurate. However, upon adding additional countries, the values returned do not seem to be correct. Could you please…
-
Approach to Create custom Subject Area using Fusion_ERP_Analytics_Tables
Hello Experts, We are trying to create a custom subject Area from Scratch using the Fusion_ERP_Analytics_Tables in Semantic Model Extension in the FDI. While Adding Dimension,Couldn't see the Fusion_ERP_Analytics_Tables available in the OAX_User Schema. Can we create a custom subject area from scratch using Facts &…
-
Invoice Line data not appearing DW_AP_SLA_EXPENSE_DIST_CF table
Our team has entered test data in the Oracle Financials Cloud application that is unexpectedly not being populated in the Expense Distribution fact table. Is there an undocumented filter condition that is being applied in the FAW pipeline that excludes records from being populated in the DW_AP_SLA_EXPENSE_DIST_CF table if…
-
How to populate employee start date with current year?
I have created a field which is extracting the day and month from an employee's start date and combining with the current year (see below). I am having trouble casting this back as a date field can anyone advise how I would do this or a better way to extract day/month from start date and combine with the current year?…
-
Remove Semantic Model Errors
Was looking throughout our Dev environment and noticed we have different Semantic Model Extension Errors and do not know how to approach in solving this issue. Does anyone know the underlying issue on why these issues are arising in dev?
-
FDI Financial categories - Mapping options
If we want to use the pre-packaged KPIs and metrics tied to financial categories (e.g. CAPEX ratio) and the source ERP does not have individual mapping between accounts and financial categories: Question #1: Can the mapping be set in FDI only via CSV upload? Is there a way to update an internal table with the individual…
-
Oracle ERP invoice data is not appearing in the DW_INVOICE_SPEND_CF table
Our team has entered test data in the Oracle Financials Cloud application that is unexpectedly not being populated in the Invoice Spend fact. Is there an undocumented filter condition that is being applied in the FAW pipeline that excludes records from being populated in the DW_INVOICE_SPEND_CF table? it appears that the…
-
Unable to see user and role tile in Oracle Analytics
I'm a security administrator and upon logging to OAC/ Analytics, I'm not able to see the User and Roles tile. The below youtube link shows how to add the roles to the users, but I'm missing the tile. I'm having the security admin role https://www.youtube.com/watch?v=708kPY0ZmA8&ab_channel=OracleLearning Please advice Vj
-
Where do I find Employee Home and Mailing address in FAW HCM?
-
Get attachments from UCM server to third party SFTP server
We need to develop a new Outbound Integration to get all the attachments placed in UCM content server to the third party SFTP server. SOAP services we cannot use , so we need an alternate solution for the same. Please share us any idea regarding the same. Thanks & Regards Sharmila Rajagopal
-
For FAW/OAC HCM - Learning subject area how do I get the actual score and actual hours?
I'm new to Oracle and FAW/OAC but not new to data or analytics. We're trying to adopt FAW and OAC. We have the area turned on and are getting data on the learning items and assignments but can't find the actuals. Nothing is populating in the outcomes. How can I get this information? I also don't see it in the pre seeded…
-
FAW -- Invalid credential name
Hi All, We are running the below sql query in OAC BI publisher and getting 'Invalid credential name'. Please share your input if you have faced similer issue. SQL Query ======================================= select * from dbms_cloud.list_objects( 'XX_DATA_STORE.XX_STORAGE_CREDENTIALS',…
-
Need AP Invoice line level details i.e. Matched purchase order number and line number
Hi Team, I am building visualization where I need to have invoice lines with match purchase order number and PO line number. I am using AP Expense Subject area for same. As soon as I am adding "Purchase Order Number", i am getting invoice line repeated i.e. one line with matched PO details and one line with blank PO…
-
How can we create restrictive filters in FAW
We have created a dashboard for active employees and added a filter on Level2 Manager. But this filter is showing all of historic Level2 managers also. How can we restrict the filter to show only current Level2 managers
-
Year Over Year Comparison Calc for Custom Subject Areas
Trying to take revenue amounts and create a calculation and dynamic filter that allows you to take a filter selected period and compare it to a trailing period either MoM or YoY. The native functions like AGO do not work with the custom subject areas we have developed.
-
DW_AP_SLA_PAYMENT_CF PAYMENT_ACCOUNTING_STATUS_CODE column
Are the records populated in the DW_AP_SLA_PAYMENTS_CF table filtered to only include records where the Accounting Status = 'ACCOUNTED'? We have noticed that the value for the PAYMENT_ACCOUNTING_STATUS_CODE = 'ACCOUNTED' for all records in the table.
-
What is the issue of below logic in FAW?
I'm using a simple logic in calculation, Please see the below.. C - NUMERATOR DIVERSE PROMOTIONS: cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and…
-
Supplier DFF creation using REST APIs as a part of Supplier creation Endpoint
Hi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a library that is being developed internally by another team and it doesn't (yet) support…
-
Synchronize data security from Oracle Fusion Financials to Fusion analytics warehouse
how do i synchronize data security from Oracle Fusion Cloud Applications (Cloud ERP) with Fusion analytics warehouse
-
What is the roadmap for FAW Dashboard for Predictive Attrition Analysis
As mentioned in Oracle website https://www.oracle.com/business-analytics/fusion-hcm-analytics/workforce-analytics-product-tour/ the "Top talent Retention Dashboard" shows KPIs related predcitive attrition by Business Unit, Job Family, Location. This dashboard is not availabled in current released. I would like to know what…
-
Autonomous Data Warehouse significance for OAC
Hi, We are looking for assistance to understand the importance of Autonomous data warehouse with regards to OAC. What benefit or feature it adds to the analytic tool OAC. Regards Ashraf Bilal
