tag:blogger.com,1999:blog-5374068975991293417.post5767219998130900442..comments2024-03-21T13:00:53.519+05:30Comments on Ritesh's Oracle Identity Management Help Engine: Flat File Reconciliation OIM 11g, OIM 11g R1, OIM 11g R2Ritesh Kumar Maddalahttp://www.blogger.com/profile/14911548149470191794noreply@blogger.comBlogger36125tag:blogger.com,1999:blog-5374068975991293417.post-30280993967714495012021-09-24T17:25:00.063+05:302021-09-24T17:25:00.063+05:30Hey I am trying to do the following step according...Hey I am trying to do the following step accordingly. my feedHr file is going into the archive folder. still the User is not showing in identity console , and there is no such error in log file too so what to do ??<br />please guide me!Nikita Panhalehttps://www.blogger.com/profile/10483427307800240629noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-22802375489554122832021-02-04T01:00:02.595+05:302021-02-04T01:00:02.595+05:30Hello Ritesh,
If we don't want to get this er...Hello Ritesh,<br /><br />If we don't want to get this error even for the first time, we have to ✔️ the matching only check box while doing mappings from staging table and oim table.<br /><br />Thanks & Regards<br />Mahesh Kumar ThiruveedulaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-89862816237252759842019-09-04T12:33:16.334+05:302019-09-04T12:33:16.334+05:30Thanks for sharing this information!
I totally agr...Thanks for sharing this information!<br />I totally agree with you. Your information is very interesting and important. I really like this information.Our easy web plans company is famous in Advanced<a href="http://lucidtechsystems.com/oracle-identity-manager-online-training/" rel="nofollow"> Oracle Identity Manager Online Training in Hyderabad </a>.<br />If you want to see our training venue then click on links: http://lucidtechsystems.com/oracle-identity-manager-online-training/<br />Call Now: +91-965-292-6376<br />Drop Mail: info@lucidtechsystems.com<br />LUCIDTECH SYSTEMShttps://www.blogger.com/profile/04228871316579497463noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-514770141629544782019-04-15T14:39:44.435+05:302019-04-15T14:39:44.435+05:30https://learnoracleidentity.blogspot.com/https://learnoracleidentity.blogspot.com/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-65016173930211349392018-01-25T14:48:14.651+05:302018-01-25T14:48:14.651+05:30• Nice and good article. It is very useful for me ...• Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating<b><a href="https://onlineitguru.com/azure-online-training-placement.html" title="Azure Online Training | Azure Online Training Bangalore | Online ITGURU " rel="nofollow">Azure Online course bangalore</a></b>Anonymoushttps://www.blogger.com/profile/16237727881027125758noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-28025615986878469132017-06-28T02:06:39.166+05:302017-06-28T02:06:39.166+05:30Hi,
I use Full recon in the GTC. But the recon cr...Hi,<br /><br />I use Full recon in the GTC. But the recon creates events for unchanged records too every time we run GTC. The event status is Update Succeeded for all events. Any idea why the evnts are generated for unchanged records in Full recon.?<br /><br />Thanks<br />DeepaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-34171281311926408472017-05-05T00:53:00.380+05:302017-05-05T00:53:00.380+05:30Hi Ritesh,
This blog is a very good learning, app...Hi Ritesh,<br /><br />This blog is a very good learning, appreciate it.<br /><br />Please provide some more about OIM stuffs, as We are very new in this technology.<br /><br />Thanks for sharing this.Ravi Ranjan Kumarhttps://www.blogger.com/profile/16023004826227147880noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-79959115733202374922017-02-15T12:30:44.987+05:302017-02-15T12:30:44.987+05:30Hi Ritesh,
Will U please provide the Flat File Pr...Hi Ritesh,<br /><br />Will U please provide the Flat File Provisioning in oim.<br />Anonymoushttps://www.blogger.com/profile/15274994141115143696noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-15492604282277640642016-08-18T19:17:38.350+05:302016-08-18T19:17:38.350+05:30Hi Ritesh,
I followed the above procedure but in l...Hi Ritesh,<br />I followed the above procedure but in log file it is not showing File Archived instead of that it is showing like below <br /><br />[2016-08-18T23:04:45.044+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] Job Listener, Job to be executed Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies<br />[2016-08-18T23:04:45.053+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] Method details Method details: executeJob<br />[2016-08-18T23:04:45.053+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] Method details executeJob Evaluate User Policies<br />[2016-08-18T23:04:45.063+00:00] [oim_server1] [WARNING] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] tcTskUsrEvaluatePolicies/init: maxWorkerCount: 20 batchSize: 500 maxExecutionTimeMins: null startTime: 1471561485063<br />[2016-08-18T23:04:45.281+00:00] [oim_server1] [WARNING] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] tcTskUsrEvaluatePolicies/execute<br />[2016-08-18T23:04:45.298+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000LPqKjEs0nnG6yzIbMG1Netcm000002,1:19885] [APP: oim#11.1.2.0.0] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-18656803090965323522016-06-23T14:07:40.737+05:302016-06-23T14:07:40.737+05:30Hi Abhinav,
Please try below workarounds -
1. Ve...Hi Abhinav,<br /><br />Please try below workarounds -<br /><br />1. Verify that you provided "Trusted Recon = Yes" while creating this GTC.<br /><br />2.Check the recon rule. <br /><br />3.Create Reconciliation Profile again.<br /><br />4.Check flat file and populate all mandatory fields with correct values.<br /><br />5.Run Reconciliation again.<br /><br />6.Check recon events<br /><br />ThanksRitesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-19580323884961716182016-06-23T12:30:31.110+05:302016-06-23T12:30:31.110+05:30Hi Ritesh,
This is abhinav here, as i have done t...Hi Ritesh,<br /><br />This is abhinav here, as i have done the same reconcillation process as in above blog but it's not working and throwing the error as ORA Error Code =>ORA-01400: cannot insert NULL into () ORA Error Stack =>ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 747<br />on the event management screen can u pls help me out with that Anonymoushttps://www.blogger.com/profile/02844737619076063752noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-32677322126427222762015-05-12T21:57:49.043+05:302015-05-12T21:57:49.043+05:30Hi Milan,
You can do reconciliation multiple time...Hi Milan,<br /><br />You can do reconciliation multiple times, just update the archived file with new user details and place it in reconciliation directory.<br /><br />And re-run the Scheduler. <br /><br />Hope this helps.<br /><br />Thanks & Regards<br />RiteshRitesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-14991949162492565042015-05-12T21:32:24.953+05:302015-05-12T21:32:24.953+05:30Hi ritesh!
Thanks for this helping post.
I need t...Hi ritesh!<br /><br />Thanks for this helping post.<br />I need to reconcile 2nd time from the same file, is there anyway for that?<br /><br />Regards, <br />Mian.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-14078691015336505802014-05-12T17:11:05.693+05:302014-05-12T17:11:05.693+05:30Hi Prashanth,
Exactly in which step you are getti...Hi Prashanth,<br /><br />Exactly in which step you are getting this error.<br /><br />If you are receiving this error in the step where you run Scheduler then check the Archive directory and Cut and paste hrfeed.csv file from Archive Directory to HRFEED directory.<br /><br />Or if you have csv file there then check for User permissions for that directory and give all permissions to that directory if you are using Linux.<br /><br />And please share log as well to investigate in depth.<br /><br />Regards<br />RiteshRitesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-91472483319535433392014-05-12T16:31:43.670+05:302014-05-12T16:31:43.670+05:30Hi Ritesh, When I am trying to follow these step...Hi Ritesh, When I am trying to follow these steps when click on continue after 2nd step i ma getting below error '' Either there are no parent files in the staging directory or the required access (Read) permissions are missing. "Anonymoushttps://www.blogger.com/profile/17753765038301294885noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-9568610426061798932014-03-18T01:07:30.582+05:302014-03-18T01:07:30.582+05:30Hi Ritesh,
Good sampling and explanation. The abo...Hi Ritesh,<br /><br />Good sampling and explanation. The above steps worked for me. Thanks.<br /><br />If I understand correctly, in the step 3 of your blog, that is 'Reconciliation Stagin', we are mapping the data coming through the flat file to OIM user data fields and in this process, we also create two new fields 'Role' and 'User- Type' whose values are string literals, 'OTHER' and 'End-user' respectively. This means, each user that we reconsile to OIM, we give these two values 'OTHER' and 'End-user'.<br /><br />But when I check the users created after recon in OIM, I see that the user type field has the value 'OTHER' and the ROLE assigned to the users are 'All Users'.<br /><br />I have checked the mapping in the reconciliation staging and it seems ok to me. The users first name, last name, organization, email are getting mapped correctly.<br /><br />Do you have a clue why this is happening and where else should I look for possible errors?Samhttps://www.blogger.com/profile/10972751738749946577noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-7086802692185242092014-02-05T11:43:27.268+05:302014-02-05T11:43:27.268+05:30Hi Ritesh,
I have changed the Source datatype to ...Hi Ritesh,<br /><br />I have changed the Source datatype to date in the mapping which i did not realise to change it before and it works fine.But,thanks a lot for your help..<br /><br />Regards,<br />Prasad Nandigam..<br /><br /> devhttps://www.blogger.com/profile/10543587808277952976noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-23983528855737626802014-02-04T16:40:05.442+05:302014-02-04T16:40:05.442+05:30Hi Dev,
In my opinion, do this:
1. Goto Settings...Hi Dev,<br /><br />In my opinion, do this:<br /><br />1. Goto Settings of Connector and change the Source Date Format to the Date Format of your choice. If this will not work then follow the Step 2.<br /><br />2. Create a new field - Date Format ( value must be : "YYY/MM/DD HH.MM.SS Z" ) in your Flat File and Map it with the Date Format of OIM fields. Follow all the process as it is, as given in this post , but during Settings of Generic connector specify the Source Date Format as "YYY/MM/DD HH.MM.SS Z".<br /><br />Hope this will help you.<br /><br />Regards<br />Ritesh MaddalaRitesh Maddalahttps://www.blogger.com/profile/14376837624250306753noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-82744322906971729182014-02-04T16:20:58.486+05:302014-02-04T16:20:58.486+05:30Hi Ritesh,
In Flat File Recon, how to send the us...Hi Ritesh,<br /><br />In Flat File Recon, how to send the users with start date and end date to oim..In my case, If I send the users normally without start date and end date,its working fine but if i include start date and end date in csv file.I am not getting the users in to OIM. Can you please help me with this. Is there any specific format to enter the start date and end date.When i check the log file its showing max size that I can enter is 7 but I want it in the format like(YYY/MM/DD HH.MM.SS Z)devhttps://www.blogger.com/profile/10543587808277952976noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-1036179325670113282014-01-29T13:29:35.100+05:302014-01-29T13:29:35.100+05:30Hi Ritesh
Multivalued taget fields means.Let us su...Hi Ritesh<br />Multivalued taget fields means.Let us suppose i have a target system in which a user is assigned in three groups and now i want to do target recon through flat file and link with oim user account during recon i also need to pass the group names in which he is assigned in a separate file. <br /> i also didn't work on it i read this in one developers document of oracle.. this is my scenerio can you help me in any way<br /><br />Thank YouAnonymoushttps://www.blogger.com/profile/17148053391340623330noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-89211071565579645622014-01-28T01:27:45.900+05:302014-01-28T01:27:45.900+05:30Hi Narasimha,
1. May be OIM doesn't provide P...Hi Narasimha,<br /><br />1. May be OIM doesn't provide Password field to Map.(I am not sure, please do some R&D on this)<br />2. What do you mean by Multivalued Target Field ?<br /><br />Regards....Ritesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-10663626818514285372014-01-27T14:41:15.790+05:302014-01-27T14:41:15.790+05:30Hi Ritesh
i have taken password field in flat fil...Hi Ritesh<br /><br />i have taken password field in flat file as you said and when i was mapping the flatfile fields to oim fields i cant find the password field in oim fields so how can i map.. is there any another way....<br />i also have one more issue please help me. how to do multivalued target flat file recon . if you have any document regarding multivalued target recon please post it in your blog or please send to my mail i.e narasimha.idm@gmail.com <br /> thank you...Anonymoushttps://www.blogger.com/profile/17148053391340623330noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-52495337845993817182014-01-23T16:08:32.589+05:302014-01-23T16:08:32.589+05:30Hi Narasimha,
Glad to know, that it worked for yo...Hi Narasimha,<br /><br />Glad to know, that it worked for you. Since this post is just an example, I haven't used Password field, in Flat File. If you want to try with the Password field in your Flat File , please do follow the same steps mentioned in the post and create a new Flat File Reconciliation connector with Password field. <br /><br />For now you can update a password of the User you have created by Flat File by logging into OIM sysadmin with OIM administrator from the OIM user management console and relogin to OIM with the newly created user credentials.<br /><br />Hope this will help you.<br /><br />Regards<br />Ritesh MaddalaRitesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-75519530485264898702014-01-23T15:50:23.616+05:302014-01-23T15:50:23.616+05:30hi ritesh
this is narasimha
i followed all the st...hi ritesh<br /> this is narasimha<br />i followed all the step and i got the output. now i want to login with the user created by the gtc then will be the password of that userlogin<br />how to give the password attribute through flat file or is there any other way to send password to oim from flat fileAnonymoushttps://www.blogger.com/profile/17148053391340623330noreply@blogger.comtag:blogger.com,1999:blog-5374068975991293417.post-29809399860470674032013-12-11T19:49:14.010+05:302013-12-11T19:49:14.010+05:30Hi Anand,
In my opinion it is due to false settin...Hi Anand,<br /><br />In my opinion it is due to false setting of your Quartz Scheduler timer.<br />Please try to follow the below link, and let me it worked or not<br /><br />http://yourhelperall.blogspot.in/2013/05/reconciliation-issue-misfirehandler.html<br /><br />Regards<br />RiteshRitesh Kumar Maddalahttps://www.blogger.com/profile/14911548149470191794noreply@blogger.com