Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 443
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 170
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion ERP Analytics
Ask questions about Oracle Fusion ERP Analytics, a prebuilt cloud native analytics solution for Oracle Fusion Cloud ERP. Get answers from experts in finance, procurement, accounting, payables, receivable and project.
Discussion List
-
Briefing Book Option is not enabling in Oracle Analytics Classic Home of FDIHello, 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… -
Is there a formula that will produce the same result as setting Sum By Dimension in the visualWe 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. … -
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 …
-
Approach to Create custom Subject Area using Fusion_ERP_Analytics_TablesHello 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 Dime…
-
Invoice Line data not appearing DW_AP_SLA_EXPENSE_DIST_CF tableOur 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 un…
-
FDI Financial categories - Mapping optionsIf 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 … -
Oracle ERP invoice data is not appearing in the DW_INVOICE_SPEND_CF tableOur 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 fi…
-
Need AP Invoice line level details i.e. Matched purchase order number and line numberHi 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.…
-
DW_AP_SLA_PAYMENT_CF PAYMENT_ACCOUNTING_STATUS_CODE columnAre 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 f…
-
Supplier DFF creation using REST APIs as a part of Supplier creation EndpointHi 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 libr…
-
How to define Financials Categories in FAW?We don't want to rely on the financials categories defined in oracle fusion finance but rather defining them directly in FAW and map them to the related natural accounts… -
FAW: Data Augmentation Connector for EPM PBCS and EPCM is in Preview FeaturesWe are seeing Data Augmentation Connector for EPM PBCS and EPCM is in Preview Features from last few releases. When will be these features generally available (GA). Whil…
-
ERP Fusion Dashboards for FAWHI Team, Do we have pre built Dashboards for ERP Financial Subject areas for FAW? I am aware that we it is available for HCM Subject areas, it will be great if anyone ca…
-
Create Better Reports in Fusion ERP AnalyticsLearn how to create effective and timely reports in Fusion ERP Analytics by using the Reporting Authoring Tips that are updated regularly in the Reference for Fusion ERP… -
Justification fields when Receipt Missing is tickedI can't find these two fields in the Expenses tables. I tried the exm_expenses and exm_expense_reports. Can someone please help me find the column names and the table na… -
Dashboard Filters With Excluded Values Should Have StrikethroughCould the excluded filter choices in a dashboard filter would be displayed with a strikethrough – in the example below it looks to the user like Canceled and Rejected ar…
-
Query to capture payment process request approver name,Number and approved DateHi Team, We have configured BPM rules for Payment process request and we need to capture approver records like approver name, approver number and approved date along wit…
-
Data Variance in Configurable Account AnalysisHas anyone seen data variances in Account Analysis? I am attempting to reconcile my Configurable Account Analysis to my GL Balances and Detail transaction subject area. … -
Does assigning the Procurement Manager Group in FAW consume a license in ERP?We would like the user to view the FAW Procurement Reports and have assigned them FAW ERP Consumer. We want to assign them the Procurement Manager role so they can view …
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' tableWhat is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data using BICC to OACS