Chat now with support
Chat with Support

Identity Manager 8.0 - Administration Guide for Connecting to Oracle E-Business Suite

Managing Oracle E-Business Suite Setting Up Oracle E-Business Suite Synchronization Basic Configuration Data Appendix: Configuration Parameter for Managing Oracle E-Business Suite Appendix: Default Project Templates for Synchronizing an Oracle E-Business Suite Appendix: Editing System Objects About us

Users and Permissions for Synchronizing with Oracle E-Business Suite

Users and Permissions for Synchronizing with Oracle E-Business Suite

The following users are involved in synchronizing One Identity Manager with Oracle E-Business Suite.

Table 2: Users for Synchronization

User

Permissions

User for accessing Oracle E-Business Suite

You must provide a user account with the following permissions for full synchronization of Oracle E-Business Suite objects with the supplied One Identity Manager default configuration.

For the version 12.2:

  • The APPS user must be used.

For the version 12.1:

One Identity Manager Service user account

The user account for the One Identity Manager Service requires access rights to carry out operations at file level (issuing user rights, adding directories and files to be edited).

The user account must belong to the group "Domain Users".

The user account must have the extended access right "Log on as a service".

The user account requires access rights to the internal web service.

NOTE: If the One Identity Manager Service runs under the network service (NT Authority\NetworkService), you can issue access rights for the internal web service with the following command line call:

netsh http add urlacl url=http://<IP address>:<port number>/ user="NT AUTHORITY\NETWORKSERVICE"

The user account needs full access to the One Identity Manager Service installation directory in order to automatically update the One Identity Manager.

In the default installation the One Identity Manager is installed under:

  • %ProgramFiles(x86)%\One Identity (on 32-bit operating systems)
  • %ProgramFiles%\One Identity (on 64-bit operating systems)

User for accessing the One Identity Manager database

The default system user "Synchronization" is available to run synchronization over an application server.

Access Rights Required for Synchronization with Oracle E-Business Suite 12.1

Access Rights Required for Synchronization with Oracle E-Business Suite 12.1

The Oracle E-Business Suite requires read access rights to at least the following database objects in the Oracle Database to be connected.

Tables with Select Permissions

  • ak.ak_attributes_tl
  • ak.ak_excluded_items
  • ak.ak_web_user_sec_attr_values
  • ak.ak_resp_security_attr_values
  • applsys.fnd_application
  • applsys.fnd_application_tl
  • applsys.fnd_menus
  • applsys.fnd_menus_tl
  • applsys.fnd_data_groups
  • applsys.fnd_data_group_units
  • applsys.fnd_request_groups
  • applsys.fnd_resp_functions
  • applsys.fnd_responsibility
  • applsys.fnd_responsibility_tl
  • applsys.fnd_security_groups
  • applsys.fnd_security_groups_tl
  • applsys.fnd_user

Tables with Select Permissions for Synchronizing People Data

  • ap.ap_supplier_contacts
  • ar.hz_parties
  • hr.per_all_people_f
  • hr.hr_locations_all
  • hr.per_job_groups

Views with Select Permissions

  • apps.fnd_user_resp_groups_all
  • apps.fnd_user_resp_groups_direct
  • apps.fnd_user_resp_groups_indirect

Stored Procedures with Select Permissions

  • apps.fnd_user_pkg

    This issues permissions to the following procedures, implicitly.

  • apps.fnd_user_pkg.AddResp
  • apps.fnd_user_pkg.change_user_name
  • apps.fnd_user_pkg.changepassword
  • apps.fnd_user_pkg.CreateUser
  • apps.fnd_user_pkg.DisableUser
  • apps.fnd_user_pkg.DelResp
  • apps.fnd_user_pkg.UpdateUser
  • apps.fnd_user_pkg.user_synch

There is a script on the One Identity Manager installation medium, which you can use to add all the permissions shown here to a user account. Take note of the comment in the script to replace the variables &&username and &&password. You can find the script in the installation directory:

..\Modules\EBS\dvd\AddOn\SDK\CreateSyncUser.sql

Setting Up the Synchronization Server

Setting Up the Synchronization Server

To setup synchronization with Oracle E-Business Suite, a server has to be available that has the following software installed on it:

  • Windows operating system version 8.1. or later
  • Windows Server

    Following versions are supported:

    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016
  • Microsoft .NET Framework Version 4.5.2 or later

    NOTE: Microsoft .NET Framework version 4.6 is not supported.

    NOTE: Take the target system manufacturer's recommendations into account.
  • One Identity Manager Service, Oracle E-Business Suite connector
    • Install One Identity Manager components with the installation wizard.
      1. Select the option Select installation modules with existing database.
      2. Select the machine role Server | Job server | Oracle E-Business Suite.

The synchronization server requires a good network connection to the Oracle E-Business Suite's database server.

All One Identity Manager Service actions are executed against the target system environment on the synchronization server. Entries which are necessary for synchronization and administration with the One Identity Manager database are processed by the synchronization server. The synchronization server must be declared as a Job server in One Identity Manager.

NOTE: If several target system environments of the same type are synchronized under the same synchronization server, it is useful to set up a job server for each target system on performance grounds. This avoids unnecessary swapping of connection to target systems because a job server only has to process tasks of the same type (re-use of existing connections).

Use the Server Installer to install the One Identity Manager Service. This program executes the following steps.

  • Setting up a Job server.
  • Specifying machine roles and server function for the Job server.
  • Remote installation of One Identity Manager Service components corresponding to the machine roles.
  • Configures the One Identity Manager Service.
  • Starts the One Identity Manager Service.

NOTE: The program executes remote installation of the One Identity Manager Service. Local installation of the service is not possible with this program. Remote installation is only supported within a domain or a trusted domain.

To install and configure the One Identity Manager Service remotely on a server

  1. Start the program Server Installer on your administrative workstation.
  2. Enter valid data for connecting to One Identity Manager on the Database connection page and click Next.
  3. Specify on which server you want to install the One Identity Manager Service on the Server properties page.
    1. Select a job server in the Server menu.

      - OR -

      Click Add to add a new job server.

    2. Enter the following data for the Job server.
      Table 3: Job Servers Properties
      Property Description
      Server Name of the Job servers.
      Queue

      Name of queue to handle the process steps. Each One Identity Manager Service within the network must have a unique queue identifier. The process steps are requested by the job queue using exactly this queue name. The queue identifier is entered in the One Identity Manager Service configuration file.

      Full server name

      Full name of the server in DNS syntax.

      Example:

      <name of server>.<fully qualified domain name>

      NOTE: Use the Advanced option to edit other Job server properties. You can use the Designer to change properties at a later date.
  4. Specify which job server roles to include in One Identity Manager on the Machine role page. Installation packages to be installed on the Job server are found depending on the selected machine role.
    • Oracle E-Business Suite
  5. Specify the server's functions in One Identity Manager on the Server functions page. One Identity Manager processes are handled depending on the server function.

    The server's functions depend on which machine roles you have selected. You can limit the server's functionality further here.

      Windows PowerShell
    • Oracle E-Business Suite Connector
  6. Check the One Identity Manager Service configuration on the Service settings page.

    NOTE: The initial service configuration is already predefined. If further changes need to be made to the configuration, you can do this later with the Designer. For more detailed information about configuring the service, see One Identity Manager Configuration Guide.
  7. To configure remote installations, click Next.
  8. Confirm the security prompt with Yes.
  9. Select the directory with the install files on the Select installation source page.
  10. Select the file with the private key on the page Select private key file.

    NOTE: This page is only displayed when the database is encrypted.
  11. Enter the service's installation data on the Service access page.
    Table 4: Installation Data
    Data Description
    Computer Server on which to install and start the service from.

    To select a server

    • Enter the server name.

      - OR -

    • Select a entry from the list.
    Service account One Identity Manager Service user account data.

    To enter a user account for the One Identity Manager Service

    • Set the option Local system account.

      This starts the One Identity Manager Service under the account "NT AUTHORITY\SYSTEM".

      - OR -

    • Enter user account, password and password confirmation.
    Installation account Data for the administrative user account to install the service.

    To enter an administrative user account for installation

      Enable Advanced
    • .
    • Enable the option Current user.

      This uses the user account of the current user.

      - OR -

    • Enter user account, password and password confirmation.
  12. Click Next to start installing the service.

    Installation of the service occurs automatically and may take some time.

  13. Click Finish on the last page of the Server Installer.

    NOTE: The is entered with the name "One Identity Manager Service" in the server's service administration.

Creating a Synchronization Project for initial Synchronization of Oracle E-Business Suite

Creating a Synchronization Project for initial Synchronization of Oracle E-Business Suite

Use the Synchronization Editor to configure synchronization between the Oracle E-Business Suite database and One Identity Manager. The following describes the steps for initial configuration of a synchronization project. For more detailed information about setting up synchronization, see the One Identity Manager Target System Synchronization Reference Guide.

After the initial configuration, you can customize and configure workflows within the synchronization project. Use the workflow wizard in the Synchronization Editor for this. The Synchronization Editor also provides different configuration options for a synchronization project.

Have the following information available for setting up a synchronization project.

Table 5: Information Required for Setting up a Synchronization Project

Data

Explanation

Server

Name of the server on which the Oracle Database is installed. The fully qualified server name or the IP address may be given.

Port and service name

Port of the Oracle instance and name of the service.

User account and password

User account and password used by the Oracle E-Business Suite connector to log in to the Oracle Database database. Make a user account available with sufficient permissions.

For more information, see Users and Permissions for Synchronizing with Oracle E-Business Suite.

Data source

TNS alias name from TNSNames.ora. This data is only required if the Oracle E-Business Suite connector can only access the Oracle Database through Oracle Clients.

Synchronization server for Oracle E-Business Suite

All One Identity Manager Service actions are executed against the target system environment on the synchronization server. Entries which are necessary for synchronization and administration with the One Identity Manager database are processed by the synchronization server.

The One Identity Manager Service with the Oracle E-Business Suite connector must be installed on the synchronization server.

Table 6: Additional Properties for the Job Server
Property Value
Server Function Oracle E-Business Suite connector
Machine role Server/Job server/Oracle E-Business Suite

For more information, see Setting Up the Synchronization Server.

One Identity Manager Database Connection Data

SQL Server:

  • Database server
  • Database
  • Database user and password
  • Specifies whether Windows authentication is used.

    This type of authentication is not recommended. If you decide to use it anyway, ensure that your environment supports Windows authentication.

Oracle:

  • Species whether access is direct or through the Oracle client

    Which connection data is required, depends on how this option is set.

  • Database server
  • Oracle instance port
  • Service name
  • Oracle database user and password
  • Data source (TNS alias name from TNSNames.ora)

Remote connection server

To configure synchronization with a target system, One Identity Manager must load the data from the target system. One Identity Manager communicates directly with target system to do this. because of the firewall configuration, for example, you can set up a remote connection.

The remote connection server and the workstation must be in the same Active Directory domain.

Remote connection server configuration:

  • One Identity Manager Service is started
  • RemoteConnectPlugin is installed

The remote connection server must be declared as a Job server in One Identity Manager. The Job server name is required.

For more detailed information about setting up a remote connection, see the One Identity Manager Target System Synchronization Reference Guide.

NOTE: The following sequence describes how you configure a synchronization project if the Synchronization Editor is both:
  • In default mode
  • Started from the launchpad

Additional settings can be made if the project wizard is run in expert mode or is started directly from the Synchronization Editor. Follow the project wizard instructions through these steps.

To set up an initial synchronization project for Oracle E-Business Suite

  1. Start the Launchpad and log on to the One Identity Manager database.

    NOTE: If synchronization is executed by an application server, connect the database through the application server.
  2. Select the entry Oracle E-Business Suite target system type. Click Run.

    This starts the Synchronization Editor's project wizard.

  1. Specify how the One Identity Manager can access the target system on the System access page.
    • If you have access from the workstation from which you started the Synchronization Editor, do not set anything.
    • If you do not have access from the workstation from which you started the Synchronization Editor, you can set up a remote connection.

      In this case, set the option Connect using remote connection server and select, under Job server, the server you want to use for the connection.

  1. Enter the connection parameters required by the Oracle E-Business Suite connector to log in on the Oracle Database on the Database connection page.
    Table 7: Login Data for Connecting to the Oracle E-Business Suite
    Property Description
    Direct access (without Oracle client)

    Specifies whether the Oracle E-Business Suite connector can directly access the Oracle Database. Disable this option for access though Oracle clients. Which connection data is required, depends on how this option is set.

    Server

    Name of the server installed with the Oracle Database. The fully qualified server name or the IP address may be given.

    Port

    Port of the Oracle instance.

    Service name

    Name of the service.

    User

    User name used by the connector to log in to the Oracle Database.

    Password

    Password for logging in to the Oracle Database.

    Data source

    TNS alias name from TNSNames.ora.

    The Oracle Database connection is test when you click Next.

  2. On the Connection configuration page, you can select a language and specify a unique distinguished name.

  3. Enter a unique display name for the connection configuration on the Display Name page.

    You can use the display names to differentiate between the connection configurations of different Oracle E-Business Suite connections in the Synchronization Editor. Display names cannot be changed later.

  4. You can save the connection data on the last page of the system connection wizard.
    • Set the option Save connection locally to save the connection data. This can be reused when you set up other synchronization projects.
    • Click Finish, to end the system connection wizard and return to the project wizard.
  1. Verify the One Identity Manager database connection data on the One Identity Manager connection page. The data is loaded from the connected database. Reenter the password.

    NOTE: Reenter all the connection data if you are not working with an encrypted One Identity Manager database and no synchronization project has been saved yet in the database. This page is not shown if a synchronization project already exists.
  2. The wizard loads the target system schema. This may take a few minutes depending on the type of target system access and the size of the target system.
  1. Select a project template on the Select project template page to use for setting up the synchronization configuration.
    Table 8: Default Project Templates
    Project Template Description
    Oracle E-Business Suite CRM data

    Use this project template for initial configuration of synchronization projects for synchronizing AP customer/supplier contact data.

    Oracle E-Business Suite HR data

    Use this project template for initial configuration of synchronization projects for synchronizing HR people data with the Oracle E-Business Suite's Human Resources module.

    Oracle E-Business Suite OIM data

    Use this project template for initial configuration of synchronization projects for synchronizing AR parties people data.

    Oracle E-Business Suite synchronization

    Use this project template for initial configuration of synchronization projects for synchronizing E-Business Suite user accounts and permissions.

    NOTE: A default project template ensures that all required information is added in the One Identity Manager. This includes mappings, workflows and the synchronization base object. If you do not use a default project template you must declare the synchronization base object in One Identity Manager yourself.Use a default project template for initially setting up the synchronization project. For custom implementations, you can extend the synchronization project with the .Synchronization Editor
  1. Select the synchronization server to execute synchronization on the Synchronization server page.

    If the synchronization server is not declare as a job server in the One Identity Manager database yet, you can add a new job server.

    • Click to add a new job server.
    • Enter a name for the job server and the full server name conforming to DNS syntax.
    • Click OK.

      The synchronization server is declared as job server for the target system in the One Identity Manager database.

      NOTE: Ensure that this server is set up as the synchronization server after saving the synchronization project.
  1. Click Finish to complete the project wizard.

    The synchronization project is created, saved and enabled immediately.

    NOTE: If the synchronization project is not going to be executed immediately, disable the option Activate and save the new synchronization project automatically.

    In this case, save the synchronization project manually before closing the Synchronization Editor.

To configure the content of the synchronization log

  1. To configure the synchronization log for target system connection, select the category Configuration | Target system.
  2. To configure the synchronization log for the database connection, select the category Configuration | One Identity Manager connection.
  3. Select General view and click Configure....
  4. Select the Synchronization log view and set Create synchronization log.
  5. Enable the data to be logged.

    NOTE: Certain content create a lot of log data.

    The synchronization log should only contain the data necessary for error analysis and other evaluations.

  6. Click OK.

To synchronize on a regular basis

  1. Select the category Configuration | Start up configurations.
  2. Select a start up configuration in the document view and click Edit schedule....
  3. Edit the schedule properties.
  4. To enable the schedule, click Activate.
  5. Click OK.

To start initial synchronization manually

  1. Select the category Configuration | Start up configurations.
  2. Select a start up configuration in the document view and click Execute.
  3. Confirm the security prompt with Yes.

NOTE: Following synchronization, employees are automatically created for user accounts in the default installation. If there are no account definitions for the system at the time of synchronization, user accounts are linked to employees. However, account definitions are not assigned. The user accounts are, therefore, in a "Linked" state.

To select user accounts through account definitions

  1. Create an account definition.
  2. Assign an account definition to the system.
  3. Assign the account definition and manage level to the user accounts in a "linked" state.
    1. Select the category Oracle E-Business Suite | User accounts | Linked but not configured | <host>.
    2. Select the task Assign account definition to linked accounts.
Related Topics
Related Documents