Thursday, February 23, 2012

How To Set Up FSG To Run Overnight

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com


Problem: How To Set Up FSG To Run Overnight


Symptoms:

How do you set up FSG (Financial Statement Generator) reports to run overnight?

Solution:

Define an FSG report set and schedule it for resubmission by following the
steps listed below:


I. Add Program - Run Financial Statement Generator to Request Group
----------------------------------------------------------------
Responsibility = System Administrator
Navigation = Security -> Responsibility -> Request
Form Name = FNDRSGRP (Request Groups)

1. Navigate to the Request Groups form.

2. With your cursor in the Group field, click on Query/Find or use the
flashlight icon and select GL Concurrent Program Group.

3. The Application field will populate once the group has been selected.
The Code field leave blank. The Description field will populate once
the group has been selected.

4. Under the Requests Type column, place your cursor on any field in
that column then click on Edit/New Record from the menu bar. This will
insert a row.

5. Type = select Program
Name = click on LOV (list of values) and select
Program - Run Financial Statement Generator

6. Save your changes before exiting the form.


II. FSG Program to Allow Standard Submission
----------------------------------------
Responsibility = System Administrator
Navigation = Concurrent -> Program -> Define
Form Name = FNDCPMCP (Concurrent Programs)

1. Navigate to the Concurrent Programs form.

2. Click on Query/Enter from the menu bar.

3. Enter RG30RFSG in the Short Name field.

4. Click on Query/Run from the menu bar.

5. In the Request region, make sure the Use in SRS check box is
checked [X].


III. Define Report Set
-----------------

Responsibility = General Ledger Superuser
Navigation = Other -> Report -> Set
Form Name = FNDRSSET (Request Set <request parameters="">)

1. Navigate to Other/Report/Set after switching responsibility to
General Ledger Superuser.

2. Name: Enter a name for your report set.

Description: If desired, enter a description for your report set.

Application: Select Oracle General Ledger from your LOV.

Owner: System will automatically populate this field with your
user name (Note: this field can only be changed by a
System Administrator).

3. Active Dates
------------
Start Date and End Date: Define an effective period when you will run
the request set.

Note: if the current date is outside the date you define, the request
set will not be available in the Submit Requests Window.

4. Execution
---------
Sequential: Runs reports one at a time in the specified order.
Define your report set to run sequentially if a report
depends on the results of a prior report.

Parallel: Runs reports at the same time in any order.

5. Run Options
-----------
Abort on Error: If running sequential report set, you can specify
whether to stop the report set if there is an error,
or continue running the rest of the reports in
the set.

Note: if your request cannot run because it has been disabled,
your request set fails, even if you do not check the Error on
Abort check box.

6. Incompatabilities Allowed: Leave this box unchecked to specify that
the request set may run with all other
concurrent requests or report sets.

7. Print Together: Check this check box to send all your requests to the
printer together when they complete or leave this box
blank to send each request one at time to the printer
as it completes.

8. Requests
--------
Seq: Define a sequence for each report you want to run in this
report set.

Name: Select desired report from LOV. If you want to include FSG
reports, select Program - Run Financial Statement Generator.

Application and Description: Automatically populates once a
report name has been selected.

Note: the list of requests you can choose includes the request
which your responsibility allows you access to from the Submit
Request screen.

9. Print Options
-------------
Copies: Enter desired number of copies to print.

Style: LOV available for some reports - others it will populate.

Save: Check this box if you want to save to a file.

Printer: Click on LOV and select a defined printer to print reports to.

Note: once the Printer has been selected, the system will automatically
move the cursor down one line. In order to set the parameters for a
report, you will need to move cursor back up to the desired line.

10. Click on the [Parameters] button. This will take you to the
Request Parameters Screen.

-- On the report line, select Default Type = Constant

-- Value: you must type in the EXACT FSG name, there is no
list of values (LOV) available for this field.

-- Period: you can specify the period as a shared parameter.
Again, you must type in the EXACT period name, there is no
LOV available for this field.

Also, on this period line, remove the default type of
SQL Statement. The type and value should be balank if you
are using a shared parameter

11. Save your changes before exiting the form.


IV. Assign Request Set to Security Request Group for GL Responsibility
------------------------------------------------------------------
Responsibility = System Administrator
Navigation = Security -&gt; Responsibility -&gt; Request
Form Name = FNDRSGRP (Request Groups)

1. Navigate to Security -&gt; Responsibility -&gt; Request.

2. With your cursor in the Group field, click on Query/Find from the
menu bar or click on the Find (flashlight) icon on the toolbar
and select GL Concurrent Program Group.

3. After selecting GL Concurrent Program Group, the Application
(Oracle General Ledger) and Description (Program group that includes
all other GL program groups) will default in.

4. With your cursor in the Requests Region of the form, click on
Edit/New Record from the menu bar. This will insert a row for you.
Add the program as follows:

-- Type: Set

-- Name: <new report="" set="">

-- Application: Oracle General Ledger


5. Save your changes before exiting the form.


V. Run Report Set from GL Responsibility
-------------------------------------
Responsibility = General Ledger Super User
Navigation = Reports -&gt; Request -&gt; Standard
From Name = FNDRSRUN (Submit Requests)

1. Navigate to the Submit Requests form.

2. Type = Set
Name = Your report set name

3. Tab thru each line listed in the Request Set Programs to make sure
the parameters are set for each individual report.

Note: if you need to change the Period, you only need change it on
one report, because if you set it up as a shared parameter it will
automatically make the same change on the other reports in the
request set.

4. If you want to set-up this report set to resubmit on a regular basis,
then go to the Run Options section.

-- At the Resubmit pop-list, select Interval, then enter the required
information as desired.

-- This is discussed in detail in the General Ledger, Release 10.7
Reference Manual, pages 3-52 through 3-54 under Run Options Zone.

References:

How To Set Up FSG To Run Overnight [ID 1058967.6]

Oracle General Ledger Release 10.7 Volume 1, Reference Manual,
part number A13112-5, pages 3-52 through 3-54.

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: