Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trusted Recon Error in OIM 11g

S.K.NJul 17 2012 — edited Jul 30 2012
Hi,

Getting the following exception when I tried to run trusted recon in OIM 11g.

oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 3925
ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71
ORA-06512: at line 1

at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1330)
at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:696)
at oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:518)
at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:131)
at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)

I have crossed check the mappings especially the mandatory fields declared in OIM. Events gets generated but it is in Data Received state, not getting linked to user.

Please help me to fix this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2012
Added on Jul 17 2012
12 comments
811 views