Chat now with support
Chat with Support

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

Mapping an Oracle E-Business Suite in One Identity Manager Synchronizing Oracle E-Business Suite
Setting up initial synchronization of Oracle E-Business Suite Customizing the synchronization configuration Running synchronization Tasks following synchronization Troubleshooting Ignoring data error in synchronization Pausing handling of target system specific processes (Offline mode)
Managing E-Business Suite user accounts and employees Login information Managing entitlement assignments Mapping of E-Business Suite objects in One Identity Manager Handling of E-Business Suite objects in the Web Portal Basic configuration data Configuration parameters for managing Oracle E-Business Suite Permissions required for synchronizing with Oracle E-Business Suite Default project templates for synchronizing an Oracle E-Business Suite Editing system objects Example of a schema extension file

Information required for setting up a synchronization project

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

Table 4: Information required for setting up a synchronization project

Data

 Explanation

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 How to prepare the synchronization user.

Data source

  • Oracle Database connection parameter (Connect Descriptor) in the following syntax:

    (DESCRIPTION=(ADDRESS=(protocol_address_information)) (CONNECT_DATA=(SERVICE_NAME=service_name)))

    - OR -

  • TNS alias name from the TNSNames.ora file.

Synchronization server for Oracle E-Business Suite

All One Identity Manager Service actions are run against the target system environment on the synchronization server. Data entries required for synchronization and administration with the One Identity Manager database are processed by the synchronization server.

For more information, see Setting up the E-Business Suite synchronization server.

One Identity Manager database connection data

  • Database server

  • Database name

  • SQL Server login and password

  • Specifies whether integrated Windows authentication is used

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

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 the target system to do this. Sometimes direct access from the workstation, on which the Synchronization Editor is installed, is not possible. For example, because of the firewall configuration or the workstation does not fulfill the necessary hardware and software requirements. If direct access is not possible from the workstation, 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

  • Oracle E-Business Suite connector 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 establishing a remote connection, see the One Identity Manager Target System Synchronization Reference Guide.

Setting up an initial synchronization project

NOTE: The following sequence describes how to configure a synchronization project if the Synchronization Editor is both:

  • Run in default mode

  • Started from the Launchpad

If you run the project wizard in expert mode or directly from the Synchronization Editor, additional configuration settings can be made. Follow the project wizard instructions through these steps.

NOTE: Just one synchronization project can be created per target system and default project template used.

