Freeze headers issue in FRS Reports

 Hi Everyone,


In this post let us see an issue encountered while freezing headers in FRS Reports in Oracle Fusion.

Issue: While freezing headers in FRS, we can see output in HTML size changes.

Sample screenshots of Issue:

Screenshot of the report output before freezing headers

Now let us use "Freeze Headers" option in the FRS report.

Freeze Grid Headers option will be present under "Grid Properties" as highlighted below. Check the option.



Now let us see the output of the report one more time


This is how report output changes with this option.

Steps to avoid this issue:

1. Go to File > Page Setup



Page Setup pop appears

Now go to "Workspace Size" tab


Check the option "Use a Custom Workspace Size" and make Width and height to 50


Click "ok"

2. your report will be in Grid1 , select Report1


After selecting Report1

Select the Grid and drag it to the required size by checking the output in between

Checking the output


Now you can see the difference, so expand Grid Vertically and Horizontally as you require.











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