Popular Tags
- OTBI 1,434
- Reporting 1,386
- FDI 1,089
- Analysis and Data Visualization 981
- BI Publisher 847
- Analysis 676
- Oracle Fusion Analytics 581
- Administration 555
- OBIEE 432
- OAC 432
- Analytics 395
- BI Publisher Data Models 350
- Security 292
- Answers 264
- HCM 258
- BIP 257
- Analyses 254
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 183
- Fusion Data Intelligence 163
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
-
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
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' tableWhat is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS
-
Custom separate remittance adviceHi, our customer wants to insert into the separate remittance advice the field regarding Payment Process Profile. What is the respective field for this data? For example…
-
What is the correct query to find the PREPAY_DISTRIBUTIONS and LIABILITY_DISTRIBUTIONS fields in SupWhat is the correct query to find the PREPAY_DISTRIBUTIONS and LIABILITY_DISTRIBUTIONS fields in Supplier Site Assigments and what would be the correct tables and unions
-
In FDI ERP, is there any way to set default dashboards on home page?For example, set the Procurement Overview for Procurement users? Or any similar functionality?