After Restoring OIM Schema DB, Recon Jobs Fail to Run Successfully. (Doc ID 1962885.1)

Last updated on MARCH 08, 2017

Applies to:

Identity Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

Following restore of OIM DB instance, Recons no longer work.

Log shows the following error:

[2015-01-12...] [ERROR] [] [oracle.iam.reconciliation.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: ...] [APP: oim#11.1.2.0.0] Generic Information: {0}[[
oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms