Home » Developer & Programmer » Data Integration » sql statement for fusion database and own database
sql statement for fusion database and own database [message #664901] Thu, 10 August 2017 09:21 Go to next message
ravulasri
Messages: 1
Registered: August 2017
Junior Member
I have a question.

It is integration project. They have two databases. One is r12 database and another one is fusion database. They transfer some information from former to latter on daily basis.

Client requirement is to compare the output generated in EBS database with fusion database. Client wants a reconciliation report to ensure that data has been safely transferred to fusion database. In the same way, they have another integration between fusion to EBS.

In both cases, they want two reconciliation reports.

Can we write single query to conn to two different databases (viz., r12 database and fusion database) and create one report for inbound and another for outbound.

Is it possible to conn to fusion database using sql (toad,sql navigator).

Pl explain in details

Thanks in Advance
Sri
Re: sql statement for fusion database and r12 database [message #664903 is a reply to message #664901] Thu, 10 August 2017 10:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post URL to documentation for Fusion database.

What exactly should be contained in "reconciliation report"?
Re: sql statement for fusion database and own database [message #664904 is a reply to message #664901] Thu, 10 August 2017 10:55 Go to previous message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
You'll have to talk to your DBA. The standard configuration of EBS and Fusion means that the database listeners will reject any connections that do not come from the Apps middle tiers.
Previous Topic: Save Query results into text file
Next Topic: oracle workflow login
Goto Forum:
  


Current Time: Mon Mar 18 23:50:32 CDT 2024