Adding DBlink from GL Responsibility

on Tuesday, December 1, 2009

To create an FSG report from Database instance "UAT" to instance "PROD" (import the report).
The COA setup of both instance should be the same.

Only one step needed :

From GL Super User, navigate to (N) à Setup à System à Database Links

Specify the below,

Database

UAT

Connect String

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.10.139) (PORT=1522)) (CONNECT_DATA=(SERVICE_NAME=UAT)))

Domain Name

WORLD

APPS User Name

APPS

APPS password

apps (use your password)

Done, You could try to import the FSG report from UAT instance to PROD instance

Note:

The connect string is the same connection string taken from client's (e.g. your PC)  tnsnames.ora file