Financial Statement Generator Definition
Financial Statement Generator (FSG) is a powerful report building tool
for Oracle General Ledger. With FSG, you can:
· Generate financial
reports, such as income statements and balance sheets, based upon data in your
general ledger.
· Apply security
rules to control what financial information can be printed by specific users
and responsibilities in any reports they run using FSG.
· Define your
reports with reusable report objects, making it easy to create new reports from
the components of reports you've already defined.
· Design custom
financial reports to meet specific business needs.
· Print as many
reports as you need, simultaneously.
· Print the same
report for multiple companies, cost centers, departments, or any other segment
of your account structure, in the same report request.
· Schedule reports
to run automatically.
· Produce ad hoc
reports whenever you need them.
· Print reports to
tab-delimited files for easy import into client-based spreadsheet programs.
FSG that has been built can be moved to another server using concurrent
program “FSG Transfer program”. When you
run the FSG Transfer program, you specify the following parameters:
Component Type
|
The type of
object you want to copy. For example, select Row Set to copy a row set from
the source database. Alternatively, select All to copy all report objects.
|
Component Name
|
To copy a single
object of the type specified, enter its name. To copy all objects of the type
specified, leave this field blank. If you entered All for component type, the
program ignores the Component Name field.
To copy selective multiple objects of the same type, you can enter a
percent sign (%) as a wildcard character in the component name. For example,
if the Component Type is Row Set and you enter Sales% for the
Component Name, the program will copy the row sets named Sales01, Sales02,
and Sales03.
|
Source DB Chart
of Accounts
|
The name of the
chart of accounts from which you want to copy report objects. The name must
be entered exactly as it is defined in the source database, since the name
will not be validated.
|
Target DB Chart
of Accounts
|
Enter the name
of the chart of accounts to which you want to copy report objects. The chart
of accounts size, data type, segment separator, and segment assignments must
be identical to the source database chart of accounts.
|
Source Database
|
Enter the name
of the database from which you want to copy report objects. The database name
is created when you define the link to the source database.
|
How To Move FSG Report to Another Database Server
Below the
illustrated steps to move FSG Report to another database server :
1.
Create database link which will connect source db server to
target db server.
Navigation : General Ledger Super User -> System -> Database Link -> New Database Link
Navigation : General Ledger Super User -> System -> Database Link -> New Database Link
- Database : The name of database link. I use “TEST” for value of this field.
- Description : Description of database link. This field is optional.
- Connect string : Setup tnsname for target database server.
Example:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=11.0.2.134)(PORT=1521))
(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=TEST)
- Domain Name : Domain name for target database server.
Example :
XXX.COM
- APPS username : username to connect target database server. In this case, you can fill “apps”.
- APPS Password : password for username that has been filled.
3.
Save the form
4.
Run FSG Transfer concurrent
progam.
Please fill all mandatory field based on the explanation above.
No comments:
Post a Comment