OIM 11g recon error
912744Apr 17 2012 — edited Feb 7 2013Hi All
I have a custom target recon job. When the job runs for the first time, recon events are created and processed, but when I run the following query, I don't see the events getting completed:
select rb_key, rb_batch_status, rb_profile_name from recon_batches where rb_batch_status='Initiated';
All my events stay in Initiated state.
If I run the job again for the same users, I get the following error:
oracle.iam.reconciliation.exception.ReconciliationException: Exception occurred while inserting data into table RA_APP_NAME145 due to
Internal Exception: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "OIM_OIM.RECON_CREATE_EVENTS", line 69
ORA-06512: at "OIM_OIM.RECON_CREATE_EVENTS", line 122
ORA-06512: at line 1
has anyone faced this issue before and whats the resolution to this?