Flat File Reconciliation OIM 11g, OIM 11g R1, OIM 11g R2

OIM 11G : Using Flat File as Trusted Resource for Reconciliation of Users.

Steps

1. CREATE SHARED DRIVE, CSV AND ARCHIVE
2. CREATE GENERIC CONNECTOR
3. RUN SCHEDULER AND CONFIRM
4. CREATING RULE GENERATORS
5. CREATING RECONCILATION PROFILE
6. RUN SCHEDULER
7. SEARCH RECONCILIED USER

-------------------------------------------------------------------------------------------------------

1. CREATE SHARED DRIVE, CSV AND ARCHIVE

    Create a directory Archive in C:\myDIR\HRFEED\

  

Create a csv file, name it hrfeed.csv and place it in C:\myDIR\HRFEED\ with file containing below details.
  

2. CREATE GENERIC CONNECTOR

    Login to sysadmin page of OIM with url

    http://localhost:14000/sysadmin

    place your hostname and port accordingly.

    Enter OIM user name and password and sign in to OIM sysadmin console

  Click on Generic Connector link in the Left Pane

Click on Create to create a new Generic Connector.

 

 Populate the fields as given below, uncheck provisioning and continue.

Now Specify Correct parameters in step 2 and continue.

Now in step 3 a pop-up will get displayed showing the mapping between your flat file attributes with OIM.

Here we require two new attributes in Reconciliation Staging table to map it with OIM Table.

Click on + icon in Reconciliation Staging table to add new attributes.

Fill all details as given below and click continue.

  

  

 

Repeat above steps to create userType attribute in Reconciliation Staging Table.

 

 

Now it's time to map Reconciliation Staging Table to OIM table.
Click on the edit button of UserLogin Attribute of OIM table and click continue to map.

 

 

 After mapping each and every attribute we will get following matching lines.

Click close to jump into step 5.



Click save and wait for some time



After clicking save button connector creation confirmation window will appear . Close and go to sysadmin console.



3. RUN SCHEDULER AND CONFIRM

Click on Scheduler link on the Left Pane under System Management.





A pop up will get appear, click on search arrow to get the list of scheduler jobs.



Find and open OIM_FlatFile_Recon_GTC and click Run now button.



Confirm job is running.



Go to oim_server terminal and watch for the error. If you receive the same error, then you need to configure the newly created GTC.



4. CREATING RULE GENERATORS

Design Console Configuration Needed . If it is already configured then continue to the below steps or configure design console using following link

http://onlineappsdba.com/index.php/2010/10/11/part-vii-install-configure-oim-design-console-oracleidm-11g-step-by-step-installation-of-oam-oim-oaam-oapm-oin/

To debug the above error we need to create rule generators for the newly created GTC.

Open design console from windows start menu

or alternatively you can also start by going to path

MIDDLEWARE_HOME\Oracle_IDM1\designconsole\xlclient

Login to design console with OIM user name and password.

Click and open resource object form, from left panel, and click query button from toolbar, then go to resource objects table tab. In this step we will confirm that the newly created connector appears in database records.

Click on OIM_FlatFile_Recon_GTC record and open Resource Objects Tab

Select and Copy name field.

Now open Reconciliation Rule form and paste the copied resource object name in previous step into Object field and click on Query icon.

If no record message appears, we will create a new one, a new Rule for flat file reconciliation.

So to create a rule, populate fields as below and save it.

Click on Add Rule Element button.

Fill up the fields as below and save it.

Close the error message and exit.

Click yes to exit.

Click save and close the error message if any.

Close the form

5. CREATING RECONCILATION PROFILE
    Open Resource Object form, query for records.

Open Resource Object Table Tab and select OIM_FlatFile_Recon_GTC record

Now open Resource Object.

Go to Object Reconciliation Tab in above panel

Click on Create Reconciliation Profile

Cut and paste hrfeed.csv file from Archive Directory to HRFEED directory.

6. RUN SCHEDULER Login to sysadmin.

      Click on scheduler link on the Left Pane.

A pop up will get appear, click on search arrow to get the list of scheduler jobs.

Find and open OIM_FlatFile_Recon_GTC and click Run now button.

Confirm job is running.

Open oim_server terminal and check for the following message without any error.

7. SEARCH RECONCILIED USER

Login to oim self service console using

http:\\localhost:14000\oim

Change IP address and port Accordingly. Click on User link on left pane

Click on search and find new user reconciled from the flat file.

Hope this was helpful post. Please give your Valuable feedback and comments for any queries.