Creating data source using using Oracle EBS Database as external tables then BAM Web Application is getting hanged up!!
Steps to replicate :
1. We are using Oracle EBS R12 database as external datasource in BAM. This is done perfectly using BAM Architect -- External Datasources
2. Now While creating Data Objects and selecting above created external(refering to EBS database) data source then external table names.. are not coming up and its keep on processing and getting hanged up !!
I tried increasing the socket time from 600 to 26000 in weblogic and BAM server. But had no luck !!
As suggested by Oracle Support
I have tried replicating the issue but in my case for the first time it took several minutes when I selected external data object and selected datasource from the drop down list. I believe this is not a BUG but dependent on performance.
Problem occurred as result of performance and hardware issue .
I was connecting eBS and SOA Suite ( which are located in different location/environment) and were not in same DMZ and I was connected to Oracle EBS instance over VPN connection too !!