Fusion Financial reporting
Discussion List
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will …Murthy Kodavati 35 views 4 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…User_2025-02-04-14-03-09-386 279 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386 Reporting and Analytics for ERP -
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR LuckyLucky Sharma 71 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any… -
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T… -
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 264 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
How to call oracle functions from BI Data model ?Summary How to call oracle functions from BI Data model ?Content Hi, In EBS i used to build custom functions and i was using it in discoverer. i am looking for function …Shlomo Elnekave 168 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 491 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
How to increase the query time out in Oracle fusion BIPContent Hi Team, One of report is getting error due to query time out. We want to increase the query time out for this report. Could you please do the needful. Version 2…Jayaprakash Mathakamalli 209 views 6 comments 0 points Most recent by Jayaprakash Mathakamalli Reporting and Analytics for ERP
-
Performance of BI GL balances querySummary Performance of BI GL balances queryContent The Attached BI query timesout when executed with just the tree values. I have passed nulls for the remaining levels c…saravana maneeian subhramaniun 62 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Fixed Assets - Asset Balances Real TimeSummary Assets OTBI Report for CIP not showing balancesContent Hi FA Experts, We built an OTBI report with Fixed Assets - Balances Real Time Subject area to display bala…Muhammad Hamza Hanif 172 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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… -
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 133 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 187 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 128 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 385 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 63 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 166 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 113 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…