Sunday 4 November 2012

Database Link Creation from Frontend for FSG Report Transfer


General Ledger Super User GUI >>> Setup >>> System >>> Database Links >>> Click on the [New Database Link] button and provide relevant information.
Program Name = RGXGDDBL (Define Database Links)

Purpose: Use the General Ledger Financial Statement Generator (FSG) Transfer Program to transfer FSG data from an application instance database instance(CRP1) to another database instance(UAT).

Make sure the followings are present before creating the Database Links:
GRANT CREATE DATABASE LINK TO APPS;
Global Name Related Settings......

For step-by-step instructions on creating a database link, refer to Oracle General Ledger Release 10SC, User's Guide, part number A21643-7, pages 4-81 through 4-82.

Cheers !!!!

1 comment: