Propagate Changes from OIM User Profile to Target (Resources)

Propagate the changes from OIM User profile to a target (resource e.g. OID or ODSEE)

Go to Design Console and then open up the lookup table 'Lookup.USR_PROCESS_TRIGGERS' and map the OIM User profile attributes with corresponding tasks e.g. 'USR_FIRST_NAME' is a user profile attribute and 'Change First Name' task is corresponding target Task name. With this configuration when you make changes to 'First Name' then the changes automatically propagates to Target e.g. ODSEE or OID.

Trusted User Recon Setup for OID-11.1.1.5.0 ICF Based Connector

Oracle launched OID-11.1.1.5.0 ICF connector which supports the following directory servers

Oracle Directory Server Enterprise Edition (ODSEE), Oracle Internet Directory (OID), Oracle Unified Directory (OUD), and Novell eDirectory.

By default the connector is configured for Target User reconciliation if you want to configure the connector for Trusted User recon then make the following changes

1. Go to the design console and search for the lookup table 'Lookup.LDAP.Configuration'.

2. Update the decode value with 'Lookup.LDAP.UM.Configuration.Trusted' of 'User Configuration Lookup' code key as shown in picture.

3. Save the changes.

4. Run the Trusted User Recon job 'LDAP Connector Trusted User Reconciliation'.

java.io.InvalidClassException: org.eclipse.persistence.indirection.IndirectList

Due to Eclipselink.jar incompatibility within JDeveloper I faced the following exception:


Exception in thread "main" javax.ejb.EJBException: failed to unmarshal interface java.util.List; nested exception is: 
java.io.InvalidClassException: org.eclipse.persistence.indirection.IndirectList; local class incompatible: stream classdesc serialVersionUID = 4038061360325736360, local class serialVersionUID = -494763524358427112; nested exception is: java.io.InvalidClassException: org.eclipse.persistence.indirection.IndirectList; local class incompatible: stream classdesc serialVersionUID = 4038061360325736360, local class serialVersionUID = -494763524358427112
java.io.InvalidClassException: org.eclipse.persistence.indirection.IndirectList; local class incompatible: stream classdesc serialVersionUID = 4038061360325736360, local class serialVersionUID = -494763524358427112

Solution:

Replace the Eclipselink.jar with the JAR file found at the following location:

 Middleware_Home\oracle_common\modules\oracle.toplink_11.1.1\eclipselink.jar

Compile and Run the program again and it will run without any problem.

Get OIM DB Connection

We have OIM APIs to get connection to OIM DB and we can fire up a query to get data from OIM DB tables.

           
/**
* OIM DB Table: UPA_UD_FORMFIELDS
*Column Name: OLD_VALUE

*/

String query =
               "select * from UPA_UD_FORMFIELDS";

Connection connection = Platform.getOperationalDS().getConnection();

PreparedStatement prepared_statement = connection.prepareStatement(query);

ResultSet resultSet = prepared_statement.executeQuery();

String  field_old_value = resultSet.getString("OLD_VALUE");
            
            System.out.println("field_old_value: "+field_old_value);


List of OIM DB tables:

http://www.reachdba.com/showthread.php?701-OIM-List-of-Tables-and-Description