Fusion Financial reporting
Discussion List
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 108 views 8 comments 0 points Most recent by User_BMLQW Reporting and Analytics for ERP -
How quickly does Oracle make updates to federal reports?Summary: When the federal government makes changes to a federal form, such as the Federal Financial Report (FFR), how quickly does Oracle make this change to the report …
-
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…
-
Open FRS report using a URL link from BI Tile or similar?Summary: Fusion Financials: How to open a FRS report via a URL link from a BI reporting tile or similar? Content (required): Is there any way to open a FRS report via a …Robert of STAU 36 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 1 view 0 comments 0 points Started by Jaeyshree Kumaran Kalpana Reporting and Analytics for ERP
-
Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Subject areaSummary: I am trying to calculated the Historical Depreciation & Total Accumulated Depreciation from " Fixed Assets - Depreciation Real Time" subject area. There seem to…
-
FA Asset NVB report output languageSummary: I want to download FA Asset NVB report in Chinese, but it came out in English. How can I change the language even though my preference setting prefers English a…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …Rashmi M-Oracle 21.3K views 89 comments 26 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)? -
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 21 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaKrishna-Oracle 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…JBabbit121 81 views 12 comments 0 points Most recent by Dylan Levine Reporting and Analytics for ERP
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 81 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
How to View the Output of an ESS Jobs Submitted By Another User Based on Role?Summary How to View the Output of an ESS Jobs Submitted By Another User Based on Role?Content Hi Everyone, Can anyone please share your thoughts How to View the Output o… -
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 21 views 1 comment 0 points Most recent by Anca Amarghioalei-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 51 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V…huronstevesmith 31 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…Abhishek khanduja 41 views 1 comment 1 point Most recent by User_COQ97 Reporting and Analytics for ERP
-
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…JBabbit121 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment…Anders W. Langholm 21 views 5 comments 0 points Most recent by Julia Looi Reporting and Analytics for ERP -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
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 5K views 137 comments 41 points Most recent by VaradaYarasani Reporting and Analytics for ERP -
Can the Workflow Transactions Listing report show workflows other than related to invoices?Summary: There is a Scheduled Process called 'Workflow Transactions Listing' which shows pending and rejected transactions related to invoices. Is there something simila…
-
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 31 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…u20161212 11 views 4 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 10 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
Missing data in some columns in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVSummary: Hi We can see all our columns in our COA, but there is only data in segment1. What do we need to do in order to see more data? Content (required): Version (incl…Bo Tøpgaard 31 views 4 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 21 views 0 comments 0 points Started by Sasidhar_Araja Reporting and Analytics for ERP
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia-Oracle 71 views 1 comment 2 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP