Fusion Financial reporting
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 430 views 11 comments 10 points Most recent by SankarBalu Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 1.1K views 13 comments 21 points Most recent by SankarBalu Reporting and Analytics for ERP -
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun_Jain-Oracle 9 views 1 comment 0 points Most recent by Karun_Jain-Oracle Reporting and Analytics for ERP -
How to find Parameters passed for scheduled ESS jobSummary: ESS job 'Purge interface tables' was scheduled 4 years back for AP invoice, due to some issue we cancelled the schedule and now we want to find the parameters u…Nidhi Chhajed 735 views 16 comments 0 points Most recent by Subba Rao-Oracle Reporting and Analytics for ERP
-
DTD and Index file for Germany tax reportingWe have a Legal Entities registered in Germany and we have to submit data to German tax authority. For this, I have followed the note id Oracle Fusion Cloud ERP: Germany…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 2.7K views 26 comments 29 points Most recent by Rizwan Basha Reporting and Analytics for ERP
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 19 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 6.5K views 149 comments 44 points Most recent by Bob Sheldon-Oracle Reporting and Analytics for ERP -
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…Jacqueline Fournier 169 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP
-
Query To Find Label Name For Each Node ValueSummary: Dear All, I need a Query to extract Label Name for each Node Value. Content (please ensure you mask any confidential information): Dear All, I need a Query to e… -
FRS - Member Descriptions and AliasSummary Alias concatenating Name and Description, and Description is blankContent Can anyone help explain why the Member Alias (Default) in FRS merges the Value and the …
-
Making Tax Digital - UK VAT ReturnsSummary Report needed to extract data for HMRC VAT returnContent All VAT registered businesses in the UK are required to submit their monthly VAT returns to HMRC electro…Patrick Haston 179 views 5 comments 2 points Most recent by Patrick Haston Reporting and Analytics for ERP -
FRS - Selecting multiple values for Point of ViewSummary: Selecting multiple values for Point of View Content (required): Hi All, We have a requirement to selct multiple values for the POV when selecting the initial re…
-
Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsSummary Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsContent Hello Team, I am looking for the source code or Data base tables w… -
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 32 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
Custom FRS Reports not showing up in Financial Reporting center post P2T RefreshSummary: Our Custom FRS Reports are not showing up in Financial Reporting center post P2T Refresh but we are able to access reports using EPM Workspace. This is working …Abhilash K - Deloitte USI 14 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
FRS Workspace Server Settings - Impact to changing timeout valuesSummary: On Oracle Fusion, Finacial reporting studio, workspace server settings, want to understand the impact of changing the timeout values for session timeout and Kee…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 25 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP -
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 29 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): …Niall McColl 24 views 3 comments 0 points Most recent by Niall McColl Reporting and Analytics for ERP -
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th… -
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 26 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 34 views 1 comment 0 points Most recent by Oracletechnofunctional Reporting and Analytics for ERP
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 178 views 4 comments 0 points Most recent by Subbareddy Kandala Reporting and Analytics for ERP -
Taxable lines in journal entries not generating in the Deductible VAT Declaration Report for FranceHello, We are encountering an issue whereby taxable lines in journal entries are not being generated in the Deductible VAT Declaration Report for France. Taxable Purchas… -
Privileges required by the FAWService account that is created in Oracle Fusion ERP and used by FAWWe are creating the FAW instance and configuring out of box Pipeline between ERP and FAW to get the ERP data. For this purpose we need to create a user in ERP that can b…Seema_Intact 24 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)…Josh Vincent 21 views 2 comments 0 points Most recent by Josh Vincent Reporting and Analytics for ERP -
FRS Batch Scheduler/Bundling does not have expand all capability when users click into HTML linkOracle Fusion General Ledger Cloud Service - Version 11.13.23.10.0 and later In Oracle Financial Reporting Studio, after creating a bundle and scheduling reports through…
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second…