My Oracle Support Banner

"OIM_SP_RECONBLKUSRMLSWRAPPER is invalid" After Restoring OIM Schema DB Resulting in Failure of Recon Jobs (Doc ID 1962885.1)

Last updated on FEBRUARY 27, 2018

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 job 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

To view full details, 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 a vibrant support community of peers and Oracle experts.