NOTE: If a synchronization project is set up for a target system that already exists in the One Identity Manager database, ensure that the same server and the same unique name for the DN are given as in the existing synchronization project.

  • When you set up the synchronization project, use an existing system connection with the necessary configuration.

    - OR -

  • In the Manager, check the defined name and the display name of the E-Business Suite system you are creating the synchronization for. The following values must match:

    • Display name: Oracle Finance on <server>

    • Distinguished name: O=ORA system,DC=<unique name for the DN>

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

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

    NOTE: If synchronization is run by an application server, connect the database through the application server.

  2. Select the Target system type Oracle E-Business Suite entry and click Start.

    This starts the Synchronization Editor's project wizard.

  1. On the System access page, specify how One Identity Manager can access the target system.

    • If access is possible from the workstation on which you started the Synchronization Editor, do not change any settings.

    • If access is not possible from the workstation on which you started the Synchronization Editor, you can set up a remote connection.

      Enable the Connect using remote connection server option and select the server to be used for the connection under Job server.

  1. On the Database connection page, enter the connection parameters required by the Oracle E-Business Suite connector to log in to the Oracle Database.
    Table 5: Login information for connection to Oracle E-Business Suite
    Property Description

    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

    • Oracle Database connection parameter (Connect Descriptor) in the following syntax:

      (DESCRIPTION=(ADDRESS=(protocol_address_information)) (CONNECT_DATA=(SERVICE_NAME=service_name)))

      - OR -

    • TNS alias name from the TNSNames.ora file.

    The connection to the Oracle Database is tested the moment you click Next.

  2. On the Connection Configuration page, configure more default parameters for the connection.

    Table 6: Connection configuration

    Property

    Description

    Language selection

    Languages used to load captions from the database.

    Unique name for the DN.

    Part of name used to generate a distinguished name for all objects in the system. Leave this field empty to use the database server's server name.

    This name should not be changed after the initial synchronization.

    Read-only

    Specifies whether the Oracle E-Business Suite connector only has read access to the target system.

    Package to access users

    The name of the wrapper package or user package to be used for adding and modifying user accounts and permissions.

    Syntax: <owner>.<PackageName>

    The following input required, depending on which scenario was used to set up the synchronization user.

    • User APPS (scenario 1): no input required. Default is APPS.FND_User_PKG.

    • Wrapper (scenario 2): name of the wrapper package. Default is APPS.FND_USER_WRAPPER.

    • Otherwise (scenario 3): name of the user package. Default is APPS.FND_User_PKG.

  3. On the Display Name page, enter a unique display name for the connection configuration.

    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. On the last page of the system connection wizard, you can save the connection data.
    • Set the Save connection locally option 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. On the One Identity Manager Connection tab, test the data for connecting to the One Identity Manager database. The data is loaded from the connected database. Reenter the password.

    NOTE:

    • If you use an unencrypted One Identity Manager database and have not yet saved any synchronization projects to the database, you need to enter all connection data again.

    • 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. On the Select project template page, select Oracle E-Business Suite Synchronization.

    NOTE: A default project template ensures that all required information is added in 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. On the Synchronization server page, select the synchronization server to run the synchronization.

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

    1. Click to add a new Job server.

    2. Enter a name for the Job server and the full server name conforming to DNS syntax.

    3. Click OK.

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

    4. NOTE: After you save the synchronization project, ensure that this server is set up as a synchronization server.

  1. To close the project wizard, click Finish.

    This sets up, saves and immediately activates the synchronization project.

    NOTE:

    • If enabled, a consistency check is carried out. If errors occur, a message appears. You can decide whether the synchronization project can remain activated or not.

      Check the errors before you use the synchronization project. To do this, in the General view on the Synchronization Editor‘s start page, click Verify project.

    • If you do not want the synchronization project to be activated immediately, disable the Activate and save the new synchronization project automatically option. In this case, save the synchronization project manually before closing the Synchronization Editor.

Related topics

Setting up a synchronization project for employee data

To synchronize data from the Human Resources module of Oracle E-Business Suite, you create a separate synchronization project. A separate project template is provided for this.

NOTE: If a synchronization project is set up for a target system that already exists in the One Identity Manager database, ensure that the same server and the same unique name for the DN are given as in the existing synchronization project.

  • When you set up the synchronization project, use an existing system connection with the necessary configuration.

    - OR -

  • In the Manager, check the defined name and the display name of the E-Business Suite system you are creating the synchronization for. The following values must match:

    • Display name: Oracle Finance on <server>

    • Distinguished name: O=ORA system,DC=<unique name for the DN>

To set up a synchronization project for employee data:

  • Set up an initial synchronization project. The following special feature applies:

    In the project wizard, on the Select project template page, select the Oracle E-Business Suite HR data project template.

Detailed information about this topic
Related topics

Setting up a synchronization project for organizational data

For the synchronization of organizational data such as supplier contact data or parties, you create separate synchronization projects. Separate project templates are provided for this.

NOTE: If both synchronization projects are set up on a One Identity Manager database, objects may exist in duplicate after the synchronization.

Create only one of the two synchronization projects for each One Identity Manager database.

NOTE: If a synchronization project is set up for a target system that already exists in the One Identity Manager database, ensure that the same server and the same unique name for the DN are given as in the existing synchronization project.

  • When you set up the synchronization project, use an existing system connection with the necessary configuration.

    - OR -

  • In the Manager, check the defined name and the display name of the E-Business Suite system you are creating the synchronization for. The following values must match:

    • Display name: Oracle Finance on <server>

    • Distinguished name: O=ORA system,DC=<unique name for the DN>

To set up a synchronization project for supplier contact data

  • Set up an initial synchronization project. The following special feature applies:

    In the project wizard, on the Select project template page, select the Oracle E-Business Suite CRM data project template.

To set up a synchronization project for party person data:

  • Set up an initial synchronization project. The following special feature applies:

    In the project wizard, on the Select project template page, select the Oracle E-Business Suite OIM data project template.

Detailed information about this topic
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating