Adding Banner in Fusion Instance

 Adding Banner in Fusion Instance

with few simple steps, we can add Banner in Fusion Instance.

Banner is nothing but "A message displayed at the top of the Instance"

Example : You are using Prod Instance

Adding Banner

Login to Application > setup and maintenance> Tasks> click on search


Search for Manage Administrator Profile Values Task


Open it and search for FND_BANNER_MESSAGE in Profile Option Code


Select first one in search results i.e., FND_BANNER_MESSAGE under Profile Options


Click on Create icon (+) under Profile Values


Enter "Site" for Profile Level and "Any text you want to display" for Profile Value


Save and Close







Previewing Data in FRS without Saving the Report

 Generally in any report we see the output after saving the report. Issue is like if any changes has to be reverted it will be difficult, so FRS provides us options to preview data without saving the report.

We can see the output in either HTML format or PDF Format.

HTML Format:

Open any existing report

goto File > HTML Preview.

This opens report output in a new window.


This how output appears, since I didnot select any values for any segments we cannot see any data

PDF Preview:

Open any existing report

goto File > PDF Preview.

This opens report output in a new window.



Output in PDF Mode







Opening FRS Web Studio

 Hi Everyone,

In this post let us see opening FRS Web Studio.

This is online tool that can be opened from Fusion Instance itself.

Step1: Login to Fusion and open Navigator

goto Others > Financial Reporting Center



Step 2: goto Task list > Open Workspace for Financial Reports

Step 3: goto Tools > Launch Financial Reporting Webstudio


This is how page looks after this



To create a New report: goto File > New > Report


Every report contains 3 parts Header, Body and Footer





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...