Creating the Database link

Navigation for defining database link is Setup > System > Database Link.

To define a database link in General Ledger perform the following steps
on the Target instance (the one you are copying to):

1. Enter the Database Name and optional Description for the linked database.
(You must also supply the Database Name to the FSG Transfer Program).

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

sql> SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_NAME';

2. Enter the following additional information for the database:

Connect String = The network connect string to point to the
General Ledger database.

Domain Name = The domain of the remote General Leder database
to which this link connects.

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

sql> SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_DOMAIN';

APPS Username = The name of the Oracle Applications account that has
read access to the General Ledger database tables.

NOTE: This is NOT the username you enter to login to Oracle
Applications.

APPS Password = The passwrod for the above username.

NOTE: For security reasons, when you enter the
password, General Ledger will display asterisks
Instead of actual characters in the password.

3. Save your changes before exiting the form.