Oracle E-Business Suite Connection

The OEBS Connection resource contains the information that is necessary to establish a connection pool at run time to the Oracle E-Business Suite server, and is used by the activities to obtain connections to the server.

General Panel

In the General panel, you can specify the package that stores the OEBS Connection shared resource and the shared resource name.

The General panel contains the following fields:

Field	Module Property?	Description
Package	No	The name of the package where the new shared resource is added.
Name	No	The name of the Oracle E-Business Suite connection. The default is OEBSConnectionResource.
Description	No	A short description of the resource.

OEBS Connection Configuration Panel

In the OEBS Connection Configuration panel, you can provide the information of the OEBS server to which the plug-in connects.

The OEBS Connection Configuration panel contains the following fields:

Field	Module Property?	Description
Database URL	Yes	The standard Oracle JDBC connection string. For example, `jdbc:oracle:thin:@192.168.71.209:1521:vis`
APPS User Name	Yes	The user name of an Oracle E-Business Suite application administrator used to access Oracle E-Business Suite. For Oracle E-Business Suite 12.2.x, the apps user is used to connect to the database server for all plug-in activities at design time, get the version number of Oracle E-Business Suite for the Oracle API, Custom API, and Oracle Business Event activities at run time, and run the Oracle API and Custom API activities at run time. For Oracle E-Business Suite 12.1.x and 12.0.x, the apps user is used to connect to the database server for all plug-in activities at design time, and get the version number of Oracle E-Business Suite for the Oracle API, Custom API, and Oracle Business Event activities at run time; but the plug-in user is used to run all plug-in activities at run time.
APPS User Password	Yes	The password of an Oracle E-Business Suite application administrator used to access Oracle E-Business Suite.
Plugin User Name	Yes	The user name used to run the plug-in activities at run time. For Oracle E-Business Suite 12.2.x, the plug-in user is used to run the Oracle Concurrent Program, Custom Concurrent Program, and Oracle Business Event activities at run time. For Oracle E-Business Suite 12.1.x and 12.0.x, the plug-in user is used to run all plug-in activities at run time.
Plugin User Password	Yes	The password of the plug-in user used to run the plug-in activities at run time.
Maximum Number of Reconnect Attempts	Yes	The maximum number of reconnection attempts to make when the connection is lost. The default value is 3. Note: If you set the value of this field to a negative integer, the plug-in attempts to reconnect to Oracle E-Business Suite indefinitely when a connection fails.
Interval between Reconnect Attempts (ms)	Yes	The time interval in milliseconds to elapse between reconnection attempts. The default value is 5000, and the minimum value is 0.
Maximum Connections	Yes	The maximum number of connections between the plug-in and Oracle E-Business Suite that are maintained in the plug-in connection pool. The importance of this number becomes clear at run time. When a project has more than one process simultaneously triggered at run time, the processes might request more connections than are allowed by the maximum number. In this case, some processes are suspended until free connections are released. The default value is 3, and the minimum value is 1.
Login Timeout (s)	Yes	The timeout interval in seconds required to log in. The default value is 30, and the minimum value is 0.
Test Connection	No	Used to test whether the connection to Oracle E-Business Suite can be established. This operation tests whether the JDBC libraries are correctly referenced and whether the provided credentials are correct.