Application Data Source

E-business Suite now provides a Standard Data Source (javax.sql.DataSource) which can be used for an e-business database connectivity from J2EE application servers. You can configure this data source the same way as any other standard Data Source in your application server. The administrators of both, e-Business Suite instance and the Application Server, needs to configure the data source accordingly.

Let me provide a brief-overview of the steps involved from both administrators.

E-Business Suite Administrator:
1. If you are an 11i customer, please download the following patch 6930112 from Meta-link. For R12 customers, the patch comes bundled with the Oracle Applications Technology Update Pack 12.0.6 (Patch 7237006)
2. Create a new Application User and grant the 'UMX|APPS_SCHEMA_CONNECT’ role.
3. Register the Application Server instance as a trusted node by running the AdminDesktop utility on e-Business Suite instance.

Application Server Administrator:
1. Download the fndds.jar from the e-business Suite application tier.
2. Configure OC4J server with fndds.jar as a shared library.
3. Create a new connection pool using the application data source.
4. Provide the credentials of the newly created Application user.
5. Create a Data source using the above connection pool.

Now you are all set to use the new Data Source for database connectivity to an e-business suite instance. For detailed instructions,please refer to the readme in the metalink patches provided above.

Please stay tuned for more on Best Practices for Apps Adapter.

Comments:

Dear Sir, Would you please ask some question about EBS 12? 1- Is exist any solution for multi-node (1*DB + n*APPL) installation without load balancer? 2- Is exist any solution for install n*DB + n*APPL with business and application data in DBs are synchronized (for multi-site installation)? Thanks Ahmad

Posted by Ahmad Abidi on January 13, 2009 at 03:42 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Straight from Oracle EBS Integrated SOA Gateway and EBS Adapter Development Team.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today