Configuration Parameters

The following lists the configuration parameters of IdentityIQ for Oracle ERP – Oracle E-Business Suite:

Note
Attributes marked with an asterisk (*) are mandatory.

 

Oracle E-Business Connection Settings

The Oracle EBS Login name through which you want to connect Oracle EBS. For example, APPS

The authentication details of the login.

The URL to connect to the database. The format is jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

For example jdbc:oracle:thin:@xxx.xx.xx.xx:1521:ORCL URL consists of

  • jdbc:oracle:thin:@: This is common part which states that the connection is made using the thin driver.

  • xxx.xx.xx.xx: The server name or IP of the oracle server.

  • 1521: The port number of the oracle server. This port number should be known by the oracle server administrator.

  • ORCL: The SID of the oracle server.

The name of the Driver class supported by JDBC Type 4.
For example, oracle.jdbc.driver.OracleDriver

(Optional) E-Business Proxy User for Audit purposes. This user must be created in the Oracle E-Business Suite Portal. Audit records would be created/updated with this user for all provisioning operations done for Oracle E-Business through IdentityIQ. If not provided, an error would be displayed on Oracle E-Business Portal when the user tries to view Record History for any user and his/her assigned entitlements.

Set the following permissions as mentioned in Required Permissions when the ‘E-Business Proxy User’ parameter is not set:

Under Grant Permissions:

grant select on SYS.DBA_USERS to ${new role};

Creating the synonym:

create synonym DBA_USERS for SYS.DBA_USERS

This text box can be used to specify the additional configuration parameters. These additional parameters must be passed in key value pairs. If multiple parameters must be specified, then they need to be passed in a new line. For example,

oracle.net.encryption_client=ACCEPTED

oracle.net.encryption_types_client=AES256

Account Aggregation Settings

Note
For more information on using the Account Aggregation Settings, refer to Upgrade Considerations in the 'Account Aggregation Filters' section.

Select the type of users to be aggregated: Employees, Contractors, Employee and Contractors, and all users from FND_USER table.

Aggregate only employees

Select to aggregate Oracle E-Business users that are associated with valid Employee records of the Oracle HRMS system.

Aggregate only contractors

Select to aggregate Oracle E-Business users that are associated with valid Contractor records of the Oracle HRMS system.

Aggregate employees and contractors

Select to aggregate Oracle E-Business users that are associated with valid Employee and Contractor records of the Oracle HRMS system.

Aggregate all users from FND_USER table in Oracle E-Business

Select to aggregate all the E-Business users that are there in the FND_USER table.

All the E-Business records associated with person records active after the date specified here would be aggregated in the connector. The format of the date entered is MM/DD/YYYY.