My Oracle Support Banner

FAQ - Financial Reporting Studio and Reports created via FR Studio (Doc ID 2553668.1)

Last updated on JANUARY 31, 2024

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Purpose

This article aims to answer some of the Frequently Asked Questions on FRS Tool and Reports

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 How to Check FRS Client and Server Versions?
 How to Get Financial Reporting Studio Login Server URL?
 What is the user name and password used to launch Financial Reporting Studio?
 How to overcome System Error ''System Error &H80040111 (-2147221231)" in Financial Reporting Studio?
 How to overcome "The number of query result cells exceeds the limit set by the QUERYRESULTLIMIT" error when running FRS Reports?
 Is there any seeded FRS report like P&L, Cash Flow Statements, Income Statement, and Balance Sheet?
 Can the reports created using the Financial Reporting (FR) Studio be set as Dashboard Reports?
 Can the FR Studio reports be mailed to users automatically?
 Can the FR Studio reports be made as ESS Scheduled Jobs?
 Can we use parameter on FRS Reports (i.e. based on filters)?
 Why Drill-Through functionality is not working on the balances in all cells in FRS report?
 How to enable Client Logging in Financial Report Studio ?
 Why Report Borders doesn't display in HTML View?
 Why Drilldown Navigating to Home UI instead of GL Inquire UI?
 Why FRS report PDF view is splitting across pages, though there are no page breaks in report?
 Why expanded data in HTML view are not honoured in PDF view from FRC?
 Why "Expand All" features in not working in 2nd Page, when working fine for first page?
 Why report Not Showing any Balance/Showing #Missing Value?
 How to overcome below error which encountered while launching Financial Reporting Tool from browser?
Financial Reporting Studio is not installed on this machine. To download Financial Reporting Studio installer from Workspace, select Tools, then Install, and then Financial Reporting Studio. After download is complete you must close all browsers and then run Financial Reporting Studio Installer.
 Why option "Grid Properties > Hide Grid Border in HTML" is missing in FRS client tool?
 How to deliver FRS report output to SFTP location configured in BI Publisher?
 How to default Current period in report prompt?
 How to get DFF values in FRS report?
 How to move FRS reports from source instance to target instance?
 How to schedule FRS report to get attachment as Excel instead of PDF?
 How to use variables created in ERP calculation manager from workspace in FRS Report?
 How segment value security works in FRS report?
 How to use same Dimension in both Row and column Level?
 How to get Month in row and Dates in Column OR vice versa in FRS report?
 How to use bursting to deliver FRS Report output in a batch?
 How to create substitution variables and access them in FRS?
 Why do some Accounting Period Values have [AccountingPeriod] prefix ? Example: 2016, 2017, 2018, [AccountingPeriod].[2019], [AccountingPeriod].[2020] etc?
 How to get the data with combination of Quarterly periods + PTD as amount type?
 How to display only accounts which have balances in report?
  
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.