Fusion Financial reporting
Discussion List
-
OTBI Report how to only have the last valueSummary I have a report for asset that have cost and Net book value, but i have all the different net book value instead of only having the last net book valueContent He…Francis Thériault 59 views 5 comments 0 points Most recent by Muhammad Hamza Hanif Reporting and Analytics for ERP -
Standard report shortcut icon by name on dashboardSummary Seeded Report icons by namesContent There are multiple reports in the Report and analytics Based on client need can we make shortcuts of reports as icon on the d…Umer.Farooq 225 views 22 comments 2 points Most recent by Umer.Farooq Reporting and Analytics for ERP -
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl…MaartenDIF 143 views 8 comments 1 point Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
URL to download expense report attachments from UCMSummary URL to download expense report attachments from UCMContent Hi, I am trying to download the attachments in my expense report from UCM. I was able to fetch the DM_…Shifa Nazumudeen 199 views 8 comments 1 point Most recent by Shifa Nazumudeen Reporting and Analytics for ERP -
Dynamic headings in columns when using relative promptsSummary Would like to be able to change the heading dynamically to proper formatting for our business, without hardcoding. We are using relative to prompt for accounting… -
Creating Custom Account Analysis ReportSummary Create Account Parameter(Similar to Oracle seeded Account Analysis Report) in Custom BI report(ESS Job)Content Hello, I am creating a custom bI report similar to…User_2025-01-28-02-08-49-904 149 views 1 comment 0 points Most recent by User_QEU3G Reporting and Analytics for ERP -
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…Justin M Roth 32 views 2 comments 0 points Most recent by Justin M Roth Reporting and Analytics for ERP -
BI Reports Usage AnalyticsContent Hello, Is there a way we can see the last time a specific BI report has been accessed by any user? Thank you Version 19DUser_2025-02-05-02-16-41-526 60 views 3 comments 0 points Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP -
Report completed in errorsSummary OTBI report completed in errorsContent Hi all, I have custom a OTBI report with data model and layout. Also, I have defined the ESS job in SaaS for user to submi…User_2025-02-04-05-26-22-197 37 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks, -
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data…Mahgoub S.Mohamed 422 views 3 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…Shweta Prithviraj-163613 39 views 0 comments 0 points Most recent by Shweta Prithviraj-163613 Reporting and Analytics for ERP -
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…User_2025-02-04-18-03-15-131 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP -
Using a graph as filter to another graph in Analysis?Content In Tableau I can easily use a graph (lets say, a vertical column of income per month) to filter another graph when clicked on the first one (ie, a second one wou…User_2025-02-07-06-48-26-537 49 views 5 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP -
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 73 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI …Senthilrajan V 176 views 12 comments 0 points Most recent by Manjunathan S-Oracle Reporting and Analytics for ERP -
OTBI Analysis to FTP/MS SharePointSummary Publishing OTBI report to MS SharePointContent All - Do you know if there is a way to send an OTBI analysis to external location like FTP or MS SharePoint server…Hari Thyagaraj 123 views 0 comments 1 point Most recent by Hari Thyagaraj Reporting and Analytics for ERP -
How to query all expensesSummary How to I set up the user of my analysis on a dashboard so that they can see all expenses? By default it seem my user can see only my own expenses and those of th… -
SmartView Performance/LimitationsSummary SmartView Performance/LimitationsContent We are a fairly new Oracle fusion customer and I'm curious if anyone can explain if there are limitations to SmartView t…User_2025-02-04-18-03-15-131 54 views 4 comments 0 points Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP -
Poor Performance of Financial Reporting Web StudioSummary Oracle Hyperion FRS ( Desktop App) or FRS Web Studio ? - Which to be usedContent Which is the preferred way to build a FRS report, Oracle Hyperion FRS ( Desktop …User_2025-02-05-07-43-41-391 74 views 2 comments 3 points Most recent by Iain Elvin-135965 Reporting and Analytics for ERP -
Order to Cash InfoletSummary Unable to view analytics for O2CContent Hey all, I am new to working with Infolets and I am currently having issues displaying any of the Order to Cash analytics… -
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th… -
Unable to find Payables Invoices - Line Distribution for OTBISummary Report for AP invoice line - Account distributionContent I am writing a report in OTBI and I cannot find the Invoice Lines Distribution. The subject area is : Pa…User_2025-02-04-22-27-16-622 68 views 1 comment 0 points Most recent by Jen W. Reporting and Analytics for ERP -
Trial Balance Report in JapaneseSummary Looking for Trial Balance Report in Japanese language. How to generate this and what privileges are needed for the user and steps to be followed?Version 20AUser_2025-02-07-02-12-25-586 22 views 0 comments 0 points Most recent by User_2025-02-07-02-12-25-586 Reporting and Analytics for ERP -
User_2025-02-04-14-03-09-386 27 views 0 comments 0 points Most recent by User_2025-02-04-14-03-09-386 Reporting and Analytics for ERP -
Financial Reporting Center - Not sync'd real-time with OTBI?Content When creating an Analysis, Dashboard, etc. in OTBI it does not show up in the Financial Reporting Center for some time (many hours). Is this by design? Is there …Jen W. 162 views 4 comments 0 points Most recent by User_2025-02-07-07-31-07-515 Reporting and Analytics for ERP -
Cover Page in Report BookSummary I have a Report Book with a title page - the title page will only render if the book is run from EPMContent I have a report book with a cover page. If I run the …User_2025-02-06-10-37-19-523 20 views 0 comments 0 points Most recent by User_2025-02-06-10-37-19-523 Reporting and Analytics for ERP -
Multiple selection for Enterprise Scheduler JobContent Hello, Is it possible to do a multiple selection for a parameter in Enterprise Scheduler Job ? We don't have seen option to do this, and we can't write like this… -
EFF in Fusion ERPSummary EFF in Fusion ERPContent Hi All, What are EFF Flexfields in Fusion Financials and how to access them from OTBI subject areas and their tables. ThanksAmarnath Govindu 99 views 7 comments 1 point Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP