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$parameter
WHERE 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$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 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)
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.
See Also
FSG Transfer Program