Popular Tags
- OTBI 1,455
- Reporting 1,397
- FDI 1,144
- Analysis and Data Visualization 988
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 596
- Administration 556
- OAC 479
- OBIEE 434
- Analytics 409
- BI Publisher Data Models 359
- Security 296
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 218
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 195
- Report Output 184
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
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
-
Transaction Console Invoice Approval HistoryI am trying to create a report to retrieve information from the transaction console related to invoice approval history. I'm using the tables and SQL below, however, in … -
An user cannot view data with the role: FAW Licensed ERP Consumers RoleHello, I have user #1 to which I have assigned the license role: FAW Licensed ERP Consumers Role I have user #2 which has the license role: FAW Service Administrator Rol… -
Fusion security context does not synchronize in FDIIt is necessary in the FDI administration console to make a "security assignment" so that the user can access the information. For example, if the user has the role Acco…
-
Information does not appear in a language other than EnglishFor example, the pre-built AR report “AR Transactios Activity Analysis” if I log on in English, the report description for the line appears, which is: “Avg Invoice Amoun…
-
How can we reverse receipts in bulk using SOAP webservice?https://docs.oracle.com/en/cloud/saas/financials/24d/oeswf/receivablesstandardreceipt-d16509e11004.html#receivablesstandardreceipt Used Service WSDL URL: https://servern… -
How to utilize and access oracle provided KPI'sHow can we utilize prebuilt KPI's In Oracle Analytics? Content (please ensure you mask any confidential information): Oracle Analytics ( ERP) KPI's and Dashboards Versio… -
Why are security assignments being removed by system?Every morning we have 4 users whose AP BU security assignment gets removed by "system". Evidence is shown in the FDI > Security > Activity screen. These users have diffe…
-
ERP Analytics - Cross functioncal ReportHi Experts, Have someone created FDI ERP analytics workbook, showing projects, task, Purchase reqs, Purchase orders & Finance AP Invoices. I am able to get workbook havi… -
Log file modification when we submit the ESS jobHi Team, Is it possible to modify the log file generated by the custom ESS job. Actual requirement is, when user submitted the ESS job from schedule process window,if ES…
-
How to Create Case If Calculation with Multiple ConditionsHow can I create a case if expression with multiple "if/then" conditions? For example: If supplier name is null, then journal description, and if journal description is …
-
prior year-to-date metricHi, I'm trying put together a financial statement with one single visualization that has the following columns: Current year Actuals, Current Year Original Budget, Curre…
-
Projects Rest API giving duplicatesBelow is a Rest API we are using to get Projects data with filters but the response is giving duplicate records. Please let me know what is wrong here. Rest API below: /…
-
Can Contract Number be added to Procurement SA PO Header DetailWe are able to include PO data in contract analysis, but we cannot do the reverse at the moment. It would be extremely helpful to have the contract number available in t…
-
What is the difference between Refresh Data and Reload Data within the functional areas?I would like to know the difference between these two options within the functional areas, because we made an update in the financial categories of the accounts but the …
-
Question on how to get a earliest AR transaction date based on outanding balance into a balance repHello, I'm working on an analytics using the Financials - AR Transactions subject area What I am pulling in is: Attributes: Customer Name, Customer Number, Customer Acco… -
Which financial categories to enable to display information in the pre-built reports?Hello team, I am going through the pre-built FDI reports, however, many of the reports do not return information. For example: I would like to know what financial catego…
-
Supplier On-time Payment Prediction. Subject area detailsHI All, We need more clarity on the On-time payment prediction columns , So far we have only found a fried definition on the documentation: https://docs.oracle.com/en/cl… -
Is there any vulnerability scan available/possible on queries written in BI Reports?We create multiple custom BI reports mainly on financial modules. We would like to apply vulnerability scan on custom codes we develop for BI Reports. Is there any Oracl…
-
Why is the Item defaulted from BPA on the when the PO is sourced from BPA?The Item is getting defaulted from BPA on the when the PO is sourced from BPA. Item Description should be defaulted on the PO from Item Master.
-
Metrics in collections failing due to restricted charactersIs there a recommended approach for a customer name that contains restricted characters so that metrics for that customer can be built? We have a number of customers tha…