Integrate with Oracle e-Business User Management (UM)

You can establish a connection between Oracle e-Business Suite User Management (UM) and Oracle Access Governance by entering connection details and configuring the connector. To achieve this, use the Connected Systems functionality available in the Oracle Access Governance Console.

Preinstall

Before you install and configure a Oracle e-Business User Management (UM) connected system, you should consider the following pre-requisites and tasks.

Certified Components

The target system can be any one of the following:

  • Oracle E-Business Suite 12.1.1 through 12.1.3
  • Oracle E-Business Suite 12.2.x
These applications may run on Oracle Database 10g, 11g, 12c, or 19c as either single database or Oracle RAC implementation.

Note:

If your target system is running on Oracle Database release 19.x, then download and apply the Oracle Database patch 31142749 from My Oracle Support. Applying this patch ensures that provisioning operations work fine.

Supported Connector Operations

The Oracle e-Business User Management (UM) connected system supports the following connector operations:
  • User Management
    • Create person
  • Entitlement Grant Management
    • Add role
    • Update role
    • Remove role
    • Add responsibility
    • Update responsibility
    • Remove responsibility

Create a Target System User Account for Oracle e-Business User Management (UM) Connected System Operations

Oracle Access Governance requires a user account to access the target system that can be used by the connector to perform connector operations. Depending on the target system you are using, you can create the user in your target system and assign specific permissions and roles to the user.

For Oracle e-Business User Management (UM):

  1. Download all the files present in the https://github.com/oracle/docker-images/tree/main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_UM/1.0 location and copy them to a temporary directory on either the target system host computer or a computer on which the Oracle Database Client has been installed.

    Alternatively, you can run the following steps to get the scripts:
    1. wget https://github.com/oracle/docker-images/archive/refs/heads/main.zip

    2. unzip main.zip

    3. cp docker-images-main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_UM/1.0/* TEMP_DIR

      Where TEMP_DIR is a temporary directory on either the target system host computer or a computer on which the Oracle Database Client has been installed.

  2. On the computer where you copy the scripts directory, verify that there is a TNS entry in the tnsnames.ora file for the target system database.

  3. Change to the directory containing the scripts directory and depending on the host platform, run either the Run_UM_DBScripts.sh or Run_UM_DBScripts.bat file. These files are present at https://github.com/oracle/docker-images/tree/main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_UM/1.0 location.

  4. When you run the script, you are prompted for the following information:

    • Enter the ORACLE_HOME

      Set a value for the ORACLE_HOME environment variable. This prompt is displayed only if the ORACLE_HOME environment variable has not been set on the computer on which you are running the script.

    • Enter the System User Name

      Enter the login (user name) of a DBA account with the privileges to create and configure a new target system user.

    • Enter the name of the database

      Enter the connection string or service name given in the tnsnames.ora file to connect to the target system database.

      This connects you to the SQL*Plus client.

    • Enter password

      Enter the password of the APPS user in the target system. The Type and Package are created, and then the connection to the database is disconnected.

    • Enter password

      Enter the password of the dba user.

    • Enter New database Username to be created

      Enter a user name for the target system account that you want to create.

    • Enter the New user password

      Enter a password for the target system account that you want to create.

      This installs all wrappers packages under the APPS schema, creates the new target system account, and then grants all the required privileges on the tables and packages.

    • Connecting with newly created database user

      Enter the connection string or service name that you provided earlier.

    The user account for connector operations is created.

Install

You can establish a connection between Oracle e-Business User Management(UM) and Oracle Access Governance by entering connection details and configuring your database environment. To achieve this, use the Connected Systems functionality available in the Oracle Access Governance Console.

Navigate to the Connected Systems Page

Navigate to the Connected Systems page of the Oracle Access Governance Console, by following these steps:
  1. From the Oracle Access Governance navigation menu icon Navigation menu, select Service Administration → Connected Systems.
  2. Click the Add a connected system button to start the workflow.

Add a Connected System

To start the add a connected system workflow, you should select the type of system that you would like to connect with Oracle Access Governance:

Click the Add button on the Connect to an Oracle application tile.

Select system

On the Select system step of the workflow, you can specify which type of application you would like to onboard.

  1. Select Oracle E-Business User Management.
  2. Click Next.

Enter details

On the Enter Details step of the workflow, enter the details for the connected system:

  1. Enter a name for the application you want to connect to in the What do you want to call your Oracle application? field.
  2. Enter a description for the application in the How do you want to describe this Oracle application? field.
  3. Click Next.

Configure

On the Configure step of the workflow, enter the configuration details required to allow Oracle Access Governance to connect to the target system.

  1. In JDBC URL Template field, specify the database connection string in the format host:post:sid syntax format. For example, jdbc:oracle:thin:@%host:%port:%sid. For more information on JDBC URL formats, refer to the Determining Values for the JDBC URL and Connection Properties Parameters
  2. In the User field, enter the user ID of the DB user account that Oracle Access Governance uses to connect to the Oracle E-Business Suite User Management system. For example, sys as sysdba.
  3. Enter the password of the target database user in the Password field. Confirm the password in the Confirm password field.
  4. Click Add.

Finish up

The Finish Up step of the workflow allows you to download and install the configured Oracle E-Business User Management agent.

For more information, refer Agent Administration.

Postinstall

For Oracle E-Business User Management system to integrate with AGCS, some additional configurations need to be done on the target system. For more information, refer Create a Target System User Account for Oracle e-Business User Management (UM) Connected System Operations.