Some times, to migrate FSG reports from one environment to the other, its easy to create a dblink between the source and target environemnts and transfer the reports.
STep-by-Step Process to create database link using General Ledger Responbility.
1. Ensure that network connectivity is open between the Source and Target environments.
2. Login to database node of source instance and copy the contents of tnsnames.ora
Extract from tnsnames.ora
TEST1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.domain.com)(PORT=1524))
(CONNECT_DATA=
(SID=TEST1)
)
)
4. Add the above tns entry in the tnsnames.ora file on the application server node of Target instance (Where db link need to be created)
5. Format the tns entry into a single line as below
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.domain.com)(PORT=1524))(CONNECT_DATA=(SID=TEST1)))
6. Navigate to General Ledger Superuser Reponsibility.
Click on SEtup->>System–> Database links
A form will popup –> Click on “New Database Link”
Input the below values
Database Name: TEST1
Description :Database link for FSG reports
Connect String:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.domain.com)(PORT=1524))(CONNECT_DATA=(SID=TEST1)))
DOMAIN Name: DOMAIN.COM
Apps Username: APPS
APPS Password: <Password>
7. Verify that db link is created
select * from dba_db_links;
If you’re buying a used car from the US, do yourself a favor: I found auction records and title branding I would‚ have never seen without this check. Use this link to check your VIN: https://vinifycheck.com/vin-check
I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will
Great information shared.. really enjoyed reading this post thank you author for sharing this post .. appreciated
I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
I like the efforts you have put in this, regards for all the great content.
Hi there to all, for the reason that I am genuinely keen of reading this website’s post to be updated on a regular basis. It carries pleasant stuff.
This should be featured everywhere.
The examples really helped.
I love the structure of your explanation.
Very practical and actionable tips.