Using a custom schema for EBS

If you are using XXD4_APPS in a first time PROCESSIT installation, put XXD4_APPS in processit.properties.

db.jdbc.ebsapps.username = XXD4_APPS

db.jdbc.ebsapps.password = <XXD4_APPS_PWD>

By default, PROCESSIT installs packages to APPS schema of the Oracle E-Business Suite database and connections to the Oracle E-Business Suite database are made with the APPS user. Optionally, you can switch from the APPS user to a non-APPS user via these steps:

Create XXD4_APPS user

1. Navigate to the [inst.root]/database/xxd4_apps/users
2. Edit the file xxd4_apps_oebs.sql file.
3. Replace the text string ${db.jdbc.ebsprocessit.tablespacefile} with the data file location appropriate for your Oracle E-Business Suite database.
4. Using SQL*Plus or equivalent, connect to the Oracle E-Business Suite database as a user that has dba privilege and execute the script xxd4_apps_oebs.sql

Replace the database links from PROCESSIT to EBS

Log into PROCESSIT database as user D4 and run this code:

	drop public database link EBSDB;
	create public database link EBSDB connect to xxd4_apps identified by <xxd4_apps_pw> using 'EBSDB';
		

BPEL Datasource

1. Connect to the server hosting the Oracle SOA Suite application as the user that SOA was installed under (usually oracle)
2. Edit the file [as.root]/j2ee/oc4j_soa/config/data-sources.xml
3. Update the xml tag for the connection pool D4_OEBS_APPS_POOL with the username XXD4_APPS and password XXD4_APPS
4. Save the changes and close the file.

EBSAdapter.xml

1. Connect to the server hosting the Oracle SOA Suite application as the user that SOA was installed under (usually oracle)
2. Edit the file [as.root]/j2ee/oc4j_soa/applib/EBSAdapter.xml
3. Update the xml tag with the username XXD4_APPS and password XXD4_APPS
4. Save the changes and close the file.

Update the WebLogic JDBC Connection Pool

1. Log in to the WebLogic server administration console via this url: http://{WebLogic Server}:7001/console/login/LoginForm.jsp
2. Click on the Data Sources link
3. Click the name D4_OEBS_APPS.
4. Open the Connection Pool tab.
5. In the Properties field, enter user=XXD4_APPS
6. In the Password field enter the password for the XXD4_APPS user
7. Click Save

Install EBS Components

1. In <inst.root>/config, modify processit.properties:
   • db.jdbc.ebsapps.username = XXD4_APPS
   • db.jdbc.ebsapps.password = XXD4_APPS
2. Launch the PROCESSIT EBS Components Installer, using install_processit_ebs_components.sh.
3. Click Install all.

Restart SOA and WebLogic

1. Stop the SOA Suite and the WebLogic Server
2. Start the WebLogic Server and the SOA Suite