Popular Tags
- OTBI 1,441
- Reporting 1,388
- FDI 1,103
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 442
- 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
-
Help with Receivables transaction queryI'm creating a transaction attributes report, and I need to bring the CNPJ (Brazilian company identification number). I have two queries, which I will leave below, but I… -
FAW Data Augmentation - "Versioned Dataset" OptionHi, We are working with the FAW data augmentation interface and noticed an option when creating a new fact or dimension to make the data set Versioned. I was trying to u… -
Used same input parameters for the multiple Grid and need to avoid/revoke from my FRS ReportHello Exports, I have Created the complicated Income statement (IS) in (FRS) and its included the 4 different Grid with in a report. While running the Income statement r…
-
BI Publisher data does not match OAC dataI created a report in BI Publisher, made the connection in FDI to BI Publisher, created a dataset using data augmentation, connected to Oracle Autonomous Data Warehouse … -
Standard template is getting selected while custom template is default in Payables Trial BalanceIn Payables Trial Balance report we have added one custom template which is the default one but sometimes standard template is getting selected automatically. This issue…
-
Where can we find the documentation about the datamodel of a Subject Area?When adding an Attribute in FDI using Semantic Model Extensions (SME) we have to understand the datamodel of the Subject Area. Also when we try to combine data from 2 Su… -
Not able to connect to ADW using SQL developerWe are trying to connect to ADW with OAX_USER using SQL developer but getting error while doing so. But when we try to create connection using OAC DV with same wallet fi… -
How to get other fields or more information from ERP fusion modulesI have the following business need: We want to create an AP report to have consolidated information when preparing payments. This report contains detailed information ab…
-
Groups/Roles flow from ERP Fusion to FDIWe have removed groups from user in ERP fusion environment. But those groups are still assigned to user in FDI. Wanted to know is there any specific job which runs and u…
-
Purchase Requisition Details in CAAHi, Is Purchase Requisitions details are not available to configure in CAA? We can see PO's, Invoices and other details but not Purchase Requisitions. Regards, Shiva -
FAW ERP Data Validation - User Accounts/SecurityMy understanding of how the data validations run is as follows The validation is run against the FAW ADW database (via FAW reporting layer) The validation is run against…
-
Activating a functional area in FDIWe recently provisioned FDI environment and has started configuring FDI. As a first step, we enabled preview features and then generally available features. As a next st…
-
Error in SQL query from a connection to Fusion ERPI established a connection with Fusion ERP, I want to make a manual query through SQL but when I try to do it I get the following message: "There was an unexpected error…
-
Is there a OOTB subject area that contains Corporate Card information?We are looking to create a report based on expenses and corporate cards however are struggling to find this information. Is this data available OOTB in FDI? Thanks, Geor…
-
Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?Ran the Supplier Balance Aging Report and encountered this error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 7…
-
Audit table name for Customer ContactsDear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts. We have…
-
Where can I validate the available space in FDI?Where can I check the space I contracted with Oracle? For example, I think I have 50 GB of storage available, I have been building some reports and even connecting to so…
-
Change currency formatHi, I want to change the format to Colombian pesos, in the list is available the currency, but in the column the system adds the label “COP” instead of the peso symbol “…
-
How can I reuse SQL code generated in OTBI in a Data Model (DM)Here’s the translation to English: I have a question regarding the execution of SQL generated via OTBI. I would like to reuse this report but include some additional ele…
-
What is the cause of this error: ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ?Ran the Supplier Balance Aging Report and encountered this error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 7…