OIM 11g R2: Dynamically Updating Lookup Values using Java Code

In one of the scenario we have requirement where we need to update the lookup value dynamically. Say for.ex if there is addition of new cities or town in the particular it should get reflected immediately. So in this lab we are going to see how we can achieve this functionality using java code.In this lab we are going to read the value from the xlsx file. You can deploy this project using scheduler or run directly in Jdeveloper. I am going to use the second approach for this lab.

Note: Before starting this lab please create Lookup "Lookup.City.Configuration" in oim using design console.

1) Create the new Excel Sheet as shown in figure below. Save it to any location you want. Please make a note of this location because we are going to use this in our java program.

2) Create the new java project in Jdeveloper and add the following jar show in figure.

3) Create the new class and copy and paste the below code.

1. import java.util.HashMap;
2. import java.util.Hashtable;
3. import oracle.iam.platform.OIMClient;
4. import Thor.API.tcResultSet;
5. import Thor.API.Operations.tcLookupOperationsIntf;
6. import java.io.File;
7. import java.io.IOException;
8. import java.util.Locale;
9. import jxl.Cell;
10. import jxl.Sheet;
11. import jxl.Workbook;
12. import jxl.read.biff.BiffException;
13. import oracle.iam.scheduler.vo.TaskSupport;
14. 
    
15. public class UpdateLookup 
16. {
17. private static final String OIM_URL = "t3://localhost:14000";
18.  private static final String AUTH_CONF = "E:/Oracle/Middleware/Oracle_IDM1/server/config/authwl.conf";
19.  private static final String OIM_USERNAME = "xelsysadm";
20.  private static final String OIM_PASSWORD = "Welcome1";
21.  private static OIMClient oimClient = null;
22.  Hashtable env = new Hashtable();
23.  public UpdateLookup() {
24.   try {
25.    env.put(OIMClient.JAVA_NAMING_FACTORY_INITIAL,"weblogic.jndi.WLInitialContextFactory");
26.    env.put(OIMClient.JAVA_NAMING_PROVIDER_URL, OIM_URL);
27.    System.setProperty("java.security.auth.login.config", AUTH_CONF);
28.    System.setProperty("OIM.AppServerType", "wls");
29.    System.setProperty("APPSERVER_TYPE", "wls");
30.    oimClient = new OIMClient(env);
31.    oimClient.login(OIM_USERNAME, OIM_PASSWORD.toCharArray());
32.   } catch (Exception e) {
33.    e.printStackTrace();
34.   }
35.  }
36.  public void addLookupEntry(String LookupCode,String Lookup) {
37.   try {
38.    tcLookupOperationsIntf lookupOps = oimClient.getService(tcLookupOperationsIntf.class);
39.    lookupOps.addLookupValue("Lookup.City.Configuration", LookupCode, Lookup, Locale.getDefault().getLanguage(), Locale.getDefault().getCountry());
40.   } catch (Exception e) {
41.    e.printStackTrace();
42.   }
43.  }
44.  public void displayLookup(String lookupname) {
45.   try {
46.    tcLookupOperationsIntf lookupOps = oimClient.getService(tcLookupOperationsIntf.class);
47.    tcResultSet values = lookupOps.getLookupValues(lookupname);
48.    for (int i = 0; i < values.getRowCount(); i++) {
49.     values.goToRow(i);
50.     System.outprint(values.getStringValue("Lookup Definition.Lookup Code Information.Decode"));
51.     System.out.println("," + values.getStringValue("Lookup Definition.Lookup Code Information.Code Key"));
52.    }
53.  } 
54. catch (Exception e)
55.  {
56.    e.printStackTrace();
57.   }
58.  } 
59.  public static void main(String args[]) throws IOException, BiffException {
60.          String s2;
61.          String s1;
62.          UpdateLookup obj = new UpdateLookup();
63.          Workbook workbook = Workbook.getWorkbook(newFile("C:\Users\Desktop\test.xls"));
64.          Sheet sheet = workbook.getSheet(0);
65.          for(int i=1; i<2; i++)
66.          {      Cell cell1 = sheet.getCell(0, i);
67.              String s=sheet.getName();
68.           System.out.print(cell1.getContents());
69.               s2=cell1.getContents();
70.           Cell cell2 = sheet.getCell(1, i);
71.              s1= cell2.getContents();
72.              obj.addLookupEntry(s2,s1); 
73.     }
74.          }
75. }

4) Now run the program as shown in figure below.

5) Once the program runs successfully, Login to OIM Design Console and provide the required username and password as shown in figure below.

6) Open the lookup Lookup.City.Configuration and check its contents. It should be the same as that of Excel Sheet we have prepared in step 1.

7) So if any changes you make to the excel sheet in future, you just need to run this program and the Lookup gets updated dynamically.