Training Manual - FSG Report Publishing

NIB BANK LIMITED
Training Manual
Publishing Financial Statement Generator
Reports
Index
1. Overview ..................................................................................................................... 3

2. Designing a Financial Report Template ................................................................... 3
2.1 Navigation path ............................................................................................................................. 3
2.2 Creating a template ....................................................................................................................... 3
2.3 Formatting a template ................................................................................................................... 5
2.4 Uploading template to Oracle ....................................................................................................... 6
3. Running FSG Reports through “Financial Report Submission”............................ 8
3.1 Navigation path ............................................................................................................................. 8
3.2 Entering submission parameters ................................................................................................... 8
3.3 Publishing Parameters ................................................................................................................... 9
3.4 Selecting a Storage Location....................................................................................................... 10
3.5 Submitting a Report .................................................................................................................... 11
3.6 Viewing a Report ........................................................................................................................ 13

1. Overview
By default FSG report outputs are generated in text formats that have little or no options
of formatting. Oracle provides much more flexibility in the formatting of FSG reports.
Following sections will explain how to create various report templates using “Financial
Report Template Editor” & Running FSG Reports using “Financial Report Submission”.
2. Designing a Financial Report Template
2.1 Navigation path
In order to create a new FSG Report template double click “Financial Report Template
Editor” in your General Ledger responsibility. As shown below:
Screen Shot 2.1
2.2 Creating a template

Following web page will appear. This page has two sections:
• Report
• Editor Selection
The Report section is where the user will select the report on basis of which template will
be designed. Here the report selection is just for reference purpose. Select Create New for
a new template or give the name of an existing template if you want to modify a template
uploaded earlier. In the section named Editor Selection the user will select Excel
Template Editor as the Editor so that he can do all the formatting in excel software.
Screen Shot 2.2
Once the base Report Name, Template Selection & Editor have been given the user will
click create button, a system message as shown in Screen Shot 2.3 will appear.
Screen Shot 2.3
Do not close the window until an excel work sheet opens.

Screen Shot 2.4
The system will prompt to interact with the ActiveX the users must allow this interaction
and click Yes. After the interaction has been allowed the report will open in excel as
shown in Screen Shot 2.5 and the user can use different formating options of excel to
present an FSG report. Such options include Font formatting, conditional formatting,
inserting pictures, cells shading etc.
2.3 Formatting a template

In order to insert an image in the report go to insert>Picture>From File and select the
picture to be inserted. Resize the picture as per the requirement. Use Excel standard
functionality to insert and manipulate images in your template. The following image
types are supported: PNG, GIF, JPEG, and BMP (Microsoft converted). The Excel
Picture Toolbar Image Control options are all supported: Grayscale, Black and White,
Watermark.
Screen Shot 2.5

2.4 Uploading template to Oracle
Once all the formatting has been completed upload the template using oracle menu in the
menu bar as shown in Screen Shot 2.6. Enter the upload parameters as shown below and
click upload.
Screen Shot 2.6
A confirmation message will appear indicating if the template has been successfully
uploaded to Oracle, refer Screen Shot 2.7. Close the confirmation box.
Note: The Enable Drill option is specific to General Ledger and allows the user to drill
into report values using the Account Analysis and Drilldown feature. For more
information, see the Oracle General Ledger User's Guide.
Screen Shot 2.7
Close the excel sheet. It doesn’t matter if you close it with or without saving as the
template has been uploaded to Oracle server and the report will you that particular
template to give the output when it is run.
Screen Shot 2.8

3. Running FSG Reports through “Financial Report
Submission”
3.1 Navigation path

Double click on “Financial Report Submission” in the GL responsibility.
Screen Shot 3.1
3.2 Entering submission parameters

A web page will open requesting various FSG report parameters that are the same as the
user use to enter while running FSG reports normally. This is called the submission
parameters refer to screen shot 3.2.
Screen Shot 3.2
Parameters with “*” are compulsory. Select NIB Primary Ledger from the list of values
in the Ledger parameter and click Next.
3.3 Publishing Parameters

The next page that appears contains the Publishing Parameters in which the user will
select the Template in the Default Template region and the timeframe for which the
report is to be run and click Next.
Screen Shot 3.3
If the default template is not known the user can search it through a list of values by
clicking on the magnifying glass icon next to the field. Once the template has been
selected, click Next.
3.4 Selecting a Storage Location
Next page contains the information of storage location that is the location where the
output once generated is to be stored. This is the locations on the server. User can use
same location for various reports or create different folder for different reports.
Screen Shot 3.4

3.5 Submitting a Report
Once the location has been selected user will go to the next section of presentation,
without selecting anything click next the following page will appear showing all the
information and parameter that the user has entered so far. If any changes are required
click Back and go to the relevant section else click submit and the report will be
submitted.
Screen Shot 3.5
Once the report is submitted following confirmation message will appear and a request id
will be allotted to the report. Click on the Monitor Requests to monitor the status of the
report and view its output once the report has been completed.
Screen Shot 3.6
Screen Shot 3.7
As long as the report is in pending or Running Phase the user cannot view the output of
the report. For each FSG report run using the report submission path Publish and
Presentation Program is automatically submitted by the system.
3.6 Viewing a Report
Screen Shot 3.8
Once the request with the name “Publish and Presentation Program” is completed user
can view the output by simply clicking on the output icon against the Request ID as
shown in the above screenshot. When the report output is requested following web page
will appear.
Screen Shot 3.9
The user must click “ View Report Now” to view the output of the report. A webpage
with following options will appear.
Screen Shot 3.10
Select the relevant Output Type for example excel or pdf to view the report. Here in
example pdf output is selected and the output of the report would be as shown in the
screenshot below.
Screen Shot 3.11

Training Manual - FSG Report Publishing

Uploaded by

Copyright:

Available Formats

Training Manual - FSG Report Publishing

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Training Manual - FSG Report Publishing

Uploaded by

Copyright:

Available Formats

NIB BANK LIMITED

1. Overview ..................................................................................................................... 3

Screen Shot 2.1

2.2 Creating a template

Screen Shot 2.2

Screen Shot 2.3

Do not close the window until an excel work sheet opens.

2.3 Formatting a template

Screen Shot 2.5

Screen Shot 2.6

Screen Shot 2.8

3.1 Navigation path

Screen Shot 3.1

3.2 Entering submission parameters

3.3 Publishing Parameters

3.4 Selecting a Storage Location

Screen Shot 3.4

Screen Shot 3.5

Screen Shot 3.7

Screen Shot 3.8

Screen Shot 3.9

Screen Shot 3.11

You might also like