My Oracle Support Banner

ORA-20001 and "..ITRES_KEY": invalid identifier": During Custom ICF Recon (Doc ID 1543109.1)

Last updated on MAY 02, 2018

Applies to:

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

Symptoms

Environnement
============
OIM version: 11.1.2.0.4
App Server: Weblogic 10.3.6
DB: Oracle 11g 11.2.0.1
OS: Oracle linux 6.3
Custom connector using ICF
Target System is webservice

Problem
=======
1) Create an OIM user and provision it

2) Delete user on target and do a recon, user is revoked

3) Re-create the user and do a recon

User is not linked and the status does not change (stays as revoked)

Logs shows the following:

[oim_server1] [ERROR] [] [oracle.iam.reconciliation.impl] [tid: [ACTIVE].ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: c4b0db765c688017:-60e71042:13dc08f15da:-8000-0000000000000004,0] [APP: oim#11.1.2.0.0] Generic Information: {0}[[
oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing  Batch no 3211  ORA-20001: An error was encountered -  XL_SP_ReconBlkUserMatch while Processing Batch ID  3211   ORA-00904: "RA_BO"."REX_ITRES_KEY": invalid identifier
ORA-06512: at "OAMT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 473
ORA-06512: at "OAMT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69
ORA-06512: at line 1

at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1482)
at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:906)
at oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:76) 

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.