tcSDK/validateRecociliationFieldMappings error while activating process form

(Doc ID 2284073.1)

Last updated on JULY 06, 2017

Applies to:

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


The following error occurs while trying to activate a process form version.

[2017-06-07T17:03:59.933-05:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 88eaa00eefcf3cd4:1bd247dd:15c83f8bc0c:-8000-0000000000002bef,0] [APP: oim#] Class/Method: tcSDK/validateRecociliationFieldMappings encounter some problems: {1}[[
at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(
at com.thortech.xl.dataaccess.tcDataBase.createException(
at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(
at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(
at com.thortech.xl.dataobj.PreparedStatementUtil.execute(
at com.thortech.xl.dataobj.tcSDK.validateReconciliationFieldMappings(


at weblogic.rmi.internal.BasicServerRef.handleRequest(
Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(

The issue can be reproduced at will with the following steps:

1. Create a process form.
2. Create a child form.
3. Update the process(parent) form, by creating new version.
4. Activate process (parent) form.


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