ORA-00904: "UD_ADUSER"."UD_ADUSER_TESTATTRIBUTE": invalid identifier error after running AD User Target Recon job (Doc ID 2192591.1)

Last updated on OCTOBER 12, 2016

Applies to:

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

Symptoms

On : 11.1.2.3.0 version, Reconciliation

AD Target User Recon job references a field that does not exist in UD_ADUSER table or AD User form and reports the following error:

"java.sql.SQLException: ORA-20001: Error occured in XL_SP_ReconBlkChildMthAcntCRUD while processing Batch ID - 682 XL_SP_ReconBlkChildMthAcntCRUD failed e_xlSpReconBlkChildMthAcntCRUD -
FORMAT_ERROR_BACKTRACE: ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 698
ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3528

FORMAT_ERROR_STACK: ORA-20001: An error was encountered - -904 -ERROR- ORA-00904: "UD_ADUSER"."UD_ADUSER_TESTATTRIBUTE": invalid identifier
 -20001 -ERROR- ORA-20001: An error was encountered - -904 -ERROR- ORA-00904: "UD_ADUSER"."UD_ADUSER_TESTATTRIBUTE": invalid identifier


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