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