To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'… -
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an… -
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict… -
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion … -
Report to find requisition approval reassignmentsContent Hi, We need to create a BI Report showing which requisitions were reassigned to other users. The FND_BPM_TASK_VL/HISTORY tables don't seem to have this informati… -
Navigation : My Enterprise -> EnterpriseSummary My Enterprise -> EnterpriseContent Hi, I am trying to navigate to t My Enterprise -> Enterprise menu from the home page. Even if i have all the relevant applicat…
-
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21A
-
21b Upgrade causes Data Models to FailSummary 21b upgrade has failed testing because of failed to load servlet/dmvalidate errorContent We have had 21b on our 3 test environments and it caused an issue that i…
-
What's your go-to browser for Oracle Fusion Cloud Financials?Summary Firefox? Chrome? Edge? Which one do you prefer--and which do you avoid?Content Like many Oracle users at the City of San Luis Obispo, California, I use Chrome fo… -
ERP Data Deletion/Data RetentionSummary Guidance on capability/ best practice for data retention within Cloud ERPContent Would like more information on the capabilities within cloud to purge/remove dat… -
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea…
-
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…
-
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 937 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle
-
21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Summary 21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Content Hi Experts, We would like to ask 21A Unable to see hist…
-
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…
-
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…
-
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, Vipusha
-
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, Vipusha
-
No data in Account Analysis ReportContent Steps to reproduce: Run Account Analysis Report Process -> Select parameters and filter with some accounts -> Process ends "Success" -> Open the file -> There is…
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec… -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co…
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…
-
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO does not contain creation_date, why?Summary Why does FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO not include creation_date column?Content Why is creation_date missing from BICC Balance Ex…User_2025-03-07-18-57-57-349 964 views 0 comments 1 point Most recent by User_2025-03-07-18-57-57-349
-
Pulling reports dataContent Hi, Is there ways to pull data from BI report say Payables Register Report using any API and push to staging tables from the external application. I have require… -
how to notify once multiple ESS jobs are completed through BI report?Summary how to notify once multiple ESS jobs are completed through BI report?Content We have a requirement of executing ESS jobs like Reevaluation and spot translation i…
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -…