Monday, October 12, 2015

Configuring Transformation of Data During Reconciliation -PSFT_ER-11.1.1.5.0


Configuring Transformation of Data During Reconciliation -PSFT_ER-11.1.1.5.0

You can configure the transformation of reconciled single-valued data according to your requirements. For example, you can use the Currency Code value to create a value for the Currency Code field in Oracle Identity Manager.

To configure the transformation of data:

  • Write code that implements the required transformation logic in a Java class.
            The following sample transformation class modifies a value for the Currency Code attribute by                             prefixing a dollar sign ($) in the Currency Code value received from the target system

package com.transform;import java.util.*;
public class MyTransform {

      /*
      Description:Abstract method for transforming the attributes
      param hmUserDetails<String,Object>
      HashMap containing parent data details
      param hmEntitlementDetails <String,Object>
      HashMap containing child data details
      
      */
      public Object transform(HashMap hmUserDetails, HashMap                  
      hmEntitlementDetails,String sField) {
      /*
       * You must write code to transform the attributes.
       Parent data attribute values can be fetched by
       using hmUserDetails.get("Field Name").
       *To fetch child data values, loop through the
       * ArrayList/Vector fetched by hmEntitlementDetails.get("Child Table")
       * Return the transformed attribute.
       */
      System.out.println("sfield =" + sField);
      String sCurrencyCode= (String)hmUserDetails.get(sField);
      sCurrencyCode = "$"+sCurrencyCode;
      return sCurrencyCode;
      }
} /* End */
  • Create a JAR file to hold the Java class.
  • Run the Oracle Identity Manager Upload JARs utility to post the JAR file created in Step 2 to the Oracle Identity Manager database. This utility is copied into the following location when you install Oracle Identity Manage

              For Microsoft Windows:
                OIM_HOME/server/bin/UploadJars.bat


                For UNIX:
                 OIM_HOME/server/bin/UploadJars.sh
  • When you run the utility, you are prompted to enter the login credentials of the Oracle Identity Manager administrator, URL of the Oracle Identity Manager host computer, context factory value, type of JAR file being uploaded, and the location from which the JAR file is to be uploaded. Specify 1 as the value of the JAR type


  • If you created the Java class for validating a process form field for reconciliation, then:
  1. Log in to the Design Console.
  2. Search for and open the message-specific configuration lookup definition, in this example, the Lookup.PSFT.Message.WorkForceSync.Configuration lookup definition for the WORKFORCE_SYNC message. 
  3. Check for the parameter Transformation Lookup Definition in this lookup definition. The Decode value specifies the name of the transformation lookup. In this example, the Decode value is Lookup.PSFT.HRMS.WorkForceSync.Transformation.
  4. Search for and open the Lookup.PSFT.HRMS.WorkForceSync.Transformation lookup definition.
  5. In the Code Key column, enter Currency Code. In the Decode column, enter com.transform.MyTransform.
    Here, the Code Key value specifies the column name of the field you want to validate. The Decode value is the complete package name of the Java class that has the transformation logic.
  6. Save the changes to the lookup definition.
  7. Search for and open the message-specific configuration lookup definition, in this example, the Lookup.PSFT.Message.WorkForceSync.Configuration lookup definition.
  8. Set the value of the Use Transformation entry to yes.
  9. Save the changes to the lookup definition.
  • Remove the PeopleSoftOIMListener.ear file from the application server.
  • Copy the transformation JAR file created in Step 2 to the following directory:
    CONN_HOME/listener/deployable-archive/PeoplSoftOIMListener.ear/PeoplSoftOIMListener.war/WEB-INF/lib
  • Redeploy the PeopleSoftOIMListener.ear file on the application server. To do so, run the following command:
    ant redeploy
          (or)

      Redeploy the application in the web logic console 

  •   Login web logic console and Lock & Edit
  •   Go to Services - Deployments- PeopleSoftOIMListener - Update
  •    Activate Lock and Edit   


        
        

        No comments:

        Post a Comment

        Other Posts