Copying Report Objects From Another Database (FSG Transfer Program)

Run the FSG Transfer program to copy report objects from one General Ledger database to another. You can copy row sets, column sets, reports, report sets, content sets, row orders, display sets, and display groups.

For example, when you implement General Ledger, you might also define all of your FSG objects in a test database. Once your production database is fully functional, you can easily copy the FSG objects from your test database by using the FSG Transfer program.

Prerequisites

You or your System Administrator must define database links.

The chart of accounts in your source database must be identical to the chart of accounts in your target database.

Any currencies and sets of books referred to by the row sets and column sets being copied must exist in the target database.

Report details, such as budgets and encumbrance types, referred to by copied reports must exist in the target database.

You must be logged in to General Ledger and connected to the target database.

   To run the FSG Transfer program:

1. Navigate to the Submit Request window.

2. Select the concurrent program named Program - FSG Transfer.

3. Enter the program parameters.

4. Submit the request.

5. When the concurrent request finishes, review the report for any warnings and error messages. If there are errors, correct them, then rerun the FSG Transfer program.

Other Considerations

The report produced by the FSG Transfer concurrent request identifies any warnings and error messages which occurred when the program ran. Some of the reasons for warnings include:

• Name collisions: If a report object you are trying to copy already exists in your target database, you will get a warning message and the report object will not be copied.

• Row and column set references: If any of the copied row or column sets refer to a currency or set of books which doesn't exist in the target database, you will get a warning message and the reference will be excluded from the copied row or column set.

• Report details: If any copied FSG reports refer to report details, such as budgets and encumbrance types, which don't exist in the target database, you will get a warning message and the reference will be excluded from the copied report.

If the FSG Transfer program is interrupted, you can resubmit the program with the same parameters. Note that the program will produce warning messages for any report objects that were successfully transferred during the interrupted run. You can ignore these warnings.

Defining Database Links

You can define links to other General Ledger databases by using the Define Database Links window. You give each linked database a name, which you can then use for copying FSG report objects from the linked database into your current database.

For example, when you implement General Ledger, you might define all of your FSG report objects in a test database. Once your production database is fully functional, you will probably want to transfer your report objects to it. To do this, you first create a link from the production (target) database to the test (source) database. Once the link is established, you can copy the report objects by using the FSG Transfer program.

Prerequisites

For both the source and target databases, you or your database administrator must set the DISTRIBUTED_TRANSACTION parameter to a number greater than zero. The parameter is located in the init.ora file on the database server.

You or your database administrator must grant permission for database link creation in the target database by executing the following SQL statement:

grant create database link to <APPS account>

where

<APPS account>

is your APPS account name.

   To create a link to a General Ledger database:

1. Navigate to the Define Database Links window.

2. Enter the Database Name and optional Description for the linked database. You must also supply the Database Name to the FSG Transfer program.

You can find the database name by executing the following query in the source database:

SELECT value FROM v$parameterWHERE UPPER(name) = 'DB_NAME';

3. Enter the following additional information for the database. If you do not know what to enter, ask your System Administrator.

Connect String:

The network connect string to point to the General Ledger database.

Domain Name:

The domain of the remote General Ledger database to which this link connects.

You can find the domain name by executing the following query in the source database:

SELECT value FROM v$parameterWHERE UPPER(name) = 'DB_DOMAIN';APPS Username:

The name of the Oracle Applications account that has read access to the General Ledger database tables. Note that this is not the username you enter to login to Oracle Applications.

APPS Password:

The password for the above username. Note that, for security reasons, when you enter the password General Ledger will display asterisks instead of the actual characters in the password.

See: Creating Database Links

(Oracle 7 Server SQL Reference, Release 7.3)

4. Save your work.

   To delete a database link:

1. Navigate to the Define Database Links window.

2. Query the database name you want to delete.

3. Choose Delete Record from the Edit menu.

4. Choose Yes to delete the database link.

db_domain操作方法记录

col name for a30

col type for a10

col value for a20

show parameter db_domain

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_domain                           string

show parameter name

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_file_name_convert                string

db_name                             string    doudou

db_unique_name                      string    doudou

global_names                        boolean   FALSE

instance_name                       string    doudou

lock_name_space                     string

log_file_name_convert               string

service_names                       string    doudou

alter system set db_domain='com' scope=spfile;

SQL> show parameter db_domain

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_domain                           string

SQL> show parameter name

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_file_name_convert                string

db_name                             string    doudou

db_unique_name                      string    doudou

global_names                        boolean   FALSE

instance_name                       string    doudou

lock_name_space                     string

log_file_name_convert               string

service_names                       string    doudou

虽然我们修改成功了，但是没有立刻生效，我们重启数据库

shutdown immediate

startup

SQL> show parameter db_domain

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_domain                           string    com

SQL> show parameter name

NAME                                TYPE      VALUE

------------------------------------ ---------- ------------------------------

db_file_name_convert                string

db_name                             string    doudou

db_unique_name                      string    doudou

global_names                        boolean   FALSE

instance_name                       string    doudou

lock_name_space                     string

log_file_name_convert               string

service_names                       string    doudou.com

修改db_domain重启数据库后生效！还有一点需注意service_names自动变为doudou.com也就是说当你设置db_domain时，在不设置service_names的情况下，service_names =db_unique.db_domain(为什么会有这个公式，下面会讲)

最新文章

1. virtual memory exhausted: Cannot allocate memory
2. C# 必看书籍
3. sharding-jdbc-how2work 当当的sharding-jdbc剖析(查询)
4. 斯坦福机器学习实现与分析之八（kmeans算法）
5. IBatis.net动态SQL语句(六)
6. javascript photo http://www.cnblogs.com/5ishare/tag/javascript/
7. RSA加密工具包
8. C++ BigInteger 大整数类模板（转）
9. 基于Sql Server 2008的分布式数据库的实践（一）
10. 联想A798T刷机包 基于百度云V6 集成RE3.1.7美化版 精简冗余文件
11. WebxFrameworkFilter 请求响应过程
12. mybatis基础学习4---懒加载和缓存
13. 前端学习roadmap
14. JS求数组差集的几种方法
15. Matplotlib：plt.text()给图形添加数据标签
16. HTML5 ④
17. 菜鸟学Java（十）——分页查询
18. gearman入门初步
19. UVALive 6955 Finding Lines（随机化优化）题解
20. Python3 字典 get() 方法

热门文章

1. Beta-1阶段成员贡献分（代组长更新）
2. Dapper关联查询
3. Bug集
4. Android进程间的通信之AIDL
5. JAVA XML
6. 我所理解的SoC
7. --with-http_realip_module选项（后台Nginx服务器记录原始客户端的IP地址 ）
8. 20145226夏艺华 《Java程序设计》第0周学习总结
9. [erlang]supervisor(监控树)的重启策略
10. spring 事务：注解方式