Opening FRS Studio and creating a Report

After Installing FRS Studio, Open it.

Step-1: Enter User Name, Password and Server URL to open Studio.
             Server URL is nothing but Fusion Instance URL

Opening Page

               After giving credentials, Studio opens as follows
Step-2: Go to File > New > Report


         After Clicking on Report


Step-3: Before creating report, we need to set Database Connection
            

              Click on New Database Connection
                                   

            Enter details like Database Connection Name  and others..
            Database Connection Name can be any arbitrary name
            Click "OK"
                 

Step-4: After setting database connection, continue with report creation.
            Go to Insert > Grid


           After Inserting Grid, select dimensions and click on "OK"


         After selecting dimensions, report appears as shown





            




Installing FRS

Installing FRS

FRS stands for Financial Reporting Studio used for Financial Reports in Oracle Fusion

There are 2 ways to install FRS

Method-1:

Go to Fusion Instance > Login > Navigator > Reports and Analytics > Browse Catalog > In Analytics Home Page at Left Bottom, click on "Download BI Desktop Tools" > Download "Financial Reporting Studio" > Install it


Method-2:

Fusion Instance > Login > Financial Reporting Studio >  Open workspace for Financial Reports > Tools > Install > Financial Reporting Center > Install it.



Query to fetch COA Account Fields

 Hi All, A short post to get COA Account Segment related fields. select  fvvv.value, FVVV.DESCRIPTION, fvvv.ENABLED_FLAG  Enabled, fvvv.STAR...