Popular Tags
- OTBI 1,450
- Reporting 1,395
- FDI 1,130
- Analysis and Data Visualization 988
- BI Publisher 858
- Analysis 682
- Oracle Fusion Analytics 593
- Administration 555
- OAC 469
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 358
- Security 295
- HCM 270
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 202
- Fusion Data Intelligence 193
- Report Output 184
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
-
I am hitting FAW Functional area prerequisite error, Can anyone help?I was able to activate Functional Area of order management Successfully, but all other functional area of SCM and ERP are failing with an prerequisite error. Can anyone … -
What is the function of the Identifier attributes in FDI Subject Areas?I some Subject Areas there are Identifier attributes. E.g. Purchase Order Header Line Identifier or CMR Distribution Identifier in the Subject Area Procurement - Receipt… -
Data Fragmentation in FAWIs data fragmentation possible in FAW? Current data from fusion applications is in a standard ADW OAX_USER schema ERP history data has been migrated to ADW custom schema… -
How to pick right Functional Group in configuration context.Hi, I was trying to get right combination of Cost Center and Balancing segment, I used Functional Group which helped me to get 'AND' clause and resulting are appearing a…
-
How to find the information of different view objects using same tableHi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spreadsheet …
-
Is there a way to derive the financial category to Main Category and Subcategory in FAW?How can we derive the financial category to the main category and subcategory in Faw, as shown in the below example?
-
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